Sun Blueprint : MySQL in Solaris Containers
By Giri Mandalika on Feb 18, 2009
While the costs of managing a data center are becoming a major concern with the increased number of under-utilized servers, customers are actively looking for solutions to consolidate their workloads to:
- improve server utilization
- improve data center space utilization
- reduce power and cooling requirements
- lower capital and operating expenditures
- reduce carbon footprint, ..
To cater those customers, Sun offers several virtualization technologies such as Logical Domains, Solaris Containers, xVM at free of cost for SPARC and x86/x64 platforms.
In order to help our customers who are planning for the consolidation of their MySQL databases on systems running Solaris 10, we put together a document with a bunch of installation steps and the best practices to run MySQL inside a Solaris Container. Although the document was focused on the Solaris Containers technology, majority of the tuning tips including the ZFS tips are applicable to all MySQL instances running [on Solaris] under different virtualization technologies.
You can access the blueprint document at the following location:
The blueprint document briefly explains the MySQL server & Solaris Containers technology, introduces different options to install MySQL server on Solaris 10, shows the steps involved in installing and running Solaris Zones & MySQL, and finally provides few best practices to run MySQL optimally inside a Solaris Container.
Feel free to leave a comment if you notice any incorrect information, or if you have generic suggestions to improve documents like these.
Many thanks to Prashant Srinivasan, John David Duncan and Margaret B. for their help in different phases of this blueprint.