Sun engineer Krish Shankar has posted a detailed paper on how to deploy HA MySQL on a Solaris Cluster. Shankar also considered regression and failover testing of HA MySQL, and describes the tests performed. He found that the Solaris 10 Operating System (Solaris OS) fully supports MySQL and the HA cluster application agent for MySQL. The multi-threaded MySQL Open Source database consists of an SQL server, client programs and libraries, administrative tools, and APIs.

Shankar explains that a cluster provides a single view of services for applications such as databases, web services, and file services. Services can scale to additional processors with the addition of nodes. A data service is an application designed to run under the control of a cluster.

The scope of Shankar's deployment environment comprises MySQL Community Server on a Solaris 10 global zone. While the platform of choice was SPARC, the results are identical if deployed on an x86-64 platform, he writes. The scope of testing includes upgrade testing, regression testing, and failover testing. Testing with MySQL Cluster, and performance benchmarking is outside of the scope, however.

The setup comprises two SPARC V1280 systems connected by two private interconnects.The MySQL Community Server version used is 5.0.45 .

SPARC platform

• Nodes : v1280-137-03 and v1280-137-04
• CPU : 12 UltraSPARC-III+ x 1200 MHz
• Memory : 49,152 MB and 98,304 MB
• Storage : SE 6120 (14 x 73 GB )
• Operating System : Solaris 10 SPARC, Update 4

Shankar provides detailed installation instructions for the Sun Cluster and the HA MySQL service software components and for configuring a failover file system using a ZFS tool. He further documents the installation and configuration of the MySQL Server 5.0 and its upgrade testing to 5.1. [...read more...]

fullsource

From the latest issue:

Recent Blog Entries as of March 21, 2010, 4:54 pm
Oracle Works to Assuage the Anxieties of Its Customers SysAdmin News Bites Oracle Enterprise Manager Ops Center Released Suits and Their Countersuits A More Direct Channel Model Planned for Oracle-Sun	The Importance of Information Storage and Management Sun POJO Service Engine User's Guide Sun Storage 7000 2010.Q1 Quality and Features PSA Deploys GlassFish in the Manufacture of Peugeot, Citroën Vehicles Running VirtualBox VMs as Services in Windows
Blog RSS Feed