|
 MySQL Newsletter
May 2007
newsletter@mysql.com
Articles in this newsletter:
Highlights
- DRBD for MySQL - New High Availability Solution for LAMP
- White Paper: MySQL Cluster Carrier-Grade Edition Scales to 100,000 Transactions per Minute in DBT2 Benchmark
- White Paper: Building Subscriber Databases with MySQL Cluster Carrier Grade Edition
- MySQL AB Launches New Business Partner Program
- MySQL Conference 2007 Wrap-up - Presentation Files Available
- MySQL Enterprise Unlimited
New Product Releases
- MySQL Enterprise Server 5.0.40
- MySQL Community Server 5.1.18 (Beta)
- MySQL MySQL Connector/ODBC 3.51.15 (GA)
Hints & Tips
- White Paper: MySQL and DRBD High Availability Architectures
- White Paper: What's New: MySQL Monitoring and Advisory Service
- Documentation: Japanese Translation of the MySQL 5.1 Manual
- PlanetMySQL is Available in French
- PlanetMySQL Blog: Auto-Generated-Consistent-ServerIds
- PlanetMySQL Blog: How to Eliminate Temporary Tables in MySQL
- PlanetMySQL Blog: A Couple of Useful mysqldump Options
- PlanetMySQL Blog: MySQL Optimizer and Prepared Statements
- PlanetMySQL Blog: Google Semi-sync Replication for MySQL 5.0.37
- PlanetMySQL Blog: Changing Masters
- PlanetMySQL Blog: MySQL Master-Master Replication Manager
- PlanetMySQL Blog: Use of join buffer is now visible in EXPLAIN
- PlanetMySQL Blog: Introducing CMA: Certified MySQL Associate
Events
- Live Web Seminar: Guide to Choosing an Embedded Relational Database (English May 23 & French May 24)
- Live Web Seminar: An Introduction to High Availability Architectures with MySQL and DRBD - May 31
- Live Web Seminar: Primetime ODBC: Constructing ODBC Applications and the ODBC 5.0 Roadmap (June 26)
Training, Consulting & Certification
- Consulting: MySQL Performance Tuning & Optimization (3+ Days)
- Training: MySQL 5.0 for Database Administrators (5 days)
Partner Corner
- Webinar: Connecting FileMaker and MySQL to Quickly Create Database Solutions
- HP: MySQL Sizing Guide and Benchmarks for HP BladeSystem
- Do you have a MySQL Solution for end users? Become a MySQL partner and grow your business today (No Cost)
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:
http://conferences.oreillynet.com/pub/w/54/presentations.html
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:
http://dev.mysql.com/doc/refman/5.0/en/releasenotes-es-5-0-40.html
Download Now (log-in required):
https://enterprise.mysql.com/software/enterprise.php
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:
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-18.html
Download Now:
http://dev.mysql.com/downloads/mysql/5.1.html
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:
http://lists.mysql.com/announce/454
Download Now:
http://dev.mysql.com/downloads/connector/odbc/3.51.html
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:
- Stefan Hinz stefan@mysql.com
- Yoshinori Matsunobu ymatsunobu@mysql.com
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:
http://fr.planetmysql.org/
Feed submissions:
http://fr.planetmysql.org/newfeed.php
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:
http://www.planetmysql.org/entries/7376
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:
http://www.planetmysql.org/entries/7319
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:
http://www.planetmysql.org/entries/6579
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:
http://www.planetmysql.org/entries/7113
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:
http://www.planetmysql.org/entries/7159
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:
http://www.planetmysql.org/entries/7245
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:
http://www.planetmysql.org/entries/7365
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:
http://www.planetmysql.org/entries/7362
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:
http://www.planetmysql.org/entries/6804
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):
http://www.mysql.com/news-and-events/web-seminars/oem.php
Register for the Webinar (French):
http://www.mysql.com/news-and-events/web-seminars/mysql-oem.php.fr
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:
http://www.mysql.com/news-and-events/web-seminars/drbd.php
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:
http://www.mysql.com/news-and-events/web-seminars/odbc.php
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):
https://filemakerevents.webex.com/filemakerevents/onstage/g.php?t=a&d=578492386
Register for the Webinar (June 12, 11:00am PST):
https://filemakerevents.webex.com/filemakerevents/onstage/g.php?t=a&d=570160872
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:
https://h30046.www3.hp.com/campaigns/2007/promo/1-3LNOP/index.php
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
About the Newsletter
You can send us queries and give us feedback online.
http://www.mysql.com/company/contact/
|
