MySQL Newsletter January 2010
Articles in this newsletter:
- MySQL Conference and Expo: April 12-15, 2010
- MySQL Conference and Expo: Register Now and Save $250
- MySQL Conference and Expo: Submit a Proposal
- PlanetMySQL Blog: PERFORMANCE_SCHEMA hits Prime Time!
- Live Webinar: Boosting Performance and Scalability with MySQL and the new InnoDB Plugin (January 26)
- White Paper: Getting Started with MySQL Replication on Windows
- Upcoming MySQL University Sessions
- Over 1 Million MySQL Newsletter Subscribers
- New Release of MySQL Community Server 5.1.42 (GA)
- New Release of MySQL Community Server 5.0.89 (GA)
- New Release of MySQL Connector/NET 6.2.2 (GA)
- White Paper: A Guide to Securing MySQL on Windows
- Article: A Deep Look at MySQL 5.5 Partitioning Enhancements
- Case Study: ContactLab Supports its High-Performance e-marketing tools with MySQL Enterprise
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: MySQL Workbench 5.2 and SSH Mini-FAQ
- PlanetMySQL Blog: Publishing your MySQL Certs from the Sun Certification system
- PlanetMySQL Blog: Explaining the limits of LIMIT
- PlanetMySQL Blog: Repeatable read versus read committed for InnoDB
- PlanetMySQL Blog: MySQL reporting to syslog
- PlanetMySQL Blog: Building MySQL Cluster 7.0 on Windows
- PlanetMySQL Blog: MySQL University: Speakers for 2010 wanted!
- 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)
- Consulting: MySQL Scale-Out, High-Availability and Replication Jumpstart (4+ Days)
- Training: MySQL Boot Camp (5 Days)
- Live Webinar: Joomla - Web Based Content Management and Data Security
- Live Webinar: Zmanda and MySQL: Backup MySQL Applications, including those running on the Cloud
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.
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.
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.
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!
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.
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)
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.
Over 1 Million users now subscribe to the monthly MySQL Newsletter. Thank you for your continuing support of MySQL!
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.
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.
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!
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/a-guide-to-securing-mysql-on-windows/)
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.
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)
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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/)
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.
Register Now for an Upcoming Date » (http://www.mysql.com/training/workshops/mysql_bootcamp.html)
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.
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.