h4. [Running MySQL Database in Solaris Containers !Main^download.gif!|http://mapping.sun.com/profile/offer.jsp?id=200]
*by Ritu Kamboj and Giri Mandalika{*}{excerpt}
February 2009{excerpt}
Today business is increasingly done on the Web, and thousands of new people, applications, businesses, and services are coming online daily. In fact, Wiki pages, mashups, social networking sites, and online stores are at the forefront of Web 2.0 technologies. As more businesses, services, and sites go online and gain in popularity, enterprises must deal with the massive increases in data, as well as collected community knowledge and shared information.
When information is readily available and secure, it can help make the organization smarter and more effective at solving business challenges. As a result, efficient and flexible environments that can scale and adapt, deploy new services quickly, and keep valuable information safe are paramount. To support this effort, Web 2.0 companies need easy access to an open, integrated platform that can help developers build and deploy high-performance, reliable Web services and applications fast. By using a complete SAMP (Solaris™ Operating System, Apache HTTP Server, MySQL™ database, PHP) application stack, open source database, and high-performance servers and storage systems, organizations are better positioned to create environments that are capable of supporting rapidly evolving, high traffic, high scale Web sites.
Part of a series, this Sun BluePrints™ article describes the process of deploying the MySQL database in virtualized environments using Solaris Zones partitioning technology.
h4. Contents
* Introduction
* Technology Overview
* MySQL™ database server
** MySQL server in virtual environments
* Solaris™ Operating System
* Solaris Containers
** Solaris Zones Software
** Solaris Resource Manager software
* Installing MySQL Software in a Solaris Container
* Solaris Containers requirements
* Creating a non-global zone
** Configure, install, and boot the non-global zone
* Installing and configuring the MySQL software
** Prepare for installation
** Install the MySQL software
* Special Considerations and Best Practices
* Double buffering
* MySQL server and the ZFS™ file system
** ZFS and Tablespaces
** ZFS I/O scheduler
** ZFS recommendations for MySQL server
* Prioritize access to CPU resources with the Fair Share Scheduler
* Devices in Solaris Containers
* InnoDB thread concurrency
* Libumem for MySQL Server
* Mitigate mutex contention in MyISAM with mmap(2)
* Increase the file system cache for MyISAM
* Fixing errors about too many open files
* Enable large pages
* Solaris Dynamic Tracing probes in MySQL server
* For more information
* About the authors
* Acknowledgments
* References
* Ordering Sun documents
* Accessing Sun documentation online
{panel:title=About the Authors|borderStyle=solid|titleBGColor=#F8D583|bgColor=white}
Ritu Kamboj is a Staff Engineer in ISV Engineering's Open Source Team at Sun Microsystems. She has over 12 years of experience in software development with expertise on database design, performance, and high availability. Ritu has worked extensively on Sybase, Oracle, and MySQL databases. Recently her primary focus has been making MySQL software run best on the Solaris platform.
Giri Mandalika is a software engineer in Sun's ISV Engineering organization. Giri works with partners and ISVs to make Sun the preferred vendor of choice for deploying enterprise applications. Currently, Giri is focused on standard benchmarks, optimization, and scalability of enterprise applications on Sun platforms.
{panel}
{panel:title=Acknowledgments|borderStyle=solid|titleBGColor=#F8D583|bgColor=white}
The authors would like to recognize John David Duncan and Prashant Srinivasan for their contributions to this article.
{panel}
{vote:Rate this blueprint}
Great
Good
Fair
Poor
{vote}
*by Ritu Kamboj and Giri Mandalika{*}{excerpt}
February 2009{excerpt}
Today business is increasingly done on the Web, and thousands of new people, applications, businesses, and services are coming online daily. In fact, Wiki pages, mashups, social networking sites, and online stores are at the forefront of Web 2.0 technologies. As more businesses, services, and sites go online and gain in popularity, enterprises must deal with the massive increases in data, as well as collected community knowledge and shared information.
When information is readily available and secure, it can help make the organization smarter and more effective at solving business challenges. As a result, efficient and flexible environments that can scale and adapt, deploy new services quickly, and keep valuable information safe are paramount. To support this effort, Web 2.0 companies need easy access to an open, integrated platform that can help developers build and deploy high-performance, reliable Web services and applications fast. By using a complete SAMP (Solaris™ Operating System, Apache HTTP Server, MySQL™ database, PHP) application stack, open source database, and high-performance servers and storage systems, organizations are better positioned to create environments that are capable of supporting rapidly evolving, high traffic, high scale Web sites.
Part of a series, this Sun BluePrints™ article describes the process of deploying the MySQL database in virtualized environments using Solaris Zones partitioning technology.
h4. Contents
* Introduction
* Technology Overview
* MySQL™ database server
** MySQL server in virtual environments
* Solaris™ Operating System
* Solaris Containers
** Solaris Zones Software
** Solaris Resource Manager software
* Installing MySQL Software in a Solaris Container
* Solaris Containers requirements
* Creating a non-global zone
** Configure, install, and boot the non-global zone
* Installing and configuring the MySQL software
** Prepare for installation
** Install the MySQL software
* Special Considerations and Best Practices
* Double buffering
* MySQL server and the ZFS™ file system
** ZFS and Tablespaces
** ZFS I/O scheduler
** ZFS recommendations for MySQL server
* Prioritize access to CPU resources with the Fair Share Scheduler
* Devices in Solaris Containers
* InnoDB thread concurrency
* Libumem for MySQL Server
* Mitigate mutex contention in MyISAM with mmap(2)
* Increase the file system cache for MyISAM
* Fixing errors about too many open files
* Enable large pages
* Solaris Dynamic Tracing probes in MySQL server
* For more information
* About the authors
* Acknowledgments
* References
* Ordering Sun documents
* Accessing Sun documentation online
{panel:title=About the Authors|borderStyle=solid|titleBGColor=#F8D583|bgColor=white}
Ritu Kamboj is a Staff Engineer in ISV Engineering's Open Source Team at Sun Microsystems. She has over 12 years of experience in software development with expertise on database design, performance, and high availability. Ritu has worked extensively on Sybase, Oracle, and MySQL databases. Recently her primary focus has been making MySQL software run best on the Solaris platform.
Giri Mandalika is a software engineer in Sun's ISV Engineering organization. Giri works with partners and ISVs to make Sun the preferred vendor of choice for deploying enterprise applications. Currently, Giri is focused on standard benchmarks, optimization, and scalability of enterprise applications on Sun platforms.
{panel}
{panel:title=Acknowledgments|borderStyle=solid|titleBGColor=#F8D583|bgColor=white}
The authors would like to recognize John David Duncan and Prashant Srinivasan for their contributions to this article.
{panel}
{vote:Rate this blueprint}
Great
Good
Fair
Poor
{vote}