h4. [High Availability MySQL Database Replication with Solaris Zone Cluster !Main^download.gif!|http://mapping.sun.com/profile/offer.jsp?id=215]
*by Pedro Lay{*}{excerpt}
February 2009{excerpt}
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.
h4. 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
{panel:title=About the Authors|borderStyle=solid|titleBGColor=#F8D583|bgColor=white}
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.
{panel}
{vote:Rate this blueprint}
Great
Good
Fair
Poor
{vote}
*by Pedro Lay{*}{excerpt}
February 2009{excerpt}
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.
h4. 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
{panel:title=About the Authors|borderStyle=solid|titleBGColor=#F8D583|bgColor=white}
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.
{panel}
{vote:Rate this blueprint}
Great
Good
Fair
Poor
{vote}