MySQL Newsletter June 2009
Articles in this newsletter:
- MySQL Enterprise Monitor with Enhanced Query Analyzer (Beta) is Available Now!
- Small to Mid-Size Business Solutions from MySQL
- For ISVs: Take the MySQL OEM Life Cycle Survey and Win a $150 Amazon.com Gift Certificate
- Case Study: thePlatform Migrates Media Publishing System to MySQL and Achieves 23x Performance Gain with the MySQL Query Analyzer
- Case Study: Datagest selects MySQL for tour operator management application
- Live Webinar: Scalable MySQL High Availability Architectures (June 23, 2009)
- Live Webinar: Kimball Group Data Warehousing Educational Webinar Series - Part I: Data Warehousing Fundamentals (June 25, 2009)
- Upcoming MySQL University Sessions - Last Two Sessions before the Summer Break
- New Release of MySQL Community Server 5.0.83 (GA)
- New Release of MySQL Community Server 5.1.35 (GA)
- New Release of MySQL Community Server 6.0.11 (Alpha)
- New Release of MySQL Cluster 7.0.6 (GA)
- New Release of MySQL Workbench 5.2.1 (Alpha)
- Article: MySQL Developer, Meet the MySQL Query Analyzer
- White Paper: Server Virtualization and MySQL - Your Options
- White Paper: Best Practices for MySQL on Amazon EC2
- White Paper: A Guide to Open Source Data Warehousing for Communications Service Providers
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: MySQL Clustering in a Sandbox
- PlanetMySQL Blog: From Russia with Blogs - PlanetMySQL in Russian
- PlanetMySQL Blog: Basic MySQL Security - Providing passwords on the command line
- PlanetMySQL Blog: Replicating from MySQL to *
- PlanetMySQL Blog: MySQL Cluster - flexibility of replication
- PlanetMySQL Blog: Scaling Writes, Using MySQL Cluster to non-Cluster Replication
- Article: Improving Database Performance with Partitioning
- Video: MySQL Query Analyzer In Action
- PlanetMySQL Blog: A 10x Performance Increase for Batch INSERTs With MySQL Connector/J Is On The Way
- PlanetMySQL Blog: MySQL Performance - InnoDB Dirty Pages & Log Size Impact
- Live Webinar: Architecting Databases for High Performance (June 23, 2009)
- Live Webinar: Architecting Databases for High Performance - for Commercial Application Developers / ISVs (June 25, 2009)
- Live Webinar: Improve Application Performance with the MySQL Enterprise Monitor and the MySQL Query Analyzer (June 30, 2009)
- Live Webinar: Guide to Scaling OpenLDAP - MySQL Cluster as Data Store for OpenLDAP Directories (June 24, 2009)
- On-Demand Webinar: MySQL Performance Tuning Step-by-step
- On-Demand Webinar: Data Warehousing for Communications Service Providers
The MySQL Enterprise Monitor now correlates MySQL and OS graph activities with your queries, allowing you to view query history graphs in the query pop-ups and to track query errors and warnings. Be the first to evaluate and provide feedback on this new beta release and start finding your most expensive queries now!
Not yet a MySQL Enterprise customer? You can still get a test drive on this beta release of MySQL Enterprise Monitor by signing-up the MySQL Enterprise 30-day Trial.
Sign-up for the MySQL Enterprise Trial » (http://www.mysql.com/trials/)
Your business may be small or mid-sized but your business pressures are just as big as any global enterprise. For businesses like yours, open source applications offer a scalable, reliable and high performance platform that allows you to keep total cost of ownership extremely low. Learn how MySQL and open source applications can add value to your business with white papers, webinars, case studies and solutions on the MySQL Small and Medium Business Resource Center.
Are you a Commercial Software Developer or Product Manager but missed the survey last month? Here is your opportunity again! Please help us understand how the MySQL team can provide best value to you by taking a 3 minute survey on your product's development cycle. And, you'll be entered to win a $150 Amazon.com gift certificate.
Case Study: thePlatform Migrates Media Publishing System to MySQL and Achieves 23x Performance Gain with the MySQL Query Analyzer
thePlatform is a leading, fast-growing video management and publishing company for broadband, mobile and TV. Comcast Interactive Media acquired thePlatform in 2006, which now operates as a stand-alone subsidiary.
thePlatform had been using proprietary databases to store meta data for media files. To further scale the system and reduce costs, thePlatform decided to migrate the application to MySQL. thePlatform also used the MySQL Query Analyzer to quickly identify critical performance issues before going into production and reduced the query time by 95% from 70 seconds to 3 seconds. They achieved the 23x performance gain in just a few minutes, rather than days.
Read the Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql_cs_theplatform.php)
Datagest is an IT company serving the Italian tourism industry using both specialized solutions - its own products customized for customers' requirements - and strategic consultancy. Datagest has helped TUI Italia, Meridiana, Gruppo Grimaldi, and Gardaland to create quotes and sales documents in seconds and without any mistakes.
Flexibility, stability, platform portability, documentation, low cost, support, training, global presence, throughput, scalability, security etc. are the reasons why Datagest relies on MySQL Embedded Server for its solutions. For Datagest MySQL has proven to be the best solution for operating in dot.net environments.
Read the Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql_cs_datagest.php)
Tuesday, June 23, 2009 - 13:00 UTC
Join us for this informative technical webinar where we will explore various MySQL high availability technologies and architectures. We will explore the use cases for when to implement MySQL Replication, MySQL Cluster, Distributed Replicated Block Device (DRBD) and other high-availability technologies. Also, covered will be the fundamentals of how these technologies work and how they can be combined to create a more scalable and highly available database infrastructure.
Live Webinar: Kimball Group Data Warehousing Educational Webinar Series - Part I: Data Warehousing Fundamentals
Thursday, June 25, 2009 - 1:00pm PDT / 4:00pm EDT
Business Intelligence/analytics continues to grow in importance. According to Gartner's survey of 1500 CIO's, it is the #1 priority for a fourth year in a row. The foundation for any successful deployment of analytics is the data warehouse (DW). Understanding how to properly design and deploy a DW is therefore key. In the first part of a three-part series, Joy Mundy, of the world-renowned Kimball Group, explains the fundamentals of data warehousing.
MySQL University is a no cost online training program for Sun Engineers, MySQL Community Contributors and anyone who's interested in MySQL development and internals. Take your opportunity to join these two upcoming sessions before the annual summer break:
- June 25: MySQL Code Contributions (Lenz Grimmer, MySQL Community Team)
- July 2: Starring Sakila - a Data Warehouse Mini-Tutorial (Roland Bouman, Abvakabo NV)
MySQL Community Server 5.0.83, a new version of the popular Open Source Database Management System, has been released. This and future releases in the MySQL Community Server 5.0 series share version numbers with their MySQL Enterprise Server counterparts.
MySQL Community Server 5.1.35, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.35 is recommended for use on production systems.
MySQL 6.0.11-alpha, a new version of the MySQL database system has been released. MySQL 6.0.11 will be the last release of 6.0. After this we will be transitioning into a new release model for the MySQL Server. The goal of this transition is to enable more frequent and timely releases of the MySQL Server.
MySQL Cluster 7.0.6, a new version of the leading open source, high availability database for real-time, mission critical telecommunications services, has been released in source and binary forms. MySQL Cluster version 7.0.6 uses MySQL Server version 5.1.34 and contains all bug fixes and updates to both MySQL Server 5.1.33 and 5.1.34.
Read the White Paper: MySQL Cluster 7.0 - Architecture & New Features » (http://www.mysql.com/why-mysql/white-papers/mysql-cluster-7-2-new-features-whitepaper/)
Read the White Paper: MySQL Cluster 7.0 - Evaluation Guide » (http://www.mysql.com/why-mysql/white-papers/mysql-cluster-evaluation-guide/)
We're proud to announce the availability of the second Alpha release of MySQL Workbench 5.2. This is the youngest member of the workbench family and this version also adds the database querying tool to the application. There have been major enhancements - not only to the querying part - since we released the first alpha version.
As Product Managers with MySQL, Robin Schumacher and I have heard loud and clear from customers and users that they love MySQL's ease of use and reliability, but see it as a "black box", specifically when it comes to identifying problematic SQL code. Polling of our Community and Enterprise users also reveals that finding problem SQL is commonly the #1 challenge they say that comes with deploying and scaling applications on MySQL.
Virtualization technology has now gone main stream, and its footprint within IT infrastructures continues to accelerate. This paper will explain virtualization technologies and how they work with MySQL to help optimize your infrastructure investment while at the same time increasing the performance and availability of your business-critical applications.
Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_virtualization_options.php)
Currently, the most popular cloud computing platform is Amazon Web Services (AWS) and the most popular database in the cloud is MySQL. Although Amazon originally launched AWS in 2002 and since has made available many new computing services, for the purposes of this paper we will focus on those most relevant to deploying MySQL - specifically Elastic Computing Cloud (EC2), Simple Storage Service (S3) and Elastic Block Store (EBS). These are services which developers can access using web services, specifically REST and SOAP protocols.
Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/best-practices-for-mysql-on-amazon-ec2/)
Download this joint whitepaper from Infobright and MySQL to learn how open source data warehousing enables Communications Service Providers to gain greater subscriber insight, with lower cost and risk than ever before.
Read this White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_infobright_telecon.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 about MySQL, including technical tips and best practices.
MySQL's unique architecture allows for plugin storage engines. So for example, there is the MyISAM storage engine, the original one, and there is the ARCHIVE storage engine, which has characteristics that make it suitable for storing archived data. And of course we know the InnoDB storage engine, with its transactional capabilities. So it makes sense then that MySQL's clustering solution involves a storage engine as well, namely the NDB (Network DataBase) storage engine.
Duleepa 'Dups' Wijayawardhana
We've enabled Russian as a choice in PlanetMySQL and feel free to start submitting your Russian language blogs.
- Russian Language PlanetMySQL: http://ru.planet.mysql.com
- New feed submissions: http://ru.planet.mysql.com/new
Reading through the comments in Ronald's second post about More Basic MySQL Security, I noticed that there seems to be a misunderstanding about the implications of providing passwords to the mysql command line client via the "-p" option.
Recently I needed to replicate between MySQL and another database technology. You might say, why on earth would you want to do something like that, but believe me there are reasons and definitely not to go away from MySQL to some other DB technology like Oracle or SQL server. Unsurprisingly there are quite a few different tools to do it from any platform towards MySQL but very few which do it the other way round, just to name a couple: Golden Gate and DSCallards.
One of the better kept secrets about MySQL Cluster appears to be the flexibility available when setting up replication. Rather than being constrained to implementing a single replication scheme, you can mix and match approaches.
There are various setups and solutions to solve the problem of having redundant MySQL masters and scaling writes on them. MySQL Cluster can be an alternative. Here is why and how...
One of the reasons I'm very excited about the release of MySQL 5.1 is that it contains a potent new weapon for designing supercharged databases that any MySQL DBA should quickly learn how to use and exploit. By smartly using the new 5.1 partitioning feature, a DBA can oftentimes dramatically improve the performance of almost any VLDB or data warehouse they happen to be in charge of.
Read More Performance Tuning and Optimization Tips in the MySQL Performance Resource Center » (http://www.mysql.com/performance)
Don't miss any performance tuning opportunity! Learn how the MySQL Query Analyzer can help you find and fix your most expensive queries in minutes vs hours, all with no dependence on the MySQL Slow Query Log.
Connector/J has a feature where the driver can take prepared statements of the form "INSERT INTO foo VALUES (...)", and if configured with "rewriteBatchedStatements=true", can re-write batches of them to the form "INSERT INTO foo VALUES (...), (...), (...)". This is a performance win on a few fronts, because of reduction in latency and because of optimizations of handling "multivalue" INSERT in the server itself.
The beginning of this story is coming from the first weeks of the last year - when seeking for the most optimal MySQL config parameters I've discovered a strange thing ... I've told a lot of people, but everybody was just surprised and did not really believe such case is possible.
Tuesday, June 23, 2009 - 10:00am PDT
This complimentary web seminar will show the tips and tricks for architecting your database for high performance. Using MySQL as our example, you'll learn the steps the pros use for architecting and optimizing databases for performance and scalability. Get the keys to designing a MySQL database for performance and scalability to meet both current and future user demands! In this webinar, the MySQL Consulting pros will introduce you to the steps they use to design a high performance MySQL database server.
Live Webinar: Architecting Databases for High Performance - for Commercial Application Developers / ISVs
Thursday, June 25, 2009 - 10:00am PDT
This complimentary web seminar will give you the tips and tricks for architecting your database for highest performance. Using MySQL as our example, you'll learn the steps a foremost database performance expert uses to architect and optimize databases for performance and scalability.
MySQL Performance Guru, Jay Pipes will share his expert insight and best practices to help you identify those areas of database architecture and application design that will give you the greatest performance benefits.
Live Webinar: Improve Application Performance with the MySQL Enterprise Monitor and the MySQL Query Analyzer
Tuesday, June 30, 2009 - 10:00am PDT
Are you looking for performance tuning opportunities in MySQL?
In this technical webinar, Phil Hildebrand, Database Manager at thePlatform, will talk about how they used the MySQL Enterprise Monitor, the MySQL Enterprise Advisors and the MySQL Query Analyzer to deploy new applications and implement changes to production systems more efficiently. Phil will present these tools from a practical, user-oriented perspective, and also showcase how to achieve significant performance enhancements while reducing troubleshooting time of difficult SQL code issues.
Wednesday, June 24, 2009 - 10:00am PDT
Discover how to fully exploit distributed subscriber and network data, and how to enhance your investments in OpenLDAP technology by tuning into this webinar, jointly run by OpenLDAP and MySQL.
In this webinar, the Chief Architect of OpenLDAP will demonstrate where this solution can be used, and how to get started with MySQL Cluster as the directory data store.
Learn the basic steps the MySQL Consulting pros follow to tune a MySQL database server. Each step will be covered at a high level with one or two of the most critical parameters covered in detail for each step.
Learn not only what to tune, but also how to determine what you NEED to tune. Do you want to know what to watch and how to tune for connections? What caches/buffers are allocated per session, when are they allocated and how to monitor them? What can you do in 10 minutes to speed up your MyISAM or InnoDB performance? Get the answers to these and other tuning questions in this online talk.
Tune into this on-demand webinar from Infobright and MySQL to learn how open source data warehousing enables Communications Service Providers to gain greater subscriber insight, with lower cost and risk than ever before.
More MySQL webinars are scheduled and added between each Newsletter edition, so visit our website for the most updated information.
Seattle, Singapore, Paris, Lyon
This course is designed for experienced database administrators and system architects who 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 for you and how to implement a system with the correct design.
Register Now for an Upcoming Date » (http://www.mysql.com/training/courses/mysql_5_ha.html)
Sun's MySQL consultants will use proven methodologies and expertise in database clustering, replication, fail-over, fault-tolerance and other HA techniques to help jump start your high-availability database projects and recommend project roadmaps to help you successfully implement MySQL Cluster.
Learn More » (http://www.mysql.com/consulting/packaged/cluster.html)
A new pluggable storage engine has been developed specific to MySQL running in IBM i, V5R4 and V6R1, and is now available as GA starting from version 5.1.35. This storage engine is the DB2 for i (IBMDB2I) Storage Engine for MySQL on IBM i.
Learn More » (http://solutions.mysql.com/engines/ibm_db2_storage_engine.html)