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: 




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

Fortinet Expands Database Vulnerability Assessment with Support for Sun Microsystems’ MySQL Enterprise


View the press release here:

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: 

Monday May 04, 2009

MySQL 5.4 Benchmark Info Webinar

MySQL 5.4 Benchmarks In-Depth

Thursday, May 21, 2009

Join us for this informative technical webinar presented by performance expert, Allan Packer, Principal Engineer at Sun Microsystems. In this webinar Allan will give an overview of the scalability and performance improvements of MySQL 5.4. This version can yield up to 90% faster response times, and scalability up to 16-way x86 servers and 64-way CMT servers. Allan will also explore in depth, several benchmarks concerning MySQL 5.4, including Sysbench results on CMT and Nehalem systems plus an OLTP workload derived from an industry-standard benchmark. If you are interested learning about the performance improvements in MySQL 5.4 and related benchmarks, this webinar is for you!

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: 

Wednesday Apr 22, 2009

Pricing Details for x2270 SPECjApp Server Solution

Pricing details for the x2270 SPECjApp Server Solution on this blog at:

Solution with Support: 

Solution without Support:

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

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.

MySQL Cluster 7.0 Released -- Great Performance over 6.3

Today, at the MySQL User's Conference, MySQL Cluster 7.0 was released.  MySQL Cluster 7.0 new features include:

  • Enhanced scalability - delivers over 4x higher database performance with fewer nodes to simplify deployment and administration.  
  • Expanded platform support and interoperability - delivers more choice in both the development and deployment of MySQL Cluster.
  • Flexible online backup - snapshots reduce DBA administration overhead and operational costs.

 Our groups assisted with the performance benchmarks for the release.   Check out Hasham's blog here for the full details.  Highlights of the results are:

  • For 4 Node Cluster, we achieved 251,000 Transactions per minute which is more than 4X improvement over the MySQL Cluster 6.3 release.
  • For 2 Node Cluster, we achieved 143,000 Transactions per minute which is more than  4X improvement over the MySQL Cluster 6.3 release.
  • Whether a user is looking to take advantage of the latest multi-core, multi-thread server processors, or is seeking to reduce space and energy consumption of their Cluster hardware, MySQL Cluster 7.0 provides a higher throughput, more efficient solution than previous generations of the MySQL Cluster database.

Jennifer Glore


« July 2016