MySQL Newsletter April 2009
Articles in this newsletter:
- Sun Microsystems Announces MySQL 5.4
- Sun Microsystems Announces MySQL Cluster 7.0
- Sun Announces MySQL Community, Partner & Application of the Year Awards
- Press Release: Oracle to Buy Sun
- MySQL European Conference 2009 - Save the Dates!
- Renew and Get the Most Out Of Your MySQL Enterprise Subscription
- Case Study: Virgin Mobile France Chooses MySQL Enterprise Unlimited to Drive Growth
- Case Study: Netlog ensures fast response times as traffic increases 300% with MySQL Enterprise Unlimited
- Live Webinar: Using MySQL Query Analyzer to Remove Performance Bottlenecks (EMEA) (April 28, 2009)
- Upcoming MySQL University Sessions
- New Release of MySQL Community Server 5.1.34 (GA)
- New Release of MySQL Enterprise Monitor 2.0.5 (GA)
- New Release of MySQL Connector/C++ 1.0.5 (GA)
- New Release of MySQL Connector/C 6.0.1 (GA)
- New Release of MySQL Connector/Net 6.0.2 (Beta)
- New Release of MySQL Workbench 5.1.10 (Beta)
- New Release of MySQL Connector/OpenOffice.org 1.0.2 (Alpha)
- Article: Getting Started with DTracing MySQL
- Article: Five Query Optimizations in MySQL
- Tutorial: Using the MySQL Connector/J JDBC Driver With the Java SE Platform
- White Paper: Improving MySQL Database Scalability
- White Paper: High Availability MySQL Database Replication with Solaris Zone Cluster
- PlanetMySQL Blog Posts
- PlanetMySQL Blog: MySQL 5.4 Scalability on 64-way CMT Servers
- PlanetMySQL Blog: MySQL 5.4 Scaling on Nehalem with Sysbench
- PlanetMySQL Blog: MySQL & Google Summer of Code 2009 - time to get going!
- PlanetMySQL Blog: LDAP and MySQL Cluster
- PlanetMySQL Blog: How MySQL Sandbox Solves All My Problems
- PlanetMySQL Blog: What's the Performance impact of the Double Write Buffer?
- PlanetMySQL Blog: Multi-source replication with MySQL Cluster
- PlanetMySQL Blog: MySQL DBA 5.1 Exam Contents
- Event: The MySQL "Lower-Your-COGS Workshop for ISVs and OEMs" is coming to New York City (May 7, 2009)
- Article: Developing Database Applications Using MySQL Connector/C++
- Article: Installing MySQL Connector/C++ from Source
- PlanetMySQL Blog: Libmysqld performance. And a Webinar. And a talk at the UC!
- PlanetMySQL Blog: MySQL Connector/C++: how to build a client on Linux using NetBeans 6.5
- White Paper: Reducing ISV Risk Using MySQL
- White Paper: MySQL Embedded Server 5.1 for Commercial ISVs/OEMs
- Case Study: Adobe Relies on MySQL to Make Creative Professionals More Productive
- Case Study: Tema Networks Selects MySQL Embedded Server to Power its Real Time Mobile Billing Solution
- Live Webinar: For Commercial ISVs and OEMs: Securely and Seamlessly Deploy MySQL with Your Application (May 12, 2009)
- Live Webinar: For Commercial ISVs: The New MySQL Connector/C++ (May 20, 2009)
- Live Webinar: Mission Critical Coverage with MySQL Enterprise Technical Services (April 28, 2009)
- Live Webinar: What's New in Memcached 1.3 (April 29, 2009)
- Live Webinar: Scaling MySQL Leveraging Sun Systems (Australia/New Zealand) (April 30, 2009)
- Live Webinar: What's New in MySQL Cluster 7.0? (April 30, 2009)
- Live Webinar: Memcached Technical Deep Dive (May 05, 2009)
- Live Webinar: MySQL and Search at Craigslist (May 07, 2009)
- Live Webinar: Running MySQL Web Services on Sun systems with Intel Xeon 5500 processors (May 12, 2009)
- Live Webinar: Guide to Open Source Data Warehousing for Communications Service Providers (May 13, 2009)
- Live Webinar: Database Sharding at Netlog with MySQL and PHP (EMEA) (May 13, 2009)
- Training: MySQL for DBAs (5 Days)
- Certification: NEW! Performance-Based Testing for MySQL 5.1 Certification
- Consulting: MySQL Data Warehouse Jumpstart (8+ Days)
Sun Microsystems announced MySQL 5.4, a new version of the world's most popular open source database, designed to deliver significant performance and scalability improvements to MySQL applications. A preview version of MySQL 5.4 is available for download now.
Download MySQL 5.4 Now » (http://www.mysql.com/5.4)
Sun Microsystems announced MySQL Cluster 7.0, a major new release of its high-availability open source database software for real-time, mission-critical applications. New features include significantly enhanced performance and scalability; support for popular LDAP directories; and simplified cluster back-up and maintenance.
Read the White Paper "MySQL Cluster 7.0: Architecture and New Features" » (http://www.mysql.com/why-mysql/white-papers/mysql-cluster-7-2-new-features-whitepaper/)
In a keynote presentation at the MySQL Conference & Expo, Sun executives Karen Padir and Kaj Arnö announced the winners of the 2009 MySQL Community-Member-of-the-Year, Partner-of-the-Year and Application-of-the-Year Awards.
Community Member of the Year Awards » (http://www.mysql.com/why-mysql/awards/community-2009.html)
Partner of the Year Awards » (http://www.mysql.com/why-mysql/awards/partner-of-the-year-2009.html)
Application of the Year Awards » (http://www.mysql.com/why-mysql/awards/app-of-the-year-2009.html)
Sun Microsystems and Oracle Corporation announced on today they have entered into a definitive agreement under which Oracle will acquire Sun common stock for $9.50 per share in cash. The transaction is valued at approximately $7.4 billion, or $5.6 billion net of Sun's cash and debt.
MySQL Conference is coming to the Europe again in 2009. We had a great success in 2008, and we invite all alumni as well as new faces to join us this year. Save the dates and we'll have more information for you soon!
- Köln Germany, October 20th, 2009
- London, October 22nd, 2009
- Paris, November 18th, 2009
View the agenda and presentation slides in MySQL European Customer Conference 2008 » (http://www.mysql.com/news-and-events/european-conferences/2008/)
Your MySQL Enterprise subscription provides access to the software and services that keep your systems high performing, secure and reliable. Do you have a subscription that's about to expire? Learn why you should renew now:
- Get a 200% Return on Your Investment in MySQL Enterprise
- Don't risk your business with downtime that will result in lost revenue and profits
- Improve MySQL Performance by up to 300% with the MySQL Query Analyzer
- Maintain your High Availability with the MySQL Enterprise Monitor
- Be the first to receive new releases and save time and effort writing, testing, versioning, and deploying custom scripts with the MySQL Advisors, Rules and Alerts
- Receive Design and Tuning Advice from MySQL Support Engineers
Renew Your Subscription Now » (http://www.mysql.com/about/contact/renew.html)
Learn More » (http://www.mysql.com/products/enterprise/renew_six_reasons.html)
Virgin Mobile France, launched in April 2006, has become the fourth mobile operator in the country with over 1 million customers. Launched by Sir Richard Branson, Virgin Mobile is now the world's leading mobile virtual network operator (MVNO) with over 11 million customers in 7 countries (UK, Australia, USA, Canada, South Africa, India and France).
Case Study: Netlog ensures fast response times as traffic increases 300% with MySQL Enterprise Unlimited
Netlog is one of the fastest-growing social networks in Europe. The target group is young people, 14-24 years of age, and Netlog is primarily used for communication, entertainment and sharing music and photos. Access to MySQL Enterprise's monitoring and support services helps Netlog deliver excellent performance, security and response times on its 300 database servers.
Read the Case Study » (http://www.mysql.com/why-mysql/case-studies/mysql_cs_netlog.php)
Tuesday, April 28, 2009 - 15:00 CET
Join this webinar to learn how the MySQL Query Analyzer, a new feature in the MySQL Enterprise subscription, can help DBAs and Developers like you improve application performance by monitoring query performance to accurately pinpoint SQL code that is causing a slow down.
MySQL University is a no cost online training program for Sun Engineers, MySQL Community Contributors and anyone who's interested in MySQL development and internals. Sessions are scheduled on Thursdays and usually last for an hour. Upcoming topics include:
- Testing Multiple Servers With MySQL Sandbox (April 30)
- MySQL Replication: Walk-through of the new 5.1 and 6.0 features (May 7)
- Boosting Performance With MySQL 5.1 Partitioning (June 4)
MySQL Community Server 5.1.34, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.34 is recommended for use on production systems.
MySQL Enterprise Monitor 18.104.22.16853 has been released. This is a maintenance release of the Enterprise Monitor that fixes a number of bugs. Fixes include:
- Calling the Agent with the option --agent-run-os-tests resulted in a crash. This happened on Linux x86-64 systems. (Bug #43381)
- Following a change in the replication configuration, MySQL Enterprise Monitor did not display the new topology correctly. (Bug #43240)
- MySQL Enterprise Monitor did not add a log entry each time data was purged. The log entry should have noted how many rows of each type of data were purged. (Bug #43159)
Sign-up for MySQL Enterprise 30-day Trial » (http://www.mysql.com/trials/)
The first GA (general availability) version of MySQL Connector/C++ has been made available: MySQL Connector/C++ 1.0.5 GA. The MySQL Connector/C++ provides a C++ API for connecting client applications to the MySQL Server 5.1 or newer. We have improved the driver and added a couple of new features since the last beta release. Please see the documentation and the CHANGES file in the source distribution for a detailed description of bugs that have been fixed.
MySQL Connector/C 6.0.1, a new version of the C API for accessing MySQL database servers, is now available. This is the first generally available (production) release of the new packaging for this standalone distribution of code that used to only be distributed along with the server.
MySQL Connector/Net 6.0.2, a new version of the all-managed .NET driver for MySQL has been released. This is a beta release and is intended to introduce you to the new features and enhancements we are planning. This release was quickly pushed out due to a problem that caused 6.0.1 to not register with Visual Studio correctly.
We are proud to announce the release of the second official Beta of MySQL Workbench 5.1, the next highly anticipated version of our database GUI tool - MySQL Workbench. This release is available for all major platforms: Mac OS X, Linux and Windows.
A new version the MySQL Connector/OpenOffice.org has been made available: MySQL Connector/OpenOffice.org 1.0.2 alpha (Alpha 2). The driver can be used to connect from OpenOffice.org 3.1 to MySQL 5.1 or newer. The MySQL Connector/OpenOffice.org is implemented as an easy to install OpenOffice.org extension.
DTrace is a dynamic tracing facility built into the Solaris and Open Solaris operating systems and can be used by system administrators and developers alike to observe the runtime behavior of user level programs and of the operating system itself. On one hand, DTrace can be used to identify potential bottlenecks in the running processes on a production system, and on the other, DTrace can help you understand the runtime behavior of an external program such as MySQL better.
Query optimization is the often overlooked part of applications. Development schedules being what they are, getting the right results and getting the application working are the main priorities. So thoroughly testing, and benchmarking queries is often left as an afterthought.
This tutorial will show you the essential steps to install and configure the Connector/J JDBC driver, with simple examples to connect to a MySQL database. Because the focus is on the database driver and the database connectivity from the Java programming language, this document assumes that some kind of MySQL database is already up and accessible from the client machine.
Benoit Chaffanjon and Nick Kloski
In the past, databases ran entire workloads on a single server. Everything that needed to get done could be accomplished on one system. Times changed, and the need for scalability drove software development toward multi-server scaling. Now, being open to change can have a dramatic impact on the datacenter.
This paper describes the benefit of deploying the master and slave database of MySQL Replication using Zone Clusters. In addition, it provides details on how to deploy the master and slave databases in two different Zone Clusters, using non-global zones from two different machines as the virtual cluster nodes.
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.
Today Sun Microsystems announced MySQL 5.4, a release that focuses on performance and scalability. For a long time it's been possible to escape the confines of a single system with MySQL, thanks to scale-out technologies like replication and sharding. But it ought to be possible to scale-up efficiently as well - to fully utilize the CPU resource on a server with a single instance.
As a final followup to my MySQL 5.4 Scalability on 64-way CMT Servers blog, I'm posting MySQL 5.4 Sysbench results on a Sun Fire X4270 platform using the Intel x86 Nehalem chip (2 sockets/8 cores/16 threads).
As Colin revealed last week, Google has accepted MySQL for the Google Summer of Code 2009. We've already participated in GSoC 2007 and 2008, so this is our third year running. We know more than before about what's waiting for us, and so does our mentors and perhaps even some of our students.
There are two LDAP Directory Servers available that supports MySQL Cluster - OpenLDAP (supported and maintained by Symas Corp.) and OpenDS (Sun Microsystems). Both of them have implemented a back-end called back-ndb that talks direclty to the data nodes. This means that they use the NDBAPI directly to access data in the cluster, thus bypassing the MySQL Server.
I just can't help thinking about how amazing and useful MySQL Sandbox is. There are so many things that it can do, and so many problems that it solves for Database Developers. When it comes down to it, I really think that every project that uses MySQL can benefit in some way or another just by using MySQL Sandbox.
I have been benchmarking Waffle Grid using the new InnoDB Plugin 1.03 in the past couple of days. Let me say the plugin is fast. Which got me thinking, generally when you fix a bottleneck another area becomes a bottleneck ... it's a vicious cycle really. I figured why not benchmarks several different settings just to see what sort of improvement or detriment we get in InnoDB.
With MySQL Cluster it is possible to aggregate data from many MySQL Servers using Replication. Here is how. E.g, you might have a sensor network, where each sensor writes data into a mysql server. The problem is that you have a quite few of these sensors, and you want to aggregate this data, e.g. in order to do data mining on the combined data set.
The MySQL DBA 5.1 Certification Exam is a big change from previous exams. 1. No multiple choice, true/false questions. 2. Must be able to use MySQL. 3. You are given the answers (in most cases) and must change the database to meet expectations. 4. No study guide.
Event: The MySQL "Lower-Your-COGS Workshop for ISVs and OEMs" is coming to New York City (May 7, 2009)
Today's economic pressures are causing growing interest in MySQL from ISV and OEM Product Teams as they look to lower their cost of goods sold (COGS) and confront the now common question of: "How can we provide feature-rich solutions at a lower cost and increase our margins?" (or, "How can we do more with less?")
The MySQL Embedded Server provides answers to this question by "Eliminating the Database Tax", which is the theme of our two-part, half-day workshop. Register soon to reserve you space!
Register Now » (http://www.mysql.com/news-and-events/cogs_workshop/register.html)
View the Location and Session Details » (http://www.mysql.com/why-mysql/isv-oem-corner/cogs_workshop.html)
This tutorial will show you the essential steps to build and install MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database.
Before you proceed with the installation from source, check the Connector/C++ downloads page to see whether the driver is available in binary form for your build platform, and whether it works for you. In general, all the pre-compiled binaries are built with the best possible options for all the supported platforms.
As you might know by now, libmysqld, the deeply embedded version of MySQL, has reappeared in MySQL 5.1, having been gone in version 5.0. If you are curious about libmysqld in general, then feel free to pop by this free live webinar, hosted by no one else but yours truly.
A few days ago, I have published a tutorial on building a Connector/C++ client application on Windows using Visual Studio. Its time for a Linux How-To.
In this white paper, we explore the challenges and risks faced by technology providers (including Independent System Vendors (ISV), Original Equipment Manufacturers (OEM), and Value-Added Resellers (VAR)) when bringing a new product to market. Embedding a proven, market-leading database such as MySQL can go a long way toward building a solid technology foundation while concurrently helping to mitigate risk.
Read the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_reducing-isv-risk.php)
The MySQL 5.1 server continues to move MySQL and Sun ahead in its mission to make sophisticated database management available and affordable to all. MySQL 5.1 is particularly appealing to ISV (Independent Software Vendors) and OEM (Original Equipment Manufacturers) solution providers who need to embed a database within the application that they either sell in traditional manner or use in a software-as-a-service fashion.
Read the White Paper » (http://www.mysql.com/why-mysql/white-papers/mysql_wp_51_OEM.php)
Adobe Systems is one of the largest software companies and is the leading provider of creative tools for print, web, interactive, mobile, video, and film. Adobe embeds MySQL into several Adobe Creative Suite 3 components including Adobe Acrobat CS3, Adobe Bridge CS3, and Adobe Version CueR CS3 so that workgroups can work more efficiently on complex projects.
Read the Case Study » (http://www.mysql.com/why-mysql/case-studies/adobe-mysql-make-more-productive/)
Case Study: Tema Networks Selects MySQL Embedded Server to Power its Real Time Mobile Billing Solution
Tema Networks develops billing and Value Added Services (VAS) solutions for mobile network operators around the world. Based in Finland, Tema Network's management team are seasoned professionals with a combined experience of over 40 years, holding senior level positions within leading suppliers to the Communications industry.
Read the Case Study » (http://www.mysql.com/why-mysql/case-studies/tema-real-time-mobile-billing-solution-mysql/)
Live Webinar: For Commercial ISVs and OEMs: Securely and Seamlessly Deploy MySQL with Your Application
Tuesday, May 12, 2009 - 10:00am PDT
MySQL security best practices often assume restricted access to the physical server and restrictive file system privileges. However, OEM's and ISV's who bundle and distribute MySQL with their applications have no control over where the application is installed. In fact, the application is often deployed on workstations with unrestricted access to the underlying data files.
Wednesday, May 20, 2009 - 10:00am PDT
MySQL Connector/C++ is the latest Connector for MySQL. It takes different approach compared to existing C++ drivers by following the JDBC specification in a way that makes sense in C++ world. In this webinar you'll learn the reasoning behind Connector/C++'s development, what's included in Connector/C++, what's planned for Connector/C++ and how you can use it to ease your C++ development.
Tuesday, April 28, 2009 - 10:00am PDT / 17:00 UTC
Join this webinar to learn about the proactive and consultative tools and support included in a MySQL Enterprise subscription that can help the most demanding Enterprises and Web properties mitigate risk, minimize downtime, and maintain SLAs.
Wednesday, April 29, 2009 - 4:00pm PDT
Join us for this informative technical webinar presented by Toru Maesaka, Software Engineer at mixi.jp, the most popular social networking site in Japan. In this webinar Toru will explain the basic concepts of how memcached works, how it can be leveraged to increase the scalability of online applications, plus what's new in the 1.3 release.
Thursday, April 30, 2009 - 11:00 Australia EST / 13:00 NZST
Virtualizing and scaling MySQL can provide substantial benefits when properly implemented. This session covers:
- MySQL Virtualization Options, Considerations, Recommendations
- Considerations for Scaling MySQL
- Test Results, Financial and Eco Impact
Join this web seminar to learn more about these features and how you can put them to use.
Thursday, April 30, 2009 - 10:00am PDT / 17:00 UTC
By attending this webinar, you will learn more about the next generation of MySQL Cluster, and how it enables you to deliver 99.999% database availability, with real time performance and linear scalability, while slashing TCO.
Tuesday, May 05, 2009 - 10:00am PDT / 17:00 UTC
Join us for this informative technical webinar presented by Trond Norbye, Sr. Software Engineer at Sun Microsystems. In this webinar Trond will explain the basic concepts of how memcached works and how it can be leveraged to increase the scalability of online applications.
Thursday, May 07, 2009 - 10:00am PDT / 17:00 UTC
Join us for this informative technical webinar presented by Jeremy Zawodny of Craigslist.org. In this webinar Jeremy will look at the recent evolution of database and search architecture at Craigslist, including performance, caching, partitioning, and other tweaks.
Tuesday, May 12, 2009 - 1:00pm PDT
Speed up application performance, simplify your datacenter and see cost and energy savings with Sun's Open Network System for MySQL - integrating and optimizing compute technologies and featuring the Intel Xeon processor 5500 series with new flash-ready options.
Wednesday, May 13, 2009 - 10:00am PDT
The biggest asset Communications Service Providers (CSPs) have to compete and grow in the market is their data - specifically customer data. This data is much more than just traditional customer billing details. Tune into this live webinar from Infobright and MySQL to learn how open source data warehousing enables Communications Service Providers to gain greater subscriber insight, with lower cost and risk than ever before.
Wednesday, May 13, 2009 - 15:00 CET / 16:00 EET
Netlog, one of the fastest-growing Web communities in Europe, need to ensure its database infrastructure will scale to handle its traffic increase of 300% last year. The company has 40 million registered members generating more than 6 billion page views every month. If you're interested in high performance, scalability, MySQL, php, caching, partitioning, Sphinx, federation or Netlog - join this webinar!
More MySQL webinars are scheduled and added between each Newsletter edition, so visit our website for the most updated information.
Orlando, Paris, Bangalore, Mexico City
An Authorized MySQL instructor will teach you how to properly install MySQL, create and execute Backup Strategies, create secure Stored Procedures to update and access data and more!
This instructor led, hands-on class will teach you how to secure users privileges, set resource limitations, and access controls. In addition, you will learn multiple new features such as creating and using Stored Procedures, Triggers and Views.
Register Now for an Upcoming Date » (http://www.mysql.com/training/workshops/mysql_dba.html)
MySQL now offers performance-based testing for real-world skills. The new performance-based certification exam is currently offered in the MySQL DBA training class at no additional charge. Experts rate lab-based exams as highly relevant because these exams allow candidates to test their IT skills in a live environment. Separate yourself from others in this economy by getting MySQL Certified.
Learn More » (http://www.mysql.com/certification/performance_based.html)
Sun's MySQL consultants have the experience and knowledge to help accelerate your Data Warehouse project and guide you through the crucial startup phase of creating a Data Warehouse. Getting the initial phase of a Data Warehouse project right helps to reduce the risk of schedule overruns.
Learn More » (http://www.mysql.com/consulting/packaged/datawarehouse.html)
Certifying your technology to work with MySQL Enterprise has benefits to both your company and your customers. Certification enables you to provide your customers with the confidence that they are deploying a production-ready, enterprise-grade solution.
Learn More » (https://partner-portal.mysql.com/guide/technology_certification.html)