Skip navigation links

MySQL Newsletter - Subscribe Today!

MySQL Newsletter May 2007

MySQL Newsletter - Subscribe Today

Articles in this newsletter:

Highlights

New Product Releases

Hints & Tips

Events

Training, Consulting & Certification

Partner Corner

Highlights

DRBD for MySQL - New High Availability Solution for LAMP

MySQL AB today announced a joint partnership and services agreement with LINBIT, the well-respected Austrian provider of high availability Linux systems technology called DRBD. Through its MySQL Enterprise subscription offering, MySQL AB will now offer direct support for this proven, low-cost solution for attaining "Four Nines" and greater uptime for transactional database applications in LAMP (Linux, Apache, MySQL, PHP/Perl/Python) computing environments.

Learn more » (http://www.mysql.com/products/enterprise/drbd.html)

White Paper: MySQL Cluster Carrier-Grade Edition Scales to 100,000 Transactions per Minute in DBT2 Benchmark

These DBT2 benchmarks show the very high scalability of MySQL Cluster Carrier Grade Edition, attaining a rate of 100,000 transactions per minute (TpM) using an 8-node cluster. These performance improvements were realized through the use of new Multi- Core Intel Xeon servers based on the Intel Core T micro architecture. In addition, Dolphin Express interconnects enhance the scalability of MySQL Cluster Carrier Grade Edition to dramatically new levels.

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

White Paper: Building Subscriber Databases with MySQL Cluster Carrier Grade Edition

MySQL Cluster Carrier Grade Edition is a clustered real-time database based on the Network Database (NDB) storage engine, which is deployed in some of the most demanding subscriber database systems found in the telecommunications industry. In this paper we describe how MySQL Cluster Carrier Grade Edition can be used to build a scalable, highly available, geographically replicated Subscriber Database.

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

MySQL AB Launches New Business Partner Program

The MySQL Enterprise Connection Alliance (MECA) makes it easier for resellers, software vendors, hardware companies, and IT service providers to offer their database-related solutions to the millions of MySQL users worldwide.

Read About the Benefits of Joining » (http://solutions.mysql.com/partners/)

MySQL Conference & Expo 2007 Wrap-up - Presentation Files Now Available

The MySQL Conference and Expo 2007 was a huge success. MySQL engineers and experts from leading companies like Google, YouTube, digg.com, Yahoo!, TicketMaster and Nokia shared their MySQL best practices, scalability & performance tuning tips and lessons learned with over 1500 attendees.

View the Presentation Files »

MySQL Enterprise Unlimited

MySQL Enterprise Unlimited is a unique offering that enables you to accelerate your open source initiative and gain control of your software budget by significantly reducing the cost of deploying and managing database software. For the price of a single CPU of Oracle Enterprise Edition ($40,000 per CPU), you can deploy an unlimited number of MySQL Enterprise Servers, with full 24x7 production support.

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

New Product Releases

New Release of MySQL Enterprise Server 5.0.40

This is a Monthly Rapid Update release of the MySQL Enterprise Server 5.0. The following is a partial list of changes:

  • If you use SSL for a client connection, you can tell the client not to authenticate the server certificate by specifying neither --ssl-ca nor --ssl-capath. The server still verifies the client according to any applicable requirements established via GRANT statements for the client, and it still uses any --ssl-ca/--ssl-capath values that were passed to server at startup time. (Bug#25309)
  • The output of mysql --xml and mysqldump --xml now includes a valid XML namespace. (Bug#25946)

View the complete list of changes »

Download Now (log-in required) »

New Release of MySQL Community Server 5.1.18 (Beta)

This is a new release fixing recently discovered bugs. The following is a partial list of changes:

  • Incompatible change: The INFORMATION_SCHEMA.EVENTS and mysql.event tables have been changed to facilitate replication of events. When upgrading to MySQL 5.1.18, you must run mysql_upgrade prior to working with events.
  • New command line options: In order to alleviate ambiguities in variable names, all variables related to plugins can be specified using a 'plugin' part in the name.
  • Security fix: If a stored routine was declared using SQL
  • SECURITY INVOKER, a user who invoked the routine could gain privileges.

View the complete list of changes »

Download Now »

New Release of MySQL Connector/ODBC 3.51.15 (GA) is available!

MySQL Connector/ODBC 3.51.15, a new version of the ODBC driver for the MySQL database system, has been released. This release is the latest release of the 3.51 series and is suitable for use with any MySQL version including MySQL 4.1, 5.0 or 5.1.

  • SQLGetFunctions() reported that the driver supported SQLProcedureColumns(), even though it does not. (Bug #27591)
  • The row status array given to SQLExtendedFetch() was being stored as SQL_ATTR_ROW_STATUS_PTR, which could cause it to be used when it should not.
  • SQLSetPos() would not update a row unless all columns were bound, but it should only require that at least one column is bound and not set to be ignored.

View the complete list of changes »

Download Now »

Hints & Tips

White Paper: MySQL and DRBD High Availability Architectures

DRBD leverages synchronous replication transparent to the application, database or file system. Which, when used in conjunction with the open-source Linux Heartbeat package, enables solution architects to design a MySQL database which can leverage automated resource fail over after a failure, in a fully transaction-safe "hot standby" configuration. This white paper details how MySQL, DRBD and Linux Heartbeat can be combined to create highly available clustered systems.

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

White Paper: What's New: MySQL Monitoring and Advisory Service

This latest release extends the advanced monitoring and expert advisory services to include even more enterprise ready features and functionality, including SNMP notification options, 20 new Advisor rules, advanced graphing, support for FreeBSD & SuSE 10, and more.

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

Download the White Paper (French) » (http://www.mysql.fr/why-mysql/white-papers/mysql_wp_monitoring11.php.fr)

Documentation: Japanese Translation of the MySQL 5.1 Manual

This is the first time we're publishing work-in-progress. It is currently about 34% translated. We are doing this to give our Japanese community the chance to review and improve that translation at the earliest possible stage.

Send Feedback Directly to:

PlanetMySQL is Available in French

The popular MySQL blog aggregation site is now available in French. PlanetMySQL is a great place to visit for technical MySQL tips and tricks. If you are a blogger, you can also submit you RSS feed.

PlanetMySQL in French »

Feed submissions »

PlanetMySQL Blog: Auto-Generated-Consistent-ServerIds

Dathan Pattishall (Flickr)

I manage /etc/my.cnf from a template id. Since I use servers in pairs, all master-master setups, I need to ensure that the server id is unique and consistent for the server mysql is running on. Managing the id's is a pain, especially when servers change roles.

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: How to eliminate temporary tables in MySQL

Baron Schwartz (xaprb)

I've written before about how to make MySQL replication reliable. One thing I think you need to do to make statement-based replication reliable is eliminate temporary tables. I found an elegant way to replace temporary tables with real tables in the systems I maintain. This article explains how.

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: A Couple of Useful mysqldump Options

Corrado Pandiani

In my replication environment I had a hardware failure on master host. A 4.5 GB table containing blob images was corrupted, so I issued a REPAIR TABLE and the effect was to repair the table but also to reduce the number of rows. So, the problem now is how to recover only those rows from a slave and re-populate the master table avoiding to dump the entire table.

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: MySQL Optimizer and Prepared Statements

Sergey Petrunia

Performance-wise, the idea of Prepared Statements is that the server does certain pre-processing on PREPARE command, and then those steps are omitted when the statement is executed.

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: Google Semi-sync replication for MySQL 5.0.37

Mark Callaghan

I have uploaded the patch for semi-sync replication with MySQL 5.0.37 at http://code.google.com/p/google-mysql-tools. It is in the Source section (here) and there is some documentation on the wiki.

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: Changing masters

Jay Janssen

MySQL replication is cool. Almost everyone, when asked what they like best about MySQL, will mention replication. There can be no doubt that many web companies, Yahoo included, owes much to MySQL replication. How else can you scale the reading capacity of your database so easily?

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: MySQL Master-Master Replication Manager

Alexey Kovyrin

This release has lots of major fixes and I'm glad to announce first sponsored port of mmm to non-linux platform - it has been ported to Solaris 10. So, here are our changes in this version.

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: Use of join buffer is now visible in EXPLAIN

Sergey Petrunia

The join cache is actually not a new feature. It has been available in MySQL at least since version 4.0, and for all this time it has remained invisible and undocumented. The only thing that indicated its presense was the @@join_buff_size server variable.

Read the PlanetMySQL Blog post »

PlanetMySQL Blog: Introducing CMA: Certified MySQL Associate

Carsten Pedersen

Hot on the heels of our release of the Cluster certification comes our brand-new CMA: Certified MySQL Associate certification. We recommend the CMA certification for MySQL users that know the basics, but have not yet attained the experience gained by professional MySQL DBAs or Developers.

Read the PlanetMySQL Blog post »

Events

Live Web Seminar: Guide to Choosing an Embedded Relational Database (English & French)

May 23, May 24

Learn how to use unique MySQL features to improve your competitive advantage in the marketplace. In this webinar, which is designed specifically for OEMs and ISVs, you will learn:

  • To increase speed and manageability by embedding the MySQL Server Library into your application.
  • Meet regulatory data archiving requirements with the Archive Storage Engine.
  • Use triggers, stored procedures and views.
  • And More

Register for the Webinar (English) »

Register for the Webinar (French) »

Live Web Seminar: An Introduction to High Availability Architectures with MySQL and DRBD

May 31, 2007, 10:00am PDT

Join us for this webinar where you can learn how to combine MySQL, the world's most popular open source database in the world, with other open-source high-availability components like DRBD (Distributed Replication Block Device) and Linux-HA, to create scalable database clusters.

Register for the Webinar »

Live Web Seminar: Primetime ODBC: Constructing ODBC Applications and the ODBC 5.0 Roadmap

June 26, 2007, 10:00am PDT

Gerardo Narvaja, and Jess Balint will outline everything you need to know to get started creating applications powered by MySQL and using the Connector/ODBC driver. In this presentation you will learn about:

  • The future of Connector/ODBC
  • The features currently in development for the new Connector/ODBC 5.0 driver
  • How to install the ODBC driver on your client system and configure DSNs properly.

Register for the Webinar »

Training, Consulting and Certification

Consulting: MySQL Performance Tuning & Optimization (3+ Days)

  • Do your applications slow down during busy times?
  • Are you having difficulties pinpointing performance bottlenecks?
  • Will finding and fixing performance issues take weeks and expertise that you just don't have?

Then MySQL Performance Tuning & Optimization is for you. You will get expert insight and learn best practices to help you improve performance and scalability.

Schedule Your Engagement Now » (http://www.mysql.com/consulting/packaged/performance.html)

Training: MySQL 5.0 for Database Administrators (5 Days)

Paris, Beijing, Barcelona, Denver, Tokyo and more.

  • Is your MySQL database secure?
  • Do your users have the correct privileges and access rights?
  • Is your MySQL database operating at optimal efficiency? Do you want to increase the performance of your database and make sure it scales?
  • Do you want to save time using features like Stored Procedures, Triggers and Views?
  • Do you want to utilize the new enterprise features of MySQL 5.0?

Register Now for an Upcoming Date » (http://www.mysql.com/training/workshops/mysql_dba.html)

Partners

Webinar: Connecting FileMaker and MySQL to Quickly Create Database Solutions

June 12, 2007 - 8:00am & 11:00am

Connecting FileMaker and MySQL to Quickly Create Database Solutions FileMaker is more than database software, it is a rapid-application development environment anyone can use to quickly create data solutions. With the planned connection between FileMaker and MySQL, you will be able to combine the all-in-one ease of FileMaker database solutions with the open source strengths of MySQL.

Register for the Webinar (June 12, 8:00am PST) »

Register for the Webinar (June 12, 11:00am PST) »

HP: MySQL Sizing Guide and Benchmarks for HP BladeSystem

HP has teamed with MySQL to create a MySQL Sizing Guide and Performance Benchmarks for both low-end and midrange HP ProLiant BladeSystem servers.

Download Sizing Guide now »

Do you have a MySQL Solution for end users? Become a MySQL partner and grow your business today (No Cost)

If you market a MySQL-based software application or hardware solution to end users, you can increase your business by advertising your product(s) in our Solutions Catalog. Join hundreds of existing partners and let millions of MySQL users find your solution by becoming a partner. All it takes is a few minutes to understand the program, and fill out your company and product information.

Sign up and become MySQL's newest partner » (http://solutions.mysql.com/partners/)

The MySQL Team