MySQL Newsletter May 2008

Articles in this newsletter:

Training, Consulting & Certification

Highlights

Sun Introduces MySQL Tech Support for Amazon EC2

The MySQL Enterprise for Amazon EC2 subscription is a comprehensive offering of database software and production support to deliver applications on Amazon EC2 with optimal performance, reliability, security, and uptime. For the first time, organizations can now cost-effectively deliver database driven web-scale computing in the "cloud", fully backed by the MySQL database experts at Sun.

Learn More » (http://www.mysql.com/products/enterprise/ec2.html)

Try and Buy MySQL on Sun Systems

MySQL is a natural fit for Sun's award-winning Sun Fire x64 servers or SPARC Enterprise servers with CoolThreads technology. Sun's modular storage systems provide effective, efficient data storage and protection for high growth MySQL environments.

Get a free, no-risk trial of a Sun System and Save »

Webinar: Memcached and MySQL

Thursday, May 29, 10:00am PST

Join us for this informative technical webinar where we will show you how to leverage memcached, the open source distributed memory caching system, to increase the performance and scalability of MySQL driven websites and applications. Memcached gurus Frank Mashraqi of Fotolog and Monty Taylor of Sun Microsystems will dive into the technical aspects of designing and implementing memcached using real world examples.

White Paper: Database Driven Development for Carrier Grade Systems

Over the last several years, NEPs and CSPs have been replacing their proprietary databases, which were expensive to extend and maintain, with third-party databases, which reduce development, maintenance, integration and running costs. MySQL Cluster CGE provides a complete set of carrier grade features that platform developers can leverage, thus reducing develop time and time to market.

Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_cge_business_db_dev.php)

Gartner Report: Combining Sun and MySQL

We pose the fundamental and crucial questions about understanding the motivation and market impact of the acquisition of MySQL by Sun Microsystems. MySQL fits Sun's strategy and ambition to deliver a top-to-bottom open-source stack. MySQL has a huge installed base, much of which uses the database in high-volume Web servers.

Read the Report »

MySQL Jobs

MySQL is the world's most popular open source database software. As part of Sun Microsystems' software group, MySQL is a global organization with over 400 workers in 25 countries. We are looking for talented professionals in engineering, sales, marketing, professional services, and support that will contribute to our products' strong momentum and share in our success! We have openings for the following positions:

Technical Writer
Support Engineers
Senior Software Engineer, Online Backup
QA Engineers
Senior Instructors (Ireland)
Senior Consultants (USA, EMEA)
Sales Representatives
And Many More ...

Apply Now » (http://www.mysql.com/jobs/)

New Product Releases

New Release of MySQL Workbench 5.0.21 (GA)

The MySQL Developer Tools team is working hard to constantly improve Workbench in terms of stability and handling. 4 bugs have been fixed since the last release 04/15/2008. For this release we focused on improving stability of our application. There are still remaining minor issues we are about to fix. Also keep posting any issue that you encounter while working with our product.

View the complete list of changes »

Download Now »

New Release of MySQL Connector/.NET 5.1.6 (GA)

MySQL Connector/Net 5.1.6 a new version of the all-managed .NET driver for MySQL has been released. This is a minor release involving mainly bug fixes. Changes include:

Fixed problem where parameters lists were not showing when you tried to alter a routine in server explorer. (bug #34359)
Fixed a problem in procedure cache where it was possible to get into a race condition and cause a memory leak (bug #34338)
Fixed problem where attempting to use an isolation level other than the default with a transaction scope would use the default instead (bug #34448)

View the complete list of changes »

Download Now »

Hints & Tips

Article: MySQL Workbench for Database Change Management

Robin Schumacher

Managing database change is an incredibly important discipline that very few database professionals overtly talk or worry about until they're in the thick of things with a particular database - moving it from development to production, making changes to a newly installed production database, or implementing an updated version of the database (new tables, modifications to existing objects, etc.) in a SaaS application. It's at that point where change management becomes very important because if you don't do things right the first time, you can make a royal mess of things and even (in a small number of cases) reach the point of no return where you've completely torched your database.

Read the Article »

Article: Why You Want to be Good at Data Modeling

Robin Schumacher

To be really successful at working with databases, there are many different disciplines to become proficient in - things like disaster recovery, security management, data integration, and more. But there are less than a handful of things you want to be really good at; becoming super-skilled in them will help you enormously in your database career. And believe it or not, one of these key areas is data modeling and its kissing cousin, physical database design.

Read the Article »

White Paper: Optimizing MySQL on Sun X64 Servers & Storage

Optimizing MySQL Server takes planning and understanding of the application running on the database, the service level agreements (SLAs) required, and the type of I/O needed for the application. However, MySQL Server can be used for a wide variety applications and data types, and one size does not fit all for optimization parameters and settings.

Download the White Paper »

PlanetMySQL Blog Posts

The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things MySQL, including technical tips and best practices.

Visit PlanetMySQL »

Submit Your Blog Feed »

PlanetMySQL Blog: MySQL 6.0 Feature #2: Online Backup

Alexander Nozdrin, Chuck Bell, Lars Thalmann, Peter Gulutzan, Rafal Somla

BACKUP DATABASE copies all data and metadata in one or more MySQL databases, into an "image file". RESTORE reads an image file and rewrites all the data and metadata in one or more MySQL databases. So if you lose a database, you can recover all of it as of the time of the last BACKUP DATABASE statement.And then you can re-run the statements in MySQL's binary log to recover "from the time of the last BACKUP DATABASE statement", "to the time that the database loss occurred". In other words ... Careful Use of Online Backup will protect from database loss.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: MySQL Proxy: Replicating into Memcached

Jan Kneschke

If you use replication with MySQL and memcache at the same time you have the problem to make sure that the memcached and the slave are in sync. If you announce the memcached to mark a entry as dirty and let it update the value from the slave BEFORE it is updated, you fetch a old value.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Useful ways of using Views

Jonathan Levin

Here are a few ways I found Views to be useful for me:

Data Cleansing
Decision Making
Displaying parts of many-column tables
Fashioning your data

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Getting Hibernate and MySQL's "ON DUPLICATE KEY UPDATE" Feature to Play Nice Together...

Mark Matthews

MySQL has a handy feature, that allows you to turn an INSERT into an UPDATE if a unique or primary key duplication is detected:

http://dev.mysql.com/doc/refman/5.1/en/insert-on-duplicate.html »

A common usage pattern for this is "lazy initialization" of a row in a database, which is exactly what my team was using it for yesterday to solve a problem in the backend for version 2.0 of the MySQL Enterprise Monitor.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Scaling SugarCRM with MySQL on Sun's Coolthreads Server

Satish Vanga

Shows how to install and configure SugarCRM on Solaris Operating Sytem to achieve under 2 second response times for more than 90% of requests accessed by 900 concurrent users on Sun's Coolthreads Server. A detailed account of MySQL, Apache and PHP tuning is also provided to reproduce these results.

Read the PlanetMySQL Blogpost »

Events

Live Webinar: Enabling Enterprise 2.0 with MySQL

Thursday, May 29, 2008 - 15:00 CET

Join us for this informative webinar where we will explore how open source Web 2.0 technologies, applications and architectures leveraging MySQL Enterprise can help enable information access across an enterprise's entire technology spectrum, through a network of tightly and loosely integrated applications, services and devices.

Live Webinar: MySQL Consulting - Your Fast Track to Better Performance, Availability and Scalability

Tuesday, June 03, 2008 - 10:00am PST

In this Webinar you will learn how MySQL's Certified Consultants use industry best practices and proven methodologies to improve performance up to 10x, implement cost-effective high-availability solutions, architect solutions to meet your exact requirements, and much more. Josh Chamas, Director of MySQL Professional Services will share with you real-world examples of how MySQL has designed, scaled and tuned MySQL applications for some of the world's fastest growing companies.

Live Webinar: How MySQL Enables Web 2.0 for Government

Wednesday, June 11, 2008 - 11:00am PST

Faced with mandates for improved efficiency, greater convenience, and better access to public services, government agencies are accelerating its use of internet technology as a platform for exchanging information and conducting its business. Web 2.0 technologies such as online communities, wikis, blogs, and the like are being used broadly by agencies to push information over the internet; facilitate communications between agencies and constituents; conduct transactions; and expedite governance. A core competency for participants in this revolution is database management. Join Red Hat and MySQL for this interactive web seminar on how MySQL Enterprise is enabling the technologies that are transforming government.

Training, Consulting, and Certification

Consulting: MySQL Developer (4+ Days)

A dedicated MySQL certified consultant will work closely with your team to:

Analyze your current database application
Analyze your database requirements
Identify potential issues and limitations
Benchmark, load test, and optimize critical SQL queries
Help them implement best practices and recommend tools for developing your database infrastructure.

Learn More » (http://www.mysql.com/consulting/packaged/dev.html)

Training: MySQL High Availability (3 Days)

Milan, Tokyo, Hamburg, Boston, Frankfurt, London

This course is designed for experienced database administrators and system architects that want to analyze and form a basis of understanding different high availability options, including clustering and replication solutions within MySQL. This course will provide the tools required to make the decision of what high availability solution is appropriate and how to implement a system with the correct design.

Partners

Zmanda: New version 2.2 of Zmanda Recovery Manager for MySQL introduces Continuous Data Protection for MySQL

The new version 2.2 of Zmanda Recovery Manager (ZRM) enables Continuous Data Protection (CDP) for MySQL by using Linux LVM, Veritas VxFS, Microsoft VSS, Solaris ZFS and NetApp snapshots in conjunction with MySQL transaction logs. When doing a recovery to a particular point in time, ZRM reads data from the snapshot and then replays MySQL transaction log from that point forward.

Learn More »

Live Webinar: Simple, Fast and Flexible Data Warehousing with Infobright (German)

Monday, June 9 - 16:00 CET

In today's fast moving business environment, it is clear that Business Intelligence (BI) is a mandatory part of any company's decision making environment. The question then becomes how to build this environment in a cost-effective way that keeps up with ever-changing business requirements, new and large numbers of users, all forms of analytics, and increasing volumes of data.

Live Webinar: Turbo Charging MySQL Reporting and Data Warehousing with Kickfire

Wednesday, June 18, 2008 - 10:00am PST

Sun/MySQL and Kickfire are teaming up to change all that, bringing unheard of speed, scalability and cost-efficiencies to MySQL for data warehousing and reporting. Having twice announced world record-breaking performance and price-performance on industry standard data warehousing benchmarks, the companies will discuss the Kickfire Database Appliance for MySQL and how it can help supercharge your business.