Advantages of deploying MySQL database with Solaris Cluster
By Ritu Kamboj on Nov 04, 2008
The primary advantage of deploying the MySQL database in a Solaris Cluster environment is high availability. The Solaris Cluster environment provides fault monitoring and failover capabilities not only for the MySQL software, but also for the entire infrastructure including servers, storage, interconnects, and the operating system. If any component of the entire infrastructure fails, that failure is isolated and managed independently with no impact on availability.
MySQL Master-Slave configurations, deployed outside of a Solaris Cluster environment, provide limited availability: if the master fails, then the slave can manually be assigned master status and take over operation. However, this process is not automatic but requires manual intervention by a system administrator. Solaris Cluster removes this limitation, as it automatically fails over in the case of a master node failure. In addition, Solaris Cluster provides high availability for slaves as well as for masters. By providing high availability for slaves, these slaves can be kept updated with the masters throughout database transactions, thereby supporting scalability of MySQL database services. The Solaris cluster also provides both failover and scalable Apache Web server instances, thereby offering larger high availability coverage of the SAMP stack. Thus, MySQL Master-Slave configurations deployed in Solaris Cluster environment become highly available in the true sense.
Solaris Cluster deployments provide additional benefits beyond high availability. The Solaris Cluster environment can simplify administration by enabling clustered systems to be managed as if they were a single system. Data services, such as the MySQL database, can be deployed in Solaris Containers, providing the benefits of consolidation (as provided by Solaris Containers) as well as high availability (as provided by Solaris Cluster). Finally, both the MySQL database and Solaris Cluster are free and open source software, helping to contain costs and provide a low-cost solution for highly available databases.
If this is of interest to you , stay tuned here for a pointer on the blueprint for "Deploying MySQL Databases on Solaris Cluster Environment for increased High Availability"