Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Italy: +39 02 249 59 120
UK: +44 207 553 8447
Sun Microsystems announced the pending general availability of MySQL 5.1, a new version of the world's most popular open source database, designed to improve performance and simplify management of large database applications. A near-final release candidate of the GPL software is available for download.
Download the White Paper - Inside MySQL 5.1 » (http://www.mysql.com/why-mysql/white-papers/whatsnew-mysql-51.php)
Sun Microsystems announced the availability of MySQL Workbench, a new visual database design tool that integrates data modeling, physical database design, database creation, change management and documentation capabilities into a single, seamless environment for MySQL developers and DBAs. MySQL Workbench is available for download in two versions: an open source Community Edition and a (US) $99 commercial Standard Edition.
Learn More » (http://www.mysql.com/products/workbench/)
In a keynote presentation this morning at the MySQL Conference & Expo, Sun executives Rich Green and Mårten Mickos announced the winners of the 2008 MySQL Community, Partner-of-the-Year and Application-of-the-Year Awards.
Community Member of the Year Awards » (http://www.mysql.com/why-mysql/awards/community-2008.html)
Partner of the Year Awards » (http://www.mysql.com/why-mysql/awards/partner-of-the-year-2008.html)
Application of the Year Awards » (http://www.mysql.com/why-mysql/awards/app-of-the-year-2008.html)
Sun Microsystems, Inc. today announced new and enhanced third-party support for the MySQL™ database's unique pluggable storage engine architecture. The MySQL Certified Storage Engine Program (www.mysql.com/engines) enables commercial and community database engine developers to certify that their software has been tested and is compatible with Sun's MySQL Database Server - helping to assure MySQL users that these certified engines have reached high-level standards of usability, performance and integration.
Read the Press Release » (http://www.mysql.com/news-and-events/press-release/release_2008_15.html)
Thank you to the 2000+ attendees, speakers, partners and staff that made the 2008 MySQL Conference and Expo the largest and most successful Conference ever. Follow the links below to view the speaker presentation files, photos, news and media coverage.
MySQL is the world's most popular open source database software. As part of Sun Microsystems' software group, MySQL is a global organization with over 400 workers in 25 countries. We are looking for talented professionals in engineering, sales, marketing, professional services, and support that will contribute to our products' strong momentum and share in our success! We have openings for the following positions:
Apply Now » (http://www.mysql.com/jobs/)
We are proud to present to you the MySQL Server 5.1.24-rc release, a new "release candidate" version of the popular open source database. Changes include:
MySQL is proud to announce the Spring 2008 Release of the MySQL Enterprise Monitor. A new Upgrade Advisor identifies the most up to date, secure and reliable version of MySQL that you should be running. Plus, the MySQL Enterprise Monitor is also available in Japanese. The new feature set includes:
Learn more » (http://www.mysql.com/products/enterprise/whats_new.html)
The MySQL Developer Tools team is proud to announce that the result of our recent project, MySQL Workbench, has reached GA status. MySQL Workbench is a next-generation visual database design application that can be used to efficiently design, manage and document database schemata. MySQL Workbench is available for download in two versions: an open source Community Edition and a (US) $99 commercial Standard Edition. Fixes includes:
MySQL Connector/ODBC 5.1.4, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the first generally available (production) release of the 5.1 series and is suitable for use with any MySQL server version since MySQL 4.1, including MySQL 5.0, 5.1, and 6.0. (It will not work with 4.0 or earlier releases.) Fixes include:
MySQL Connector/Net 5.0.9, a new version of the all-managed .NET driver for MySQL has been released. This release is an update to the existing production-quality 5.0 series. We plan for this to be the last release in the 5.0 series. We will only be updating the 5.0 product in the event a "data-loss" type bug is discovered. We encourage all new products to use the new 5.1 product. Changes include:
In an effort to provide DBAs with a belt-and-suspenders support and alert system and to further help take the guesswork out of deciding which version of the MySQL server they should be running, MySQL Enterprise now provides the new Upgrade Advisor. The premise is simple; the Upgrade Advisor provides monitoring for specific security and crash inducing bugs that affect current versions of the MySQL Community or Enterprise Server running in an Enterprise Monitor protected environment.
The Falcon team has designed a set of new Information Schema tables to help you understand how well Falcon is performing and where issues may be developing. Let's take a quick look at some of these new tables and see how you can make use of them when you're working with Falcon.
This paper looks at the various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how the MySQL Workbench product from MySQL can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.
Download the White Paper - A Data Modeling Guide for Developers and DBAs » (http://www.mysql.com/why-mysql/white-papers/mysql-workbench-database-design-development-administration/)
Database backup and recovery are a primary responsibility of every enterprise DBA. This white paper is a guide to the requirements, challenges, and solutions available to the MySQL DBA. You will learn about Logical/Raw backups, Hot/Warm backups, Full/Incremental backups, Snapshots, Point-in-Time Recovery, Retention Policies, Compliance, Access Control, Scheduling, Monitoring and Administration.
Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_zrm_backup_recovery.php)
Download a 30 Day Trial Version » (http://www.mysql.com/trials/zrm)
Jasper for MySQL: OEM Edition 2.0 builds on earlier releases to provide significant enhancements to this high-performance interactive report server optimized for MySQL users. This white paper includes details on many of these enhancements to better assist you in understanding what 2.0 provides.
Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_jasper_oem.php)
Download a 30 Day Trial Version » (http://www.mysql.com/trials/jasper)
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.
If you use a transactional storage engine in MySQL like InnoDB some of your transaction may be terminated by the storage engine because of deadlocks. Sadly it is a bit tricky to see what has led to the deadlock. SHOW ENGINE INNODB STATUS gives only a very minimal look into the state when it happened.
With the proxy and a little script we can track what happened in all open transactions before the deadlock happened. A classic example is the cross-over deadlock:
This is an idea I came across at the MySQL UC last week: How many applications handle failing COMMITs correctly? And how can we test it?
This year, we got fourteen Google Summer of Code projects accepted. Colin Charles has informed the students, and things can now get started!
MySQL Performance Blog
Have you ever run a query in MySQL and wondered how long it'll take to complete? Many people have had this experience. It's not a big deal until the query has been running for an hour. Or a day and a half. Just when IS that query going to finish, anyway?
Sheeri K. Cabral
At the 2008 MySQL Conference and Expo, The Pythian Group gave away EXPLAIN cheatsheets. They were very nice, printed in full color and laminated to ensure you can spill your coffee* on it and it will survive. For those not at the conference, or those that want to make more, the file is downloadable as a 136Kb PDF
Welcome to Tip #1 in MySQL Replication Series. In this tip we will go over what to do when you only want to replicate certain data to slave(s). Most general way to tell what is replicated to which slave is to include following configuration directive in my.cnf file depending on your environment and your goals.
Whenever I work at a place I do the following. Get a rundown of what the application is, what its demands are, what does the company expect the application to be a year from now - like how many users are going to use the application. 10 million, 20 million, 100 million?
A group of us gathered around to hear about some work that had been done in getting a MySQL Cluster backend for OpenLDAP.
I'd heard a bit of rumors about this previously, but last night was the first time I a) saw it working and b) saw performance numbers.
A few minutes ago I uploaded the new issue of the MySQL Magazine. I am very excited about this issue as the quality continues to increase!
Thursday, May 08, 2008
Join us for this informative webinar where we will explore how open source Web 2.0 technologies, applications and architectures leveraging MySQL Enterprise can help enable information access across an enterprise's entire technology spectrum, through a network of tightly and loosely integrated applications, services and devices. We will also explore various use cases for the enterprise, including technology overviews of MySQL Replication, MySQL Load Balancer, DRBD and Memcached for MySQL.
Thursday, May 15, 2008
Join us for an informative webinar where we will explore how Software as a Service providers are leveraging MySQL Enterprise to build scalable, high performance web applications based on multi-tenant architectures. We will review the benefits a MySQL Enterprise subscription can bring to an organization along with an overview of available add-ons like DRBD, MySQL Load Balancer and Memcached, for delivering highly available and scalable SaaS applications in a multi-tenant environment.
Tuesday, May 20, 2008
In this Webinar you will learn from ScienceLogic about how they are using MySQL to perform hundreds of millions of database writes daily and continue to scale and perform extremely well.
May 4-5, 2008, San Francisco
Its not easy to start your own business. There are countless decisions to make from how you differentiate your product to how you support your customers and provide timely service. Startup Camp is an unconference-style event that's dedicated to bringing together the various members of the startup community for a face-to-face collaborative meetup where its the attendees that drive the agenda.
In this engagement, a dedicated MySQL certified consultant will work closely with your team to deliver the following benefits:
Learn More » (http://www.mysql.com/consulting/packaged/health.html)
Washington D.C., Toronto, Mexico City, Berlin, Warsaw
Want to join the wonderful world of MySQL? Here's your chance to learn how this powerful relational database management system can make your life easier and more fun! This class covers all the basics and will get you on your way, with a solid foundation. This instructor led, hands-on class covers the fundamentals of SQL and relational databases, using MySQL as a teaching tool.
Register Now for an Upcoming Date » (http://www.mysql.com/training/courses/introduction_to_databases.html)
Qualiteam Software, a MySQL OEM customer and MECA partner, is an IT company specializing in ebusiness-focused technology solutions, including shopping cart software development, system integration/migration, IT consulting, software outsourcing and e-commerce web site design. Qualiteam Software chose the MySQL database for its e-commerce applications due to its high performance, economy resource usage, flexibility and wide availability on most hosting platforms. Recently, Qualiteam Software introduced a new shopping cart hosting service, X-Cart hosting, equipped with the outstanding set of unique e-commerce hosting features.