MySQL Newsletter January 2010

Articles in this newsletter:

Events

Live Webinar: MySQL Cluster Performance Tuning Best Practices - EMEA (EMEA February 2)
Live Webinar: Windows and MySQL - Part 9: Working with Spreadsheets and MySQL (February 4)
Live Webinar: How to Make MySQL Great for Business Intelligence (February 9)
Live Webinar: Blazing Java Application Performance: Connector/J Performance Gems (EMEA February 9)
Live Webinar: Windows and MySQL - Part 10: Running MySQL Securely on Windows (February 11)
Live Webinar: MySQL Cluster Connector/Java: Technology Introduction & Getting Started, Part 1 (February 16)
Live Webinar: Introduction to Deploying MySQL in Virtualized Environments (February 17)

Training, Consulting, & Certification

Highlights

MySQL Conference and Expo: April 12-15, 2010

Come together with over 2,000 open source and database enthusiasts from around the world to explore the power of MySQL and related technologies. The O'Reilly MySQL Conference & Expo happens April 12-15, 2010 in Santa Clara, California, at the Santa Clara Convention Center and Hyatt Regency Santa Clara.

Learn More »

MySQL Conference and Expo: Register Now and Save $250

The MySQL Conference and Expo is a deep technical conference designed to take your skills and know-how to the next level through expert-led sessions, in-depth tutorials, and face to face conversations with open source gurus and developers. Early registration ends on February 22, 2010.

View Pricing »

MySQL Conference and Expo: Submit a Proposal

O'Reilly Media and the program committee are seeking leaders for conference sessions and tutorials. Are you a developer, programmer, trainer, system administrator, and/or entrepreneur with something to share with the MySQL community? If so, submit a proposal for MySQL Conference & Expo by January 27, 2010.

Learn More »

PlanetMySQL Blog: PERFORMANCE_SCHEMA hits Prime Time!

Mark Leith

I've talked about PERFORMANCE_SCHEMA in the past - almost a year ago now. Back then the feature was just coming together in to something useable, and was on the cusp of moving towards code review. It entered code review, and went around, and around for 9 months, whilst various refinements were made. Nevertheless, Marc Alff persevered (much respect!), and yesterday pushed his final merge in to the mysql-next-mr bzr tree. PERFORMANCE_SCHEMA is now awaiting the next milestone release, and will be a part of the next GA release of MySQL!

Read the PlanetMySQL Blogpost »

Live Webinar: Boosting Performance and Scalability with MySQL and the new InnoDB Plugin

Tuesday, January 26, 2010 - 10:00am PST

Looking for ways to boost the performance and scalability of your MySQL applications now? Ready to maximize your investment in modern hardware with a version of MySQL that fully utilizes the processing power of multi-core architectures? If so, join us for the first of a two part webinar series where we will discuss how you can achieve immediate performance and scalability gains by enabling the new InnoDB Plugin in MySQL 5.1.

White Paper: Getting Started with MySQL Replication on Windows - Part 1

In this first installment of a two part series concerning MySQL Replication on Windows, we will cover the technical and business reasons for deploying MySQL Replication and give an overview of the fundamentals on how to install and configure master/slave configuration. In part two of this series we will cover more advanced MySQL Replication topics including, fail-over, resynchronization, multi-master configurations and an introduction to semi-synchronous replication.

Read the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql-wp-windows-replication.php)

Upcoming MySQL University Sessions

MySQL University is a free educational online program for engineers and developers who are interested in MySQL development and internals. MySQL University sessions are open to anyone, not limited to Sun employees. Sessions are recorded with slides and audio, so if you can't attend the live session you can review the recording anytime after the session.

Learn More and View Upcoming Sessions »

To attend a MySQL University session »

Over 1 Million MySQL Newsletter Subscribers

Over 1 Million users now subscribe to the monthly MySQL Newsletter. Thank you for your continuing support of MySQL!

Give MySQL Newsletter Info to a Friend »

View previous MySQL Newsletters »

New Product Releases

New Release of MySQL Community Server 5.1.42 (GA)

MySQL Community Server 5.1.42, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.42 is recommended for use on production systems.

View the complete list of changes »

Download Now »

New Release of MySQL Community Server 5.0.89 (GA)

MySQL Community Server 5.0.89, a new version of the popular Open Source Database Management System, has been released. This Community release shares the version number with its MySQL Enterprise Server counterpart. Please note this is the last release of 5.0 before it exits active maintenance.

View the complete list of changes »

Download Now »

New Release of MySQL Connector/NET 6.2.2 (GA)

MySQL Connector/Net 6.2.2, a new version of the all-managed .NET driver for MySQL has been released. This is our latest GA release and is suitable for use in all scenarios against servers ranging from version 4.1 to 5.4!

View the complete list of changes »

Download Now »

Hints & Tips

White Paper: A Guide to Securing MySQL on Windows

For many years, Microsoft Windows has been the most popular development platform and second most popular production platform for MySQL applications. Given that so many organizations deploy MySQL on Windows, it makes sense to recap some of the best practices for securing MySQL on Windows. This guide will walk you through understanding the MySQL security model, post-installation, nd securing user accounts and replication.

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

Article: A Deep Look at MySQL 5.5 Partitioning Enhancements

The release of MySQL 5.5 has brought several enhancements. While most of the coverage went, understandably, to the semi-synchronous replication, the enhancements of partitioning were neglected, and sometimes there was some degree of misunderstanding on their true meaning. With this article, we want to explain these cool enhancements, especially the parts that were not fully understood.

Read the Article »

Case Study: ContactLab Supports its High-Performance e-marketing tools with MySQL Enterprise

ContactLab is a leading Italian provider of digital direct marketing services, with offices in Milan, Madrid, Paris, London and Munich. ContactLab chose to subscribe to Sun Microsystems' MySQL Enterprise database service to help support the security, availability and scalability of its market-leading platform. Today ContactLab manages with MySQL more than 3 Terabytes of data for sending, tracking and analyzing hundreds of millions of messages every month.

Read this Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql_cs_contactlab.php)

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 Workbench 5.2 and SSH Mini-FAQ

Mike Frank

MySQL Workbench provides secured access to MySQL Instances and Servers using SSH. The follow FAQ formated blog post shows a few details on what this is and how it works.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Publishing your MySQL Certs from the Sun Certification system

Dave Stokes

I received a question from my last entry on how to let others see your MySQL Certifications. In the past, the MySQL site had a list of those with the various certifications. Sun's certification system is different.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Explaining the limits of LIMIT

Mark Callaghan

The explain command in MySQL is very useful. Alas, it has its limits including some related to the use of the LIMIT clause. This is even more reason to do more than EXPLAIN when testing a query.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Repeatable read versus read committed for InnoDB

Mark Callaghan

There is a lot of documentation available on transaction isolation levels for InnoDB including the InnoDB transaction model, a description of the isolation levels, notes on locks, locks set by statements and notes on consistent non-locking reads. There is another issue that has not been documented. The code that creates a read view (snapshot) for InnoDB transactions is a source of mutex contention on kernel_mutex.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: MySQL reporting to syslog

Oli Sennhauser

There are 2 different possible situations you can face when you have to deal with MySQL and syslog:

MySQL is used as back-end for syslog to store the logging information.
MySQL itself should report to the syslog.

In this blog article we look at the second situation: How can you make MySQL reporting to the syslog.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: Building MySQL Cluster 7.0 on Windows

Magnus Blåudd

This walkthrough will show you how to configure your more or less clean install of Windows (you can use XP, Vista or 7) in order to build MySQL Cluster on Windows. The setup also works for the vanilla MySQL Server since the only real difference is the configure switches used to activate build of the NDB storage engine and the NDBCLUSTER handler.

Read the PlanetMySQL Blogpost »

PlanetMySQL Blog: MySQL University: Speakers for 2010 wanted!

Stefan Hinz

In 2009, we ran more than 25 sessions, and I'd surely like to get anywhere near that figure. Anyone who has something technical to say about MySQL qualifies as a speaker.

Read the PlanetMySQL Blogpost »

Events

Live Webinar: MySQL Cluster Performance Tuning Best Practices - EMEA

Tuesday, February 02, 2010 - 10:00 am Central European Time

Are you experiencing current performance bottlenecks in your high availability applications? Are you designing a new mission-critical application and want to know how best to structure your schema and index strategy for optimal performance? Interested in how to transform your SQL into faster, more efficient queries?

Then this free web presentation is for you! You will get expert insight and learn best practices to help you identify those areas of database and application design that will give you the greatest benefits for performance when using MySQL Cluster.

Live Webinar: Windows and MySQL - Part 9: Working with Spreadsheets and MySQL

Thursday, February 04, 2010 - 10:00am PST

Join us for Part 9 of the Windows and MySQL webinar series with Jimmy Guerrero and Mike Frank of the MySQL group at Sun Microsystems. In this presentation we will explore the benefits of leveraging MySQL in conjunction with your existing spreadsheet program. We will also cover how to import and export data from Microsoft Excel or OpenOffice Calc to MySQL and visa versa. We also provide an overview tools for for viewing and manipulating data. If you are interested in learning how to leverage the power of MySQL with your favorite spreadsheet program, this webinar is for you.

Live Webinar: How to Make MySQL Great for Business Intelligence

Tuesday, February 09, 2010 - 10:00am PST

For 2010, Business Intelligence (BI) is predicated to be the top tech priority for both small and large companies alike, just as it has been for the past four years. At the heart of every BI system is the database, and as BI has grown, so has usage of MySQL as BI's back end database and for good reason. Join us for a free technical webinar presented by Robin Schumacher, VP of Products - Calpont and Jimmy Guerrero Sr Product Manager - MySQL/Sun Microsystems. In this webinar, you'll discover how to make MySQL perform like you never thought it could with BI applications.

Live Webinar: Blazing Java Application Performance: Connector/J Performance Gems - EMEA

Tuesday, February 09, 2010 - 15:00 Central European Time

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. While these options are documented, many aren't shown alongside the use cases they apply to. Out of the box, Connector/J is configured with the principle of least surprise, and is JDBC-compliant, and provides a pretty genericized view of MySQL. 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.

Live Webinar: Windows and MySQL - Part 10: Running MySQL Securely on Windows

Thursday, February 11, 2010 - 10:00am PST

Join us for Part 10 of the Windows and MySQL webinar series with Jimmy Guerrero and Mike Frank of the MySQL group at Sun Microsystems. In this presentation we will demonstrate how to install and configure MySQL to run securely on Windows. We will explain how MySQL's internal security model, authentication and privileges model works. We will also look at how to secure network access to MySQL and look how to thwart common attacks on MySQL. If you are interested in learning how to run MySQL securely on Windows, this webinar is for you.

Live Webinar: MySQL Cluster Connector/Java: Technology Introduction & Getting Started, Part 1

Tuesday, February 16, 2010 - 10:00am PST

Designed for Java developers, the MySQL Cluster Connector for Java implements an easy-to-use and high performance native Java interface and OpenJPA plug-in that maps Java classes to tables stored in the high availability, real-time MySQL Cluster database.

Live Webinar: MySQL & Virtualization Webinar Series Part 1: Introduction to Deploying MySQL in Virtualized Environments

Wednesday, February 17, 2010 - 10:00am PST

Join us for an overview of various virtualization technologies and how they work with MySQL. We will examine how to best optimize your infrastructure investment using virtualization and explore best practices. We will cover virtualization platforms like VMWare, Xen, Microsoft Windows Server 2008 Hyper-V, Sun Solaris Containers/Zones, Parallels Virtuozzo and others and how to best leverage their built-in features to make MySQL more efficient, easier to manage and more highly available.

Training, Consulting, and Certification

Consulting: MySQL Scale-Out, High-Availability and Replication Jumpstart (4+ Days)

A dedicated MySQL consultant uses proven methodologies and expertise in database design, architecture, performance tuning, replication, fail-over and fault-tolerance to provide these services. Sun's MySQL consultants will work closely with your team to:

Analyze your current database infrastructure, Scale-out and High-Availability database requirements
Identify potential issues and limitations
Configure MySQL or MySQL Cluster to work with HA Technologies
Secure your database environment against failures and downtime
Recommend a Scale-Out and High Availability architecture specific to your application that optimizes availability, fault-tolerance, and performance

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

MySQL Consulting Testimonials » (http://www.mysql.com/consulting/testimonials/)

Training: MySQL Boot Camp (5 Days)

Dallas, Washington D.C., Orlando, Los Angeles

The MySQL Boot Camp training course provides students with an 11 hour-per-day immersion into MySQL. The program is an accelerated course that provides experienced developers and administrators with the necessary skills to successfully develop and administer MySQL 5 applications. Students will learn from MySQL-Certified experts through a combination of lab exercises, lectures, and presentations.

Partners

Live Webinar: Joomla - Web Based Content Management and Data Security

Wednesday, January 27, 2010 - 10:00am Central European Time

Join us for this informative technical webinar with Connectage.com and a member from the Joomla core team, which will explore the benefits of an open source Content Management stack based on Joomla and MySQL. This webinar describes how Joomla offers excellent content management and distributed authoring capabilities as well as reliable data security through MySQL. It will detail use case examples of organisations who have adopted Joomla as a highly visible content management platform in publishing and public sector healthcare where data security was a paramount consideration.

Live Webinar: Zmanda and MySQL: Backup MySQL Applications, including those running on the Cloud

Thursday, January 28, 2010 - 10:00am PST

MySQL databases are increasingly used by high volume, high transaction applications that support businesses running full throttle 24x7. Backup and recovery operations need to be conducted in such as way that is non-disruptive to users and applications. In this webinar, we will show how Zmanda Recovery Manager(ZRM) backs up the most challenging MySQL installations, including those running on the cloud. Zmanda supports all storage engines and provides point-in-time recovery for MySQL.

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

Follow MySQL on Twitter »

Follow MySQL Community on Twitter »