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 failover MySQL database resource group holding a MySQL database is the foundation underneath the protection group. Therefore, strong positive affinities with failover delegation must exist from from the replication resource group to the failover MySQL database resource group.
The mysql_geo_register script creates the replication resource group and sets affinity from the replication resource group to the failover MySQL database resource group. You must add to this script an affinity from the application resource group to the failover MySQL database resource group. If affinity or dependency is needed from the application resource group that is added to the MySQL protection group, you must add this affinity or dependency.
The MySQL database resource group must be configured as a failover resource group. It typically contains the following resources:
Storage 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 storage 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 failover 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.