How to Create and Configure a MySQL Protection Group

Language:

Before You Begin

Ensure that the following conditions are met:

The local cluster is a member of a partnership.
The protection group you are creating does not already exist, if you are going to create the MySQL configuration.
The protection group exists if you want to do anything other than create the MySQL configuration.
You must be assigned the Geo Management rights profile to complete this procedure. For more information, see Securing Disaster Recovery Framework Software in Installing and Configuring the Disaster Recovery Framework for Oracle Solaris Cluster 4.4.

Log in to a cluster node of the primary cluster.

Create the content for the mysql_geo_config file.
Note - If you added readonly=true to the my.cnf file for the secondary cluster, you must also set READONLY=true in the mysql_geo_config file. Adding readonly=true to the my.cnf file is described in Step 2 of How to Configure the MySQL Replication.

Copy the mysql_geo_config file to a different location.

For example:

phys-paris-1# cp /opt/SUNWscmys/geocontrol/util/mysql_geo_config /temp

Specify the following variables in /temp/mysql_geo_config. This list uses sample values.

PS=mysql-ps
PG=mysql-pg
REPCOMP=mysql.sbp
REPRS=mysql-rep-rs
REPRG=mysql-rep-rg
DESC="mysql replication pg"
CONFIGFILE=/geo-config/sbpconfig
REALMYSRG=paris-rg,newyork-rg
REALMYSRS=paris-mys-rs,newyork-mys-rs
READONLY=
APPRG=usa-rg
LONGPING=
SHORTPING=

Create the script-based plug-in configuration file on all nodes of all clusters.
Assuming that the nodes of the primary cluster, cluster-paris, are phys-paris-1 and phys-paris-2, on each node of cluster-paris, you would issue the following commands:
```
phys-paris-1# mkdir /geo-config
phys-paris-1# echo "mysql.sbp|any|phys-paris-1,phys-paris-2" > /geo-config/sbpconfig
```
Assuming that the nodes of the secondary cluster, cluster-newyork, are phys-newyork-1 and phys-newyork-2, on each node of cluster-newyork, you would issue the following commands:
```
phys-newyork-1# mkdir /geo-config
phys-newyork-1# echo "mysql.sbp|any|phys-newyork-1,phys-newyork-2" \
> /geo-config/sbpconfig
```

Execute the mysql_geo_register script on the primary cluster.

For example:

phys-paris-1# ksh /opt/SUNWscmys/geocontrol/util/mysql_geo_register \
-f /temp/mysql_geo_config

Replicate the protection group to the partner cluster.
Note - You can also accomplish this step by using the Oracle Solaris Cluster Manager GUI. Click Partnerships, click the partnership name, highlight the protection group name, and click Get Protection Groups. For more information about Oracle Solaris Cluster Manager, see Chapter 12, Using the Oracle Solaris Cluster Manager Browser Interface in Administering an Oracle Solaris Cluster 4.4 Configuration.

The final messages of the registration script outline the required geopg get command. You must log in to one node of the partner cluster and execute that exact command.
```
phys-newyork-1# geopg get --partnership mysql-ps mysql-pg
```