High Availability MySQL Database Replication with Solaris Zone Cluster 
by Pedro Lay
February 2009
New technology offers new possibilities to accomplish things in a different and more efficient way, moreover when there is a convergence of three new technologies that complements and provides additional capabilities to solve business requirements. Such is the case of when Sun MySQL™ Replication, Solaris™ Containers and Solaris Zone Cluster come into play.
This paper describes the benefit of deploying the master and slave database of MySQL Replication using Zone Clusters. In addition, it provides details on how to deploy the master and slave databases in two different Zone Clusters, using non-global zones from two different machines as the virtual cluster nodes.
Contents
- High Availability MySQL™ Database Replication with Solaris™ Zone Cluster
- MySQL database replication
- Solaris Zones
- Solaris Cluster
- Example configuration
- Failover scenarios
- Summary
- About the author
- References
- Ordering Sun documents
- Accessing Sun documentation online
- Appendix A: Command files for clzonecluster
- Appendix B: MySQL configuration file
- Appendix C: Configuration files: /config-files/mysql_config
- Appendix D: Configuration files: /config-files/ha_mysql_config
Pedro Lay is an Enterprise Solutions Architect in Sun's Systems Technical Marketing Group. He has over 20 years of industry experience that spans application development, database and system administration, and performance and tuning efforts. Since joining Sun in 1990, Pedro has worked in various organizations including Information Technology, the Customer Benchmark Center, the Business Intelligence and Data Warehouse Competency Center, and the Performance Applications Engineering group.
| Rate this blueprint (Log In to vote.) | |
|---|---|
| Choices | Your Vote |
Great |
|
Good |
|
Fair |
|
Poor |
|
Comments (1)
Sep 28
Thorsten.Frueauf says:
It seems there is something missing from Appendix A. The input to clzonecluster ...It seems there is something missing from Appendix A. The input to clzonecluster is missing the configuration for
the used HA ZFS file system (/pool2 for ZC2 and /pool3 for ZC3).
According to the blueprint "Zone Clusters - Hot to deploy virtual clusters and why" on page 34, it is required to
delegate the zpool as a dataset, like
add dataset
set name=pool2
end
Otherwise the HASP resource will error out on validation.
Regards
Thorsten