There are two separate environments with 2 node clusters. Currently, objects are manually modified in each cluster. There is a difference in the certificates of the ID Provider resulting in failures to one cluster only.
What's the best approach to sync these two environments?
API Gateway 10.0
Manual changes are prone to errors .
Best approach is to dump the SSG DB from the good cluster then import into the problematic cluster.
The steps are similar to clone and the KB for re-init replication
NOTE: Check with the team regarding cluster passphrase between the two different cluster
First dump the SSG DB from the node in the good cluster
# mysqldump ssg --routines > /home/ssgconfig/01-ssg.sql
Copy the backup-ssg.sql to the problematic each node in the cluster
On the problematic cluster
STOP SSG services on both gateways
# service ssg stop
Stop slave replication on both nodes:
# mysqladmin stop-replica
Reset the master configuration on both nodes:
# mysql -e "reset master"
# mysql -e "reset slave; reset slave all;"
Backup current SSG DB on problematic gateway as a precaution
mysqldump ssg --routines > /home/ssgconfig/03-ssg.sql
Drop the SSG from the BOTH gateways and import the SSG DB from the good cluster to both
# mysql
# drop database ssg;
# create database ssg;
# mysql -u root -p ssg < 01-ssg.sql
Clear cluster_info table on BOTH Gateways
# mysql
mysql> use ssg;app*A
mysql> truncate table cluster_info;
SETUP replication Secondary gateway and restart replication on the primary node
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Seconds_Behind_Master: 0