MySQL Newsletter February 2008
Articles in this newsletter
- Letter from Mårten Mickos, SVP, Database Group, and Rich Green, EVP, Software, Sun Microsystems
- Letter from Jonathan Schwartz, CEO & President, Sun Microsystems
- Press Release: Sun Microsystems Announces Completion of MySQL Acquisition
- MySQL and Sun World Tour
- MySQL and Sun Community Townhall
- Gartner News: Analysis on MySQL Acquisition
- MySQL Conference and Expo 2008 - Register Now
- White Paper: MySQL Enterprise for Managed Hosting & SaaS Providers
- Case Study: Alstom Selects MySQL as a Database Standard for Power Plant Monitoring
- MySQL Jobs
- New Release of MySQL Community Server 5.1.23 (Release Candidate)
- New Release of MySQL Community Server 5.0.51a (GA)
- New Release of MySQL Workbench 5.0.14 (Beta)
- Article: A Q&A Session with Mårten Mickos about the Sun Acquisition
- Article: MySQL Information Schema Plugins: the best kept secret of MySQL 5.1
- Article: Reporting MySQL Internals with Information Schema plug-ins
- PlanetMySQL Blog Posts
- Live Webinar: MySQL Guide to Choosing an Embedded Relational Database (EMEA)
- Live Webinar: MySQL Crazy Data Formats and Multiple Data Sources? Taming Your Messy Mashups
Today, MySQL proudly joins forces with Sun Microsystems, the leading provider of platforms for the Web economy and the largest commercial open source contributor. We thank you - our customers, developers and community members - for your trust and continued support. Our commitment to you is that MySQL will continue to be a leader in the open source community and now, as a part of Sun, we will provide a new level of innovation, service and support.
Today is a big day for Sun and the MySQL community. We have closed our acquisition of MySQL AB and proudly join forces with this open source icon and the company behind the world's most popular open source database. Sun already is the leading provider of platforms for the Web economy and the largest commercial open source contributor. As of today, Sun also is a formidable player in the $15 billion database market. We thank you - our joint customers, developers and community members - for making this possible.
Sun Microsystems, Inc. today announced it has completed the acquisition of MySQL AB, developer of the world's most popular open source database, for approximately $1 billion in total consideration. Sun also unveiled the immediate availability of MySQL's complete portfolio of products and enterprise services backed by its 17,000-strong global sales and services organization and its extensive international network of authorized distribution channels. Sun now provides a single, secure choice for customers and developers seeking to put MySQL into deployment on a global basis.
February - April
Sun and MySQL meetups are coming near you. This special world tour brings together the expertise, best practices, and technology know-how directly to you. Find out when they are going to be in your city.
March 4th, 10:00am PST
Join the conversation with Sun and MySQL executive team in the Community Townhall on March 4th at 10am PST.
The MySQL purchase immediately casts Sun in the role of a major open-source database management system vendor with heterogeneous operating system solutions. IBM, Oracle and Red Hat will likely feel some market pressure.
MySQL Conference & Expo draws more than 1,600 participants and offers more than 100 sessions and tutorials, led by some of the leading database and open source experts in the world. Register early and reserve your spot in one of the following high-intensity, hands-on tutorials:
- Real World Web Scalability
- Getting Started with MySQL Proxy
- MySQL Cluster Tutorial
- A Hands-on Introduction to High-Availability MySQL and DRBD
- Memcached and MySQL: From Soup to Nuts
- MySQL Workbench
Whether a SaaS provider chooses to host their applications in-house or remotely at either a collocation or a managed hosting facility, a subscription to MySQL Enterprise helps ensure that the databases comprising the core elements of their technology platform meet or exceed the expected Service Level Agreements (SLAs) concerning performance, scalability and uptime.
Download the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql-enterprise-edition-for-saas-providers/)
Alstom is a global leader in the world of power generation and rail infrastructure. As part of Alstom's power plant monitoring product (AMODIS®), a relational database that was low cost and robust was needed. MySQL was chosen as the relational database and is embedded in each AMODIS® system that is deployed in power plants worldwide.
Download the Case Study » (http://www.mysql.com/why-mysql/case-studies/alstom-selects-mysql-for-power-plant-monitoring/)
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:
- Support Engineers
- Senior Software Engineers
- Senior Sales Representatives
- Sales Engineers
- Senior Instructors
- Senior Consultants
- And More ...
Apply Now » (http://www.mysql.com/jobs/)
We are proud to present to you the MySQL Server 5.1.23-rc release, a new "release candidate" version of the popular open source database. This release includes:
- Partitioning: Security Fix - It was possible, by creating a partitioned table using the DATA DIRECTORY and INDEX DIRECTORY options to gain privileges on other tables having the same name as the partitioned table. As a result of this fix, any table-level DATA DIRECTORY or INDEX DIRECTORY options are now ignored for partitioned tables.
- Security Fix: Replication: It was possible for any connected user to issue a BINLOG statement, which could be used to escalate privileges. Use of the BINLOG statement now requires the SUPER privilege.
- Replication: Replication of the following now switches to row-based logging in MIXED mode, and generates a warning in STATEMENT mode: USER(), CURRENT_USER(), CURRENT_USER, FOUND_ROWS(), ROW_COUNT()
MySQL Community Server 5.0.51a, a new version of the popular Open Source Database Management System, has been released. MySQL 5.0.51a is a security hotfix release. We recommend all users of any previous release in the MySQL 5.0 Community Server branch to upgrade to 5.0.51a as soon as possible. This release includes:
- Security Fix: Three vulnerabilities in yaSSL versions 1.7.5 and earlier were discovered that could lead to a server crash or execution of unauthorized code. The exploit does not apply to OpenSSL.
- Security Fix: ALTER VIEW retained the original DEFINER value, even when altered by another user, which could allow that user to gain the access rights of the view. Now ALTER VIEW is allowed only to the original definer or users with the SUPER privilege.
- Security Fix: When using a FEDERATED table, the local server could be forced to crash if the remote server returned a result with fewer columns than expected.
MySQL Workbench is a next-generation visual database design application can be used to efficiently design, manage and document database schemata. For more information about the MySQL Workbench project please visit the MySQL Workbench Developer Central site at http://dev.mysql.com/workbench/. This Beta release includes 35 closed bugs and some major improvements.
We got a chance to speak with Mårten Mickos about Sun's acquisition of MySQL, and we asked him some questions, that the community at large, might have.
MySQL 5.1 offers an extremely useful feature called information_schema plugins. This feature allows dynamic runtime loading of a shared library into the MySQL server to implement a table in the information_schema database.
Last week, I described how to use the MySQL plug-in API to write a minimal 'Hello world!' information schema plug-in. The main purpose of that plug-in is to illustrate the bare essentials of the MySQL information schema plug-in interface.
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.
As a follow up to the series of posts I've been making, I wanted to post what I ended up with. Thanks to everyone who posted comments, your help was extremely useful. To recap, I have a working pair of events to add and remove partitions to this table.
The MySQL Lifecycle Policy determines which versions are actively supported, and for which platforms such support applies. The basic principle is that old versions are supported for a quite long, but definitely limited period, once they have been replaced by a newer GA version.
What version you should use depends on what features you need, but CGE 6.2 is more mature than 6.3 at the point of writing and is used in production in a number of places of some of the largest telco's in the world. CGE 6.3 is a version that many of our customers are developing and testing on right now.
Do you create transient tables and then use them with complex queries? By transient I mean a table with a short lifetime, temporary or not. If there are indexes on them, then you should run ANALYZE TABLE prior to running queries. But what you need to do is determined by the type of storage engine you use.
Tuesday, March 04, 2008
If you are considering embedding or bundling a relational database in your software applications or hardware products, then you won't want to miss this web seminar. MySQL is the most popular database for ISVs, VARs, hardware vendors, and network appliance manufactures who want to cost-effectively embed or bundle a reliable, high-performance relational database. Learn how to use unique MySQL features to improve your competitive advantage in the marketplace.
Tuesday, March 11, 2008
If you value the information stored in your MySQL database, you will need to ensure successful, secure and consistent backups with minimal impact on the database application. In this webinar, we will discuss methods to make sure that your backup solution provides the most efficient use of network, server and storage resources.
In this engagement, a dedicated MySQL certified consultant will work closely with your team to deliver the following benefits:
- Accelerate the development process by ensuring the application is architected correctly
- Help ensure application meets current and future business requirements
- Minimize re-architecting efforts when business conditions change
- Learn and use best practices techniques to ensure success
Learn More » (http://www.mysql.com/consulting/packaged/architecture.html)
Sacramento, Dallas, Berlin, Paris, Lyon, Toronto
- Do you want to monitor, diagnose problem areas and tune MySQL for optimal performance?
- Do you want to write queries that take advantage of the MySQL 5.0 performance enhancements dealing with queries and indexing?
- Do you want to Evaluates the application architecture for efficient design, structure, caching, number of connections and other factors affecting performance
Register Now for an Upcoming Date » (http://www.mysql.com/training/courses/performance_tuning.html)
On Feb 25, 2008, Sun acquired MySQL AB. As a result, personal information you provided to MySQL may be shared now also with Sun to support ongoing business processes. Sun Microsystems, Inc. and MySQL AB respect your desire for privacy. Sun and MySQL, as global companies, may transfer your personal information to other countries than in which it originated. Sun and MySQL, however, are committed to providing a suitable and consistent level of protection for your personal information regardless of the country in which it resides. If you disagree with the above processing of your personal information, please use the unsubscribe instructions below.
If you wish to unsubscribe from future email marketing communication from MySQL use the unsubscribe instruction below. If you do not wish to receive email communications from Sun, please visit http://www.sun.com/cgi-bin/sun/dne/ or forward this message to firstname.lastname@example.org with remove from sun or unsubscribe from sun in the subject line.