Tuesday Jul 21, 2009

Introducing the MySQL Librarian

Recently, the MySQL Community Team has introduced the MySQL Librarian.  In short, the MySQL Librarian is a collection of community-generated and cross referenced content related to MySQL.  It is a place where the community can collaboratively build and maintain MySQL content.  Guiseppe Maxia provides a good introduction to the MySQL Librarian at:


Visit the MySQL Librarian at:


Friday Jul 17, 2009

New MySQL Release Model

MySQL has adopted a new release model -- Milestone Releases.  In short, the goals of the new model for the MySQL Server are these:
  1. Deliver more frequent releases of the server with better predictability in terms of a release date
  2. Make new features and enhancements more quickly available
  3. Provide a model that encourages and rewards community contributions to the MySQL Server

Check out this article by Robin Schumacher, MySQL's Director of Product Management, to get more information


Thursday Jul 02, 2009

Getting the Most Out of the New MySQL Connector/C++ Webinar

MySQL Connector/C++ is the latest connector for MySQL. This connector, which uses much the JDBC API patterns, was made available as a GA release in April of this year.  
In this Webinar, Giri Mandalika, Sun Microsystems Engineer and MySQL Connector/C++ expert, will show you how to use the new connector for maximum benefit. You will learn: 

- What Connector/C++ is and how to install it
- About the classes implemented by Connector/C+
- Connector/C++ driver's support for database transactions
- How to use the debug tracing capabilities of Connector/C++
- What is planned for Connector/C++ along with the roadmap to the future release(s)

 The webinar is scheduled for Thursday, July 09, 2009, 10:00 am PDT, 1:00 pm EDT, 6:00 pm GMT+1.  Register at:  http://mysql.com/quicklinks/webinars/connector-cpp.html 




Wednesday Jun 24, 2009

Sun Business Intelligence Solution for Web Infrastructure

Today, Sun has announced the Sun Business Intelligence Solution for Web Infrastructure.  This solution combines Sun Open Network Systems with the commercial open source Infobright data warehousing software (built on MySQL) and Pentaho business intelligence and data integration software packages.  It's a modular, scalable, open-analytics infrastructure designed to help you make better business decisions that drive deeper customer engagements and higher revenues.  Get more information at http://www.sun.com/systems/solutions/mysql/web-bi.jsp.

Thursday Jun 11, 2009

New MySQL Blueprint: Open Network Systems for Internet Infrastructure, MySQL Edition


Recently, a new MySQL blueprint was published at: 


Sun's new reference architecture, the Open Network Systems for Internet Infrastructure, MySQL Edition, combines Sun Open Storage, high-performance networking and servers, open source software, and Sun services into an integrated enterprise portal solution that delivers scalability and performance for Web and enterprise environments seeking to streamline business processes through rich social media, collaborative Web technologies. This solution features Sun's Open Network Systems, next-generation Flash technology storage products, Sun's MySQL Enterprise Server, the Sun GlassFish™ Portfolio, the ZFS™ file system, and a choice of OpenSolaris™, Solaris™, or Linux operating systems. This paper describes the hardware and software components of the reference architecture, studies the scalability of the architecture, and includes step-by-step directions for setup and configuration.e software components. 

Tuesday Jun 09, 2009

Webinar: Architectural Deep Dive on MySQL Cluster

Live Webinar: MySQL Cluster - Architectural Deep Dive, June 17th 2009

MySQL recently released the next generation of its industry-leading MySQL Cluster high availability database.

Tune into this webinar where you can hear from the Director of MySQL Server Engineering provide a detailed "deep dive" into the architecture of MySQL Cluster. In this session, you will learn:
\* how MySQL Cluster achieves predictable and consistent real time performance
\* how MySQL Cluster achieves continuous availability with sub-second fail-over, automated recovery and geographic replication
\* how MySQL Cluster enables users to dynamically scale throughput and data capacity
\* how to get started with MySQL Cluster

Click below to register:

Wednesday, June 17, 2009: 09:30 Pacific time (America)
Wed, Jun 17:     12:30 Eastern time (America)
Wed, Jun 17:     16:30 UTC
Wed, Jun 17:     17:30 Western European time
Wed, Jun 17:     18:30 Central European time
Wed, Jun 17:     19:30 Eastern European time

   \* Tomas Ulin, Director, MySQL Server Technologies
   \* Matthew Keep, MySQL Cluster Product Management

The presentation will be approximately 45 minutes long followed by Q&A.

Simply access the web seminar from the comfort of your own office.

Click below to register:

Thursday May 28, 2009

MySQL and Kickfire Webinar on Thursday, June 4th

Thursday, June 4th, MySQL and Kickfire will be holding a webinar to show how end users can achieve faster and more scalable MySQL reporting and analytics with Kickfire.  The webinar will cover:

  • Survey data from MySQL users on what they view as their top analytics requirements
  • An overview of the different options available to MySQL users looking to do reporting and analytics
  • An in-depth review of the Kickfire technology
  • Industry and customer performance benchmark results of the Kickfire solution

Register for this web presentation �  

Using ZFS Snapshots With Zmanda Recovery Manager for MySQL on OpenSolaris

Recently, one of the engineers in ISV Engineering worked with Zmanda to create an article on how to use ZFS snapshots with Zmanda Recovery Manager for MySQL on OpenSolaris.  The article details how to deploy ZRM for MySQL on OpenSolaris and details the performance of ZRM on a Sun Fire x4500 using ZFS.  Check out the article here.

Wednesday May 27, 2009

Best Practices for MySQL, Innodb, and ZFS


If you are using MySQL with Innodb and you also use ZFS, then you should check out Neel's latest blog entry.  He gives some best practice advice. 


Wednesday May 20, 2009

Scaling Memcached: 500,000+ Operations/Second with a Single-Socket UltraSPARC T2

Recently, there was a great scalability milestone for the memcached community.  A single-socket T2 server (released over 1.5 years ago) shows World Record numbers with memcached that is traditionally deployed on dual-socket AMD/Intel servers.  Full details can be found at:  


Additionally, memcached results on Nehalem systems can be found here:



Friday May 01, 2009

MySQL 5.4 Performance Details

Hopefully, at this point, you have heard about the new MySQL release, MySQL 5.4, which focuses on performance improvements (mainly for Innodb).  Details on benchmarks that were run for this release can be found at Allan Packer's blog here.  He talks about Sysbench performance on Nehalem with 5.4 (Linux and Solaris) as well as scalability of sysbench on 64-way CMT systems.  

Blueprint: Deploying Web 2.0 Applications on Sun Servers and OpenSolaris with MySQL

There is a new blueprint solution available that shows Web 2.0 application deployment on Sun servers and the OpenSolaris operating system using MySQL. It shows how to scale a medium sized Web 2.0 site with a million registered users with open source technologies, and includes detailed configuration and tuning information for the deployment, along with tips for obtaining the best performance from such a configuration. The solution uses Olio—a Web 2.0 toolkit that Sun has invested in—to help customers analyze and scale deployments. Olio allows users to performance test new technologies in a stable environment without having to devise expensive, cumbersome tests on production applications.  You can get the blueprint by going to:


Tuesday Apr 21, 2009

MySQL 5.4: Greater Performance and Scalability

Today, at the MySQL Users Conference, Sun announced the release of MySQL 5.4.  MySQL 5.4 is the result of many months of work by Sun / MySQL engineers.  It delivers significant performance and scalability improvements to MySQL applications. A preview version of MySQL 5.4 is available now for download at http://www.mysql.com/5.4.

MySQL 5.4 Features & Benefits

A number of new enterprise features and compelling fixes are planned for MySQL 5.4, including:

  • Scalability improvements -- these fixes allow the InnoDB storage engine to scale up to 16-way x86 servers and 64-way CMT servers, more than doubling its previous capability;
  • Subquery optimizations -- improves the performance of analytic query operations, with some subqueries now executing in a fraction of the time compared to previous MySQL versions;
  • New query algorithms -- utilizes main memory to speed up the execution time of multi-way joins, especially for MySQL Cluster because the number of round-trips between the server and cluster nodes is minimized;
  • Improved stored procedures -- enables more robust error management through the implementation of the SIGNAL/RESIGNAL functions, so applications can more easily rely on stored procedures for business logic;
  • Improved prepared statements -- Output parameters will now be supported in prepared statements, which increases their functionality;
  • Improved Information Schema -- provides more metadata access to parameters and data return types that stored procedures use, which allows much more information to be made available for developers using connectors such as ODBC and JDBC;
  • Improved DTrace support -- improves diagnostics and troubleshooting capabilities for MySQL on the Solaris(TM) Operating System.

 Stay tuned for formal benchmarks on MySQL 5.4.

Monday Apr 20, 2009

Sun makes great strides with GlassFish and MySQL on SPECjAppServer2004 -- 2925.18 JOPS

Today, we released some new results for SPECjAppServer2004 that demonstrate Sun's leadership in price / performance.  Full details of the report can be found here.  The results we published achieved 2925.18 SPECjAppServer2004 JOPS@Standard using an all open source stack from Sun -- Glassfish , MySQL and OpenSolaris (with ZFS), on the new Sun / Intel Nehalem based servers.

Back in November 2008, we released a SPECjAppServer 2004 number of 1197.50 SPECjAppServer2004JOPS@Standard.This latest result, of 2925.18 SPECjAppServer2004 JOPS@Standard, is more than double that previous best.  In addition to pure performance improvements, this new results, which has a total cost of acquisition (HW + SW without support) of $38,880.00 (look here to see the full bill of materials) also has a lower price/performance than the previous result.    If you look at dollar / JOPS@Standard, the new result comes in at $13.29, while the result from November was $13.46 / JOPS@Standard.  If you include support, which factors in software costs, the dollar / JOPS@Standard is $26.95 (the full bill of materials can be found here).  In all aspects, Sun / MySQL are making strides to improve both price and performance of their stack.

Stay tuned as we will continue to demonstrate more leaps in this area.

 If you would like more specific details about this particular result, please check out Kevin and Tom's blogs.

Wednesday Apr 15, 2009

Sun and C-SAM Offer Mobile Banking Solution on MySQL and GlassFish

Recently, Sun Microsystems and C-SAM announced a mobile banking solution built on MySQL and GlassFish. Details can be found here: 



Jennifer Glore


« August 2016