|Skip Navigation Links|
|Exit Print View|
|Oracle Solaris Cluster Geographic Edition System Administration Guide Oracle Solaris Cluster 4.1|
This section provides an overview of the MySQL replication resource groups. A protection group that secures MySQL databases with MySQL replication consists of the following two resource groups securing a third resource group that is not part of the protection group on each cluster:
The MySQL database resource group holding a MySQL database is the foundation underneath the protection group. So, there must be strong positive dependencies with failover delegation should exist from the two resource groups in the protection group and the database resource group.
The MySQL database resource group typically contains the following resources:
HAStoragePlus resource, which manages database storage
Logical host resource, which provides the address to connect with the MySQL replication user
MySQL database resource, which resides on top of the first two resources to make the database highly available locally
On single-node clusters, the HAStoragePlus resource can be omitted. The creation of the database resource group and its resources is the topic of Oracle Solaris Cluster Data Service for MySQL Guide.
The database resource group and its objects can have different names across the clusters.
The MySQL replication resource group contains the MySQL replication resource. This resource does not start or stop any process. Its only purpose is to monitor the status of the MySQL database replication.
The MySQL application resource group must contain at least a logical host resource, which provides the address for all the clients to use for connections to the database.