Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Italy: +39 02 249 59 120
UK: +44 207 553 8447
MySQL has become the world's most popular open source database because it's built for the Web economy. Now with Sun Systems for MySQL, you can scale with up to 3x greater performance and save up to half the cost, backed by Sun's systems and software expertise.
In this presentation, trusted advisors from Gartner and Sun Microsystems discuss the business options and best practices for open source databases. We will also find out how Zappos.com, a highly successful ecommerce site, saves over $1 million a year annually and stays on top of their explosive growth by subscribing to Sun's MySQL Enterprise Database subscription.
MySQL Performance Tuning is always a popular topic for DBAs and Developers. Traditionally, database tuning has required manual effort and custom scripts. MySQL Query Analyzer aims to minimize the manual effort, with easy-to-use tools to help find-n-fix problem queries. In this interview, we talk with Mark Matthews, to get an architects view of the product.
Also, the MySQL Query Analyzer is now part of the MySQL Enterprise 30-day Trial.
Register for the Trial » (http://www.mysql.com/trials/)
MySQL User Conference comes to Asia! In these one-day conferences, you will gain knowledge you need to rapidly build solid applications with MySQL that scale with the enterprise. Join us and other MySQL DBAs and developers to innovate with MySQL.
The 2009 MySQL Conference & Expo, April 20-23, 2009 in Santa Clara, CA, brings over 2,000 open source and database enthusiasts together to harness the power of MySQL and celebrate the huge MySQL ecosystem. Save the date and join us for the largest gathering of MySQL developers, users, and DBAs worldwide. Early registration opens soon.
Appliances provide all of the software and hardware necessary to deliver a function-specific "shrink-wrapped" solution. They eliminate much of the cost, complexity and "guesstimates" inherent in self-assembled solutions. Using the MySQL Embedded Server enables appliance vendors to deliver a differentiated solution, bring products to market faster, reduce COGS and improve profitability, and win competitive comparisons.
Learn more » (http://www.mysql.com/why-mysql/isv-oem-corner/appliance/)
Are you an ISV? Learn how other ISVs grow businesses using MySQL » (http://www.mysql.com/why-mysql/isv-oem-corner/)
More resources for ISVs » (http://www.mysql.com/why-mysql/isv-oem-corner/resources.html)
Thursday, November 20, 2008 - 10:00am PST
The MySQL Enterprise 2008 Fall Release is designed to alleviate pain points around diagnosing and fixing performance problems related to poorly performing SQL code. Join us to see how the MySQL Query Analyzer helps keep your key MySQL systems up and running at the highest levels of scalability and performance.
Shinsei is a leading financial institution in Japan. Shinsei has standardized on MySQL and SugarCRM for their customer relationship management (CRM) system and developed a unique "path-based" approach to developing and deploying applications which gives them the flexibility to modify their system as business requirements change. As a result, Shinsei successfully developed an entirely new enterprise system in one fourth the time and at a savings of 90% of the cost of using legacy mainframes and proprietary packaged software.
Read the Case Study » (http://www.mysql.com/why-mysql/case-studies/shinsei-bank-relies-on-mysql/)
MySQL University is a no cost training program for Sun Database Group Engineers, MySQL Community Contributors and anyone who's interested in MySQL development and internals. Sessions are run via voice stream and IRC feedback channel and usually last for an hour. Upcoming topics include Using memcached in MySQL deployments, What's New in MySQL Optimizer, Random Query Generator, Developing MySQL on Solaris, and much more.
We are proud to present to you the MySQL Server 5.1.29-rc release, a new "release candidate" version of the popular open source database.
MySQL 6.0.7-alpha, a new version of the MySQL database system has been released. Changes include:
We managed to fix 15 bugs since our last release on 10/14/2008. It features a huge improvement on memory usage and an updated layer-pane, listing all objects on a diagram-canvas - now including connections too (this allows easy selection of hidden objects). Please keep posting any issues that you encounter while working with our product.
Thanks for all the feedback and contributions we received since we released the first alpha builds. We have added functionality, fixed bugs and started to build packages for Fedora Core 9 along with our native packages for Ubuntu 8.04. Grab a package of your choice and give it a try. Please don't use this version on your production-level-files, it's still in alpha stage.
MySQL Connector/J 5.1.7, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Changes targeted at scalability and performance include:
Just one week after the long awaited release 13 we are pleased to announce the next one. Effective immediately you can download version 5.0-r14 of the MySQL GUI Tools from our mirror servers. While the previous release focused merely on MySQL Administrator and MySQL Query Browser, this new one also addresses MySQL Migration Toolkit issues. With this release almost every high priority bug of the GUI Tools has been fixed and we will go now through a longer course of working on the not so serious but nonetheless annoying problems. Fixes include:
Parallel Ltd. was founded in 1998 and is based in Milton Keynes, United Kingdom. Our main product is SatManage, a web-based application for managing satellite networks.
At Parallel we've used Partitioning since the very first release of 5.1 (sometime December 05). We're now on MySQL 5.1.20 and 5.1.22 and we started development using partitioning with MySQL 5.1.3.
Understanding and programming MySQL data load into the DataGridView control is a must for Windows Application Developers today. Many times, in real production environment the end-users need to see a result set of data to make daily business decisions. The main question is about how many records they need to see when the control gets loaded.
MySQL Magazine is the magazine for the community of MySQL database administrators and developers who use MySQL on a daily basis to provide some of the best infrastructure available.
What will you find here? News, articles on both administration and development, and feedback from the users. Simply anything related to MySQL!
Inside the Fall 2008 Issue:
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.
You Mean, Memory Is Not Infinite?
We're working hard getting MySQL Enterprise Monitor 2.0, featuring Query Analyzer, ready for release. As part of that, we started really ramping up the number of MySQL servers reporting in query data to see how we could scale. Not surprising (to me, anyway), the first efforts did not go so well. My old friend OutOfMemoryError reared its ugly head once again.
If you use MySQL Replication, 99% of the times your main concern is to keep the master and the slave fully consistent and in sync. Some applications require exactly the opposite.
I recently attended an interesting talk by Brion Vibber, CTO of WikiMedia Foundation, a non-profit organisation that runs the infrastructure for Wikipedia. He described how his team of 7 engineers manages the Wikipedia site that gets on an average of 7 billion page views per month.
The MySQL Telecom Team
By the end of 2007, to the surprise of many of us, a guy at Nokia Research Center announced that they had ported and were about to publish the full LAMP stack running on the Symbian/S60 platform of Nokia mobile phones. They dubbed this the Personal AMP stack: PAMP, and you can run most of the popular PHP apps like Wordpress, Drupal, phpMyAdmin... out of the box on a Nokia phone now.
As I expected it would, the fact that I used ZFS compression on our MySQL volume in my little OpenSolaris experiment struck a chord in the comments.
On the cluster mailing list (email@example.com, thread "slow selects") there was recently a very good example of how to optimize queries on Cluster. Thanks to Nick Keefen for raising this problem and Jeff Sturm for the answer how to solve it!
A popping question is: "Can an execution plan change for different storage engines?"
The answer is "Yes". I will present two such cases, where the MySQL optimizer will choose different execution plans, based on our choice of storage engine.
When running InnoDB you are able to dig into the engine internals, look at various gauges and counters, see past deadlocks and the list of all open transactions. This is in your reach with one simple command -- SHOW ENGINE InnoDB STATUS. On most occasions it works beautifully. The problems appear when you have a large spike in number of connections to MySQL, which often happens when several transactions kill the database performance resulting in very long execution times for even simplest queries, or a huge deadlock.
The mysqlbackup client program is now available for download as a feature preview. This program gives information about the produced backup image files and is a complement to the new MySQL 6.0 Backup feature. The program is not yet part of the main MySQL server releases.
Martin 'MC' Brown
I've mentioned a number of times that the documentation repositories that we use to build the docs are freely available, and so they are, but how do you go about using them?
Wednesday, November 19, 2008 - 10:00 am PST
Are you experiencing pain points around diagnosing and fixing performance problems related to poorly performing SQL code? Do you have a data backup and recovery plan that ensures data availability and integrity in case of accidental data loss or destruction?
Join Rob Young, Senior MySQL Enterprise Product Manager and TK Krishnamurthy, Vice President, Services, Support and Operations from Zmanda as they discuss the benefits of using MySQL Enterprise - including the new Query Analyzer - and backup/recovery with Zmanda Recovery Manager for MySQL to keep your MySQL systems high performing and safeguarded.
Tuesday, November 25, 2008 - 14:00 GMT
In today's fast moving business environment, it is clear that Business Intelligence (BI) is a mandatory part of any company's decision making environment. The question then becomes how to build this environment in a cost-effective way that keeps up with ever-changing business requirements, new and large numbers of users, all forms of analytics, and increasing volumes of data.
Sign-up for this web presentation to learn:
A dedicated MySQL certified consultant will work closely with your team to:
Learn More » (http://www.mysql.com/consulting/packaged/cluster.html)
Raleigh, Paris, Lyon, Boston
This course is designed for database administrators and others who wish to monitor and tune MySQL. This course will prepare you with the skills needed to utilize tools for monitoring, evaluating and tuning. You will evaluate the architecture, learn to use the tools, configure the database for performance, tune application and SQL code, tune the server, examine the storage engines, assess the application architecture, and learn general tuning concepts.
Register Now for an Upcoming Date » (http://www.mysql.com/training/courses/performance_tuning.html)
The new version of Zmanda Recovery Manager (ZRM) supports Zmanda Management Console (ZMC) running on 32- and 64-bit Ubuntu and Debian. Also, the ZRM server can now run on Windows, protecting MySQL in all-Windows environments, in addition to Linux and Solaris. Furthermore, the new version of ZRM provides the capability of doing backup of files at the same time as backup of MySQL database. That simplifies recovery of a database and the application that uses MySQL.
MySQL is already busy planning the 2009 MySQL User Conference to be held in Santa Clara, California at the Santa Clara Convention Center, April 20-23, 2009. More than 1900 open source enthusiasts attended the conference in 2008, and this marquis event promises to be an even bigger and better in 2009.
MECA partners are eligible for an early-bird discount if you submit a signed contract by November 30th. We fully expect to sell out this year so please contact us early at firstname.lastname@example.org to become a MySQL Conference & Expo Sponsor.
Learn more » (http://solutions.mysql.com/events/uc2009-sponsorship.html)