How to Improve MySQL™ Database Scalability

Mar 25, 2009

60 Minutes

Event Details

Benoit Chaffanjon - Principal Engineer - Sun Microsystems

Michael Krieger - Market Expert - Ziff Davis Enterprise

Nick Kloski - Web2.0 Solutions Architect, Web/HPC Group, Systems Technical Marketing Group - Sun
At the beginning of database design, databases ran entire workloads on a single server. However, times changed and the need for scalability drove software development toward multiserver scaling. Database administrators can now scale MySQL™ databases using the same techniques — on an optimized platform that provides massive scaling, lower administrative costs, and datacenter space and energy efficiency.

Database scalability and performance are essential to the success of many enterprise environments. While many companies prefer to scale solutions vertically, scaling within the system is difficult — if not impossible — on processors that are not optimized for throughput applications. As work continues on in-processor vertical scalability, the MySQL database community has scaled horizontally to gain increasing levels of database throughput to achieve optimum results.

As an attendee at this technical eSeminar, you will learn how to:
- Configure, optimize and massively scale MySQL databases;
- Implement tips and tricks from the MySQL database community;
- Take advantage of chip multithreading and the Solaris OS;
- Analyze the testing and benchmarks that support the solution;
- Lower administrative costs, improve datacenter space and energy efficiency;
Sun's senior engineers will describe the testing that demonstrates single server MySQL database scalability utilizing a combination of intelligent database design, and multithreaded hardware design. Horizontal scaling using the ZFS™ filesystem, MySQL database sharding techniques, and chip multithreading (CMT) technologies allow for intraserver scaling. In the past, many physical servers were needed to achieve similar throughput results. The techniques used are well known throughout the MySQL database community. The small footprint, and power-efficient scaling methods used are key to understanding the value of intra-system MySQL database design.
Sun Microsystems