3.0 Configuring MySQL with Novell Cluster Services

Novell Open Enterprise Server 11 SP2 provides an open source version of the MySQL 5.5.x software that is offered under the GNU General Public License (GPL) Version 2. Version 5.0.x is available on SLES 11 SP2 and earlier. MySQL can be used with Novell Cluster Services to provide high availability support to the customers you service with MySQL. This helps prevent interruptions of access for the MySQL database.

IMPORTANT:As stated in the Release Notes for SUSE Linux Enterprise Server 11 and later, the open source MySQL packages require additional support contracts to be obtained by the customer in order to receive full support.

The MySQL database format is upgraded from version 5.0 to version 5.5 in SUSE Linux Enterprise Server 11 SP3 and OES 11 SP2. For information about upgrading the database format, see Upgrading from MySQL 5.0 to MySQL 5.5 Introduces a New Database Format in the OES 11 SP2: Web Services and Applications Guide.

MySQL is installed on all nodes where you want it to run, but a database runs on only one node in the cluster at a time. The MySQL configuration files are modified on each node to point to a path on a Linux Logical Volume Manager (LVM) volume group cluster resource that contains the MySQL database files. You cluster-enable the volume group by using the MySQL template, then configure its resource load, unload, and monitoring scripts, set its resource failover and failback modes, and assign the resource to specific nodes in the cluster. When a node fails where the resource is online, the resource fails over to the next preferred node in the cluster.

IMPORTANT:Refer to the official MySQL 5.5 documentation for information about configuring, managing, and using MySQL. For information, see the MySQL Documentation Library: MySQL Reference Manuals.

The instructions in this section describes how to set up MySQL in a Novell Cluster Services cluster.