CA API Management: Splitting a two node cluster into two independent nodes

Document ID : KB000010770
Last Modified Date : 14/02/2018
Show Technical Document Details
Introduction:

These steps can be followed to split a two node cluster into two individual nodes.

Instructions:

1. Stop slave replication on both nodes:

[root@ssg]# mysqladmin stop-slave

2. Reset the master configuration on both nodes:

[root@ssg]# mysql -e "reset master"

3. Reset the slave configuration on both nodes:

[root@ssg]# mysql -e "reset slave; reset slave all"

4. Modify the /etc/my.cnf file and comment out the following lines:

# Uncommment log-bin, log-slave-update and log_bin_trust_function_creators

# if a clustered db server

# log-bin=/var/lib/mysql/ssgbin-log

# log_bin_trust_function_creators=1

# log-slave-update

# uncomment the next item on 1st db master server

# server-id=1

# uncomment the next item on 2nd db master servers

# server-id=2

 

5. Restart the MySQL service on both nodes:

[root@ssg]# service mysql restart

6. From the ssgconfig menu select option:

2)  Display CA API Gateway configuration menu - >

3) Configure the CA API Gateway ->

1) Database Connection

 

7. Modify the setting to point to the local DB hostname. Once done this will return you to the previous menu.

8. From the ssgconfig menu select option the below option to remove failover server:

2) Configure Database Failover Connection

9. From the ssgconfig menu select the option below to restart the CA API Gateway:

7) Manage CA API Gateway status

Once the Gateway process restarts, log into the Policy against each node and open View -> Dashboard -> Cluster Status and right click on the node that no longer is a part of this cluster and select delete.