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 RBAC rights profile to complete this procedure. For more information, see Securing Geographic Edition Software in Oracle Solaris Cluster Geographic Edition Installation and Configuration Guide .
For example:
phys-paris-1# cp /opt/SUNWscmys/geocontrol/util/mysql_geo_config /temp
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=
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
For example:
phys-paris-1# ksh /opt/SUNWscmys/geocontrol/util/mysql_geo_register \ -f /temp/mysql_geo_config
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