h4. [Improving MySQL Database Scalability !Main^download.gif!|http://mapping.sun.com/profile/offer.jsp?id=214]
*by Benoit Chaffanjon and Nick Kloski{*}{excerpt}
February 2009{excerpt}
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 multiserver scaling. Now, being open to change can have a dramatic impact on the datacenter. MySQL™ databases can be scaled using the same techniques — on an optimized platform that provides massive scaling, lower administrative costs, and datacenter space and energy efficiency. This Sun BluePrints™ article explains how MySQL databases can be configured to take advantage of the chip multithreading (CMT) capabilities of Sun SPARC Enterprise™ T5440 servers and features in the Solaris™ Operating System (Solaris OS) to scale performance through a discussion of benchmarks and results.
h4. Contents
* The impact of database performance
** Changing paradigms for intra-server scale-out through chip multithreading technology
** Combining CMT server and database technology to scale
* Scalable workload testing for MySQL database deployments
** Test components
*** Sun SPARC Enterprise T5440 server
*** ZFS file system
*** MySQL database server 5.1
*** SLAMD Distributed Load Generation Engine
*** IgenOLTP benchmark
*** Java Platform, Standard Edition 7
** Test configuration
** Test methodology
*** Determine peak throughput
*** Scale horizontally
*** Optimize thread scheduling
*** Use a shared-nothing architecture
* Summary
* About the author
* References
* Ordering Sun Documents
* Accessing Sun Documentation Online
* Appendix A. Shell Script to Start Multiple MySQL Database Instances
* Appendix B. Output from the df -k Command
* Appendix C. MySQL Database Configuration File
* Appendix D. Statistics Shell Script
{panel:title=About the Authors|borderStyle=solid|titleBGColor=#F8D583|bgColor=white}
Nick Kloski is a Web2.0 Solutions Architect in the Web/HPC group in the Systems Technical Marketing Group at Sun. In his 10 years at Sun, Nick has had a wide exposure to both Sun and competitive systems, including systems administration work, over six years of technical Field Service, internal QA testing, and as a member of the Technical Marketing Department. In the role of Web2.0 Solutions Architect, Nick is responsible for being aware of market trends and discovering ways Sun technology can help uniquely solve customer problems.
{panel}
{vote:Rate this blueprint}
Great
Good
Fair
Poor
{vote}
*by Benoit Chaffanjon and Nick Kloski{*}{excerpt}
February 2009{excerpt}
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 multiserver scaling. Now, being open to change can have a dramatic impact on the datacenter. MySQL™ databases can be scaled using the same techniques — on an optimized platform that provides massive scaling, lower administrative costs, and datacenter space and energy efficiency. This Sun BluePrints™ article explains how MySQL databases can be configured to take advantage of the chip multithreading (CMT) capabilities of Sun SPARC Enterprise™ T5440 servers and features in the Solaris™ Operating System (Solaris OS) to scale performance through a discussion of benchmarks and results.
h4. Contents
* The impact of database performance
** Changing paradigms for intra-server scale-out through chip multithreading technology
** Combining CMT server and database technology to scale
* Scalable workload testing for MySQL database deployments
** Test components
*** Sun SPARC Enterprise T5440 server
*** ZFS file system
*** MySQL database server 5.1
*** SLAMD Distributed Load Generation Engine
*** IgenOLTP benchmark
*** Java Platform, Standard Edition 7
** Test configuration
** Test methodology
*** Determine peak throughput
*** Scale horizontally
*** Optimize thread scheduling
*** Use a shared-nothing architecture
* Summary
* About the author
* References
* Ordering Sun Documents
* Accessing Sun Documentation Online
* Appendix A. Shell Script to Start Multiple MySQL Database Instances
* Appendix B. Output from the df -k Command
* Appendix C. MySQL Database Configuration File
* Appendix D. Statistics Shell Script
{panel:title=About the Authors|borderStyle=solid|titleBGColor=#F8D583|bgColor=white}
Nick Kloski is a Web2.0 Solutions Architect in the Web/HPC group in the Systems Technical Marketing Group at Sun. In his 10 years at Sun, Nick has had a wide exposure to both Sun and competitive systems, including systems administration work, over six years of technical Field Service, internal QA testing, and as a member of the Technical Marketing Department. In the role of Web2.0 Solutions Architect, Nick is responsible for being aware of market trends and discovering ways Sun technology can help uniquely solve customer problems.
{panel}
{vote:Rate this blueprint}
Great
Good
Fair
Poor
{vote}