Database News: MySQL Newsletter - Special Edition: Developing and Managing MySQL Applications

MySQL Newsletter
Special Edition: Developing and Managing MySQL Applications
mysql-newsletter@sun.com

This is a special edition of the MySQL Newsletter. In addition to the regular MySQL Monthly Newsletter, a MySQL Newsletter Special Edition is issued each quarter that highlights technical information on topics most relevant to MySQL DBAs and developers. This edition is focused on Developing and Managing MySQL Applications with resources to help you get started and manage your MySQL environment more efficiently.

Highlights

- Oracle Magazine: Open for Business - MySQL community wins with better innovation, support, and integration
- Event: MySQL Developer Room at FOSDEM 2011 - Belgium (February 5)
- Event: MySQL at Mobile World Congress - Spain (February 14-17)
- Seminar: Get the Most Out of MySQL - Customer Stories - Italy (February 1)
- Seminar: Improve Performance and Scalability with the Latest from MySQL - EMEA (February 10 & 16)
- Live Webinar: NEW for ISVs and OEMs: MySQL Enterprise Edition - Adding Value to Your Products (February 10)
- Live Webinar: MySQL Essentials Part 7: MySQL Administration and Management Essentials (February 22)
- Live Webinar: MySQL Reference Architectures for Massively Scalable Web Infrastructure (February 24)
- Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - EMEA

Developing PHP Applications with MySQL

- Blog: mysqlnd plugins for PHP in practice
- On Demand Webinar: How to Develop Simple PHP Applications for MySQL
- On Demand Webinar: Designing to Scale to 200K Transactions per Second with Open Source: MySQL, Java, curl, PHP

Developing Java Applications with MySQL

- Webcast: MySQL Tips for Java Developers - Expert Interview
- On Demand Webinar: How to Develop Simple Java Applications with MySQL
- On Demand Webinar: Blazing Java Application Performance: Connector/J Performance Gems
- On Demand Webinar: How to Develop MySQL-Backed Java Applications with Netbeans, JRuby-on-Rails & Glassfish
- On Demand Webinar: Automatic Java Application Multi-Platform Deployment Using MySQL Connector/MXJ
- Case Study: SonicWALL Achieves 100% ROI in Under Nine Months Using MySQL Embedded Database
- Case Study: Clickability Delivers Web Content Management SaaS Solution using MySQL

Developing MySQL Applications on Windows

- White Paper: A Visual Guide to Installing MySQL on Windows
- On Demand Webinar: How to Develop Simple .NET Applications for MySQL
- On Demand Webinar: Getting Started with MySQL on Windows
- On Demand Webinar: Building MySQL on Windows
- On Demand Webinar: Getting Started Using MySQL as an Embedded Database with Windows Applications
- On Demand Webinar: What's New in MySQL Connector/NET 6.2
- Presentation: MySQL and the ADO.NET Entity Framework
- Case Study: CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server
- Case Study: ScienceLogic Relies on MySQL to Deliver Integrated Network Management Appliance

Managing MySQL Applications

- White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs
- White Paper: MySQL Enterprise Monitor 2.3: What's New
- White Paper: MySQL Enterprise Monitor: Business Overview
- White Paper: MySQL Cluster Manager
- On Demand Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL
- Demo: MySQL Workbench Demos
- Case Study: Big Fish Games Triples Database Performance with MySQL Query Analyzer

MySQL Training and Certification

- Training: Introduction to MySQL 5.5
- Training: MySQL and PHP - Developing Dynamic Web Applications
- Training: MySQL for Developers
- Certification: Save 20% and Get a Free Certification Retake with MySQL Certification Value Packages

-------------------------------------------------------------------

Highlights

Oracle Magazine: Open for Business - MySQL community wins with better innovation, support, and integration
David A. Kelly

Sometimes, relatively small things can make a big impact. Take the case of the MySQL database. First released in 1995 and purchased by Sun in 2008, MySQL has quickly graduated from the realm of hobbyists to the world of business, becoming the leading open source database for many Web applications and an integral part of the LAMP Web application stack.

Read the Magazine Article:
http://www.oracle.com/technetwork/issue-archive/2011/11-jan/o11mysql-194109.html

Event: MySQL Developer Room at FOSDEM 2011
Brussels, Belgium - February 5, 2011

FOSDEM is one of the largest gatherings of Open Source Developers and Projects in Europe. In 2011, the event will take place on February 5th and 6th in Brussels, Belgium. We will have a Developer Room titled "MySQL and Friends", which will provide a venue for talks about MySQL and related projects. The MySQL Developer Room will be open on Saturday, February 5th, from 13:00 to 19:00. If you're around, come join us and meet with MySQL experts!

Learn More:
http://forge.mysql.com/wiki/FOSDEM_2011

View the Sessions and Speakers:
http://forge.mysql.com/wiki/FOSDEM_2011_Developer_Room

Event: MySQL at Mobile World Congress
Barcelona, Spain - February 14-17, 2011

With more than 49,000 communications industry attendees, Mobile World Congress is where the industry comes together. Join us to learn how MySQL and other Oracle solutions enable innovative services while reducing the cost and complexity of infrastructure software and hardware.

Learn More:
http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=109912&src=6973382&src=6973382&Act=4

Seminar: Get the Most Out of MySQL - Customer Stories
Milan, Italy - February 1, 2011

MySQL is the world's most popular open-source database and many organizations in Italy selected MySQL to power their mission critical applications. In this event you will hear stories from MySQL customers and learn how ContactLab, Buongiorno and Cineca are benefitting from the use of MySQL.

Learn More and Register for this Italian Seminar:
http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=129578&src=7011252&src=7011252&Act=99

Seminar: Improve Performance and Scalability with the Latest from MySQL
Paris, France - February 10, 2011
London, UK - February 16, 2011

With the acquisition of Sun, Oracle continued to invest and improve MySQL - to make MySQL a better MySQL. Come join us to see what we have accomplished - from the MySQL database itself and across the MySQL product suite of development, management, and monitoring tools.

Learn More and Register for the French Seminar:
http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=129864&src=7011252&src=7011252&Act=118

Learn More and Register for the English Seminar:
http://eventreg.oracle.com/webapps/events/ns/EventsDetail.jsp?p_eventId=129696&src=7011252&src=7011252&Act=100

Live Webinar: NEW for ISVs and OEMs: MySQL Enterprise Edition - Adding Value to Your Products
Thursday, February 10, 2011 - 9:00AM PT

With the release of MySQL 5.5, all of the advanced capabilities of MySQL Enterprise Edition are now available to OEMs to be distributed with their commercial products. In this technical webinar, Sr. Product Managers and MySQL experts Mike Frank and Rob Young will review new options for OEMs, which are new or improved in the recently released MySQL version 5.5.

Live Webinar: MySQL Essentials Part 7: MySQL Administration and Management Essentials
Tuesday, February 22, 2011 - 9:00AM PT

Join us to learn the essential key steps to administering and maintaining your MySQL database. From command-line utilities to MySQL Workbench to MySQL Enterprise Monitor, we'll show the fundamentals of administering MySQL. Plus, we'll share how to create and execute backup strategies, including tools like MySQL Enterprise Backup for on-line hot backups.

Live Webinar: MySQL Reference Architectures for Massively Scalable Web Infrastructure
Thursday, February 24, 2011 - 9:00AM PT

In this webinar, we present a series of Reference Architectures for small, medium and large Web properties. You will learn about the components common to most web properties including Session Management, Authentication, eCommerce and Content Management. Optimum deployment architectures and topologies are defined based on sizing and availability requirements for each environment. We will also discuss the unique requirements for Large Social Networking applications.

Live Webinar: What's New: MySQL 5.5 and MySQL Enterprise Edition - EMEA

Come join us to see what we have accomplished - from the MySQL database itself and across the MySQL product suite of development, management, and monitoring tools. You'll also hear about new innovative professional support services offerings aimed at quickly improving the performance of your business-critical MySQL databases and applications.

Register for the Italian Webinar on February 17 at 10:00 CET:
http://www.mysql.com/news-and-events/web-seminars/display-607.html

Register for the French Webinar on February 28 at 10:00 CET:
http://www.mysql.com/news-and-events/web-seminars/display-609.html

-------------------------------------------------------------------

Developing PHP Applications with MySQL

Blog: mysqlnd plugins for PHP in practice
Johannes Schlüter

If you follow my blog or twitter stream, you might know I've recently been at Barcelona to attend the PHP Barcelona conference. Conferences are great for exchanging ideas, and here is one of the ideas I discussed with Combell's Thijs Feryn. They are a hosting company providing managed MySQL instances to their customers, as such they run multiple MySQL servers and each server serves a few of their customers.

Read this Blog Post:
http://schlueters.de/blog/archives/146-mysqlnd-plugins-for-PHP-in-practice.html

On Demand Webinar: How to Develop Simple PHP Applications for MySQL

In this technical webinar, MySQL developer Johannes Schlüter will show you the essentials for creating dynamic web content using MySQL and PHP. He will also discuss many of the fundamental elements used when developing PHP applications with MySQL, including the frameworks, APIs, security features, and asynchronous queries.

On Demand Webinar: Designing to Scale to 200K Transactions per Second with Open Source: MySQL, Java, curl, PHP

It is possible to build an ad-engine that can serve up more ads than Twitter to an audience larger than Twitter's, using fewer than 10 MySQL servers producing more then 200K Transactions per Second across a Multi-Terabyte store with all open source software. MySQL with InnoDB/myISAM, curl, PHP, and Java are the only components that are necessary for this linearly scaling engine without user-facing downtime.

-------------------------------------------------------------------

Developing Java Applications with MySQL

Webcast: MySQL Tips for Java Developers - Expert Interview

MySQL is the world's most popular open-source database, and there are a lot of Java developers who use MySQL databases in their applications. In this Deep Dive, Mark Matthews, architect for Enterprise Tools Team at Oracle, demonstrated some of the techniques that can help Java developers get more out of their applications that use MySQL.

Watch the Webcast:
http://java.sun.com/developer/media/deepdivemysqljava.jsp

On Demand Webinar: How to Develop Simple Java Applications with MySQL

Java is among the most popular development languages for MySQL applications. In this webinar, Java and MySQL expert Mark Matthews will present the basic knowledge for you to get started developing and deploying simple Java applications with MySQL, including installation pre-requisites and process, options in architecture and frameworks, as well as how to handle transactions.

On Demand Webinar: Blazing Java Application Performance: Connector/J Performance Gems

In this session, the author of Connector/J, Mark Matthews, will show you how to wring that last little bit of performance out of your Java applications deployed on MySQL by not using the out-of-the-box configuration. Connector/J has nearly 200 configuration options, many of which affect performance. Mark will show you how to move from generic to customized, illustrating how to set Connector/J options that will deliver the best performance for your specific application.

On Demand Webinar: How to Develop MySQL-Backed Java Applications with Netbeans, JRuby-on-Rails & Glassfish

Join us for this informative technical webinar presented by Arun Gupta, where he will demonstrate how to leverage the latest version of the Netbeans IDE to quickly and easily develop and deploy MySQL and Glassfish backed applications using the JRuby-on-Rails framework.

On Demand Webinar: Automatic Java Application Multi-Platform Deployment Using MySQL Connector/MXJ

Connector/MXJ is a Java utility package that makes the MySQL database appear to be a Java-based component. With MySQL Connector/MXJ, you can reduce installation barriers for your end user customers by simply adding an additional parameter to the JDBC connection url which will cause the database to start when the first connection is made.

Case Study: SonicWALL Achieves 100% ROI in Under Nine Months Using MySQL Embedded Database

SonicWALL started using MySQL 5.0 in July 2008, and within just six months of using MySQL, SonicWALL was able to: Lower their cost of goods sold (COGS); Shorten new product time-to-market through the efficiencies they gained in Development, Quality Assurance, Training, and Documentation; and, Reduce the number of trouble tickets they received by over 20%, in addition to other gains.

Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_sonicwall.php

Case Study: Clickability Delivers Web Content Management SaaS Solution using MySQL

Clickability is the global leader in on demand Web Content Management, serving over 350 million page views per month for hundreds of customers, including Cisco, NetApp, Philly.com and CNN Interactive. MySQL stores the core application data which is used across multiple applications that include serving 500+ million advertisements and distributing 10+ million emails every month.

Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql-cs-clickability.php

-------------------------------------------------------------------

Developing MySQL Applications on Windows

White Paper: A Visual Guide to Installing MySQL on Windows

This paper will guide you through the steps and tools needed to get up and running quickly with MySQL on Windows using familiar terms, comparisons, and language. Its goal is to put in place basic knowledge and building blocks you will need in conjunction with added references to resources as you continue to drill down further into the more advanced features of MySQL.

Read this White Paper:
http://www.mysql.com/why-mysql/white-papers/visual_guide_to_installing_mysql_windows.php

On Demand Webinar: How to Develop Simple .NET Applications for MySQL

In this webinar we will explore the use of MySQL as the underlying database for .NET applications. Using several example programs, we will dive into how to develop a few starter applications for MySQL in C# and ASP.Net using Visual Studio. We will also guide you through the process from installing MySQL Connector/NET, setting up Visual Studio, starting a project, designing, coding and running these simple .NET apps.

On Demand Webinar: Getting Started with MySQL on Windows

Join us for this informative technical webinar with Mike Frank, Sr Product Manager at Oracle. In this presentation we'll cover the benefits of deploying MySQL on Windows. You will learn the basic "How-To's" of installation, security and configuration. We will show you how to start using MySQL tools on Windows, such as MySQL Workbench and MySQL Enterprise Monitor with the Query Analyzer.

On Demand Webinar: Building MySQL on Windows

In this presentation we'll demonstrate how to setup an environment for building MySQL on Windows from source. While not strictly necessary, installing and running the Windows build system in a virtual machine allows for a single source repository to be shared among multiple flavors of Windows and/or other operating systems.

On Demand Webinar: Getting Started Using MySQL as an Embedded Database with Windows Applications

In this presentation we will cover the benefits of deploying MySQL Embedded Database with your Windows applications. You will learn the basic "How-Tos" of installation, security and configuration. You'll also learn how to use MySQL Connector/NET and Connector/ODBC, and how to ensure high availability and fault tolerance for MySQL on Windows.

On Demand Webinar: What's New in MySQL Connector/NET 6.2

In this presentation we will explore the benefits of developing Windows applications with MySQL. We will also cover development best practices with Visual Studio and how to get the most from the latest version MySQL Connector/Net.

Presentation: MySQL and the ADO.NET Entity Framework

In these presentation slides, Reggie Burnett, MySQL Software Engineer at Oracle explained how to leverage the Microsoft ADO.NET Entity Framework with MySQL. He presented a brief overview of the entity framework, a peek under the hood on how Connector/Net works with the entity framework and demonstrated using MySQL and the Entity Framework together.

View the Presentation:
http://www.mysql.com/why-mysql/windows/mysql_ado.net_entity_framework.php

Case Study: CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server

CONCEIVIUM Business Solutions ensures that BlackBerry Enterprise Servers are up and performing optimally 24X7 for three of the world's top five banks, The Coca Cola Company, IBM Global Services and many other primarily Fortune 500 organizations. With MySQL, CONCEIVIUM's Mobile Monitor/Analyzer Agents have achieved a 70% performance gain and are now able to analyze over two gigabytes of data per day and perform thousands of transactions per second.

Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_conceivium.php

Case Study: ScienceLogic Relies on MySQL to Deliver Integrated Network Management Appliance

To give the entire IT organization better visibility and control over the performance and availability of their networks, systems and applications, ScienceLogic relies on the performance and scalability of MySQL to process real-time information from thousands of networked devices.

Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_sciencelogic.php

-------------------------------------------------------------------

Managing MySQL Applications

White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs

This paper highlights how MySQL Workbench can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.

Read this White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql-wp-workbench.php

White Paper: MySQL Enterprise Monitor 2.3: What's New

MySQL is proud to announce the new release of MySQL Enterprise Monitor 2.3. This release can be used to monitor MySQL Servers that are part of a MySQL Cluster deployment. MySQL Enterprise Monitor 2.3 also improves general monitoring for MySQL and the Operating System by adding a set of new graphs for monitoring transactions and the new features available in InnoDB 1.1.

Read the English White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php

Read the German White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php.de

Read the Italian White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php.it

Read the French White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-whatsnew.php.fr

Try MySQL Enterprise Edition Now:
http://www.mysql.com/trials/

White Paper: MySQL Enterprise Monitor: Business Overview

The MySQL Enterprise Monitor is designed to scale DBA resources by providing a unified, informed view into the health, security, performance and availability of an entire MySQL server environment. This paper explores the MySQL Enterprise Monitor in detail and explains how it can be leveraged as a "Virtual MySQL DBA" assistant to help over-extended DBAs proactively manage more MySQL servers with less time and effort.

Read the English White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php

Read the German White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php.de

Read the Italian White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php.it

Read the Japanese White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql-wp-enterprise-monitor-virtualdba.php.ja

White Paper: MySQL Cluster Manager

MySQL Cluster Manager simplifies the creation and management of the MySQL Cluster database by automating common management tasks. As a result, Database Administrators (DBAs) and Systems Administrators are more productive, enabling them to focus on strategic IT initiatives and respond more quickly to changing user requirements.

Read this White Paper:
http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_manager.php

On Demand Webinar: MySQL Enterprise Backup - Online "Hot" Backup for MySQL

Online backup has been one of the most requested features for MySQL. With MySQL Enterprise Backup, developers and DBAs have the tools they need to safely and rapidly backup and restore their databases. In this webinar we will go into the advantages of Hot "Online" backups. We will show how MySQL Enterprise Backup supports full, incremental, partial, and compressed backups that allow you to perform consistent Point-in-Time Recovery, as well as saving both time and money.

Demo: MySQL Workbench Demos

Watch these self-running demos to learn how MySQL Workbench can help with Data Modeling, Reverse and Forward Engineering, Change Management and Documentation.

Watch the Demos:
http://www.mysql.com/products/workbench/demo.html

Case Study: Big Fish Games Triples Database Performance with MySQL Query Analyzer

Big Fish Games is a global leader in the online games industry, with over 25 million unique customer accounts and over 2.5 million visitors per month. MySQL allowed Big Fish Games to quickly grow their business with lower cost and hardware requirements, and has scaled with the company as it has grown into an industry leader. With the MySQL Query Analyzer, Big Fish Games was able to identify and analyze problematic SQL code, and tripled its database performance within three days, rather than weeks.

Read this Case Study:
http://www.mysql.com/why-mysql/case-studies/mysql_cs_bigfishgames.php

-------------------------------------------------------------------

MySQL Training and Certification

Training: Introduction to MySQL 5.5

This one-day seminar covers all the new features and key enhancements to MySQL 5.5 and the MySQL Enterprise Edition, including Performance, Scalability, Availability and Backups. Instructor lecture is supported by recorded product demonstrations. By attending this course, you learn how to plan your use of the MySQL 5.5 product release more effectively.

Learn More:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D71615GC10

Training: MySQL and PHP - Developing Dynamic Web Applications

Through a hands-on approach, this instructor-led course will help you improve your PHP skills and combine them with time-proven database management techniques to create best-of-breed web applications that are efficient, solid and secure.

Learn More:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D62048GC10&p_org_id=1001&lang=US

Training: MySQL for Developers

This course is the foundation course for developers planning on designing and implementing applications that make use of MySQL. It covers essential SQL statements for data design, querying, and programming.

Learn More:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getCourseDesc?dc=D61830GC10&p_org_id=1001&lang=US

View the Complete List of MySQL Training Courses:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getsearchpage?page_id=13&p_search_category_id=1488

Certification: Save 20% and Get a Free Certification Retake with MySQL Certification Value Packages

Choose one of the exclusive MySQL packages to get on the fast track to MySQL certifications while saving 20%. Get two Live Virtual Classes to jumpstart your training, and then demonstrate your proficiency using the certification exam vouchers in the package to obtain two certifications. In addition, you will get the exclusive bonus of a free retake with each exam voucher, so you can take the exam a second time if needed at no additional cost.

Learn More:
http://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=532&p_org_id=1001&lang=US

-------------------------------------------------------------------

Want to receive the latest MySQL updates and interact with the MySQL Community?

Read Oracle's MySQL Blog:
http://blogs.oracle.com/mysql/

Join MySQL on Facebook:
http://www.facebook.com/mysql

Follow MySQL on Twitter:
http://twitter.com/mysql

Follow MySQL Community on Twitter:
http://twitter.com/mysql_community

-------------------------------------------------------------------

About the Newsletter

You can send us queries and give us feedback online.
http://www.mysql.com/contact/

You can unsubscribe from this newsletter online:
http://www.mysql.com/unsub?email=johandontmessup@gmail.com

--
Copyright (c) 2011, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.