3.0 Configuring MySQL with Novell Cluster Services

Novell Open Enterprise Server 11 and later provides an open source version of MySQL 5.0.x software that is offered under the GNU General Public License (GPL) Version 2. 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 Service Pack 2, the open source MySQL packages require additional support contracts to be obtained by the customer in order to receive full support.

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.0 documentation for information about configuring, managing, and using MySQL. For information, see MySQL Documentation Library: MySQL Reference Manuals.

You can use the instructions in this section to set up a MySQL database on an OES 11 cluster.