The primary database in a cluster will move automatically if the current primary goes down, but you cannot control which of the previous standby databases will become the new primary database for the cluster. The following procedure should only be used if you want to move the primary database to a particular host server; but note that the primary database will move again automatically if this server goes down.

1. Check that the status of all the standby databases in the cluster is “In sync” by running the following MMP command on all servers hosting one of these databases 
   database cluster status
2. Uncluster all the databases by running the following MMP command on all servers including that hosting the primary database.
   database cluster remove
Note: All active calls will drop.
3. On the server with the database that you want to be the primary, initialize the database by running the following MMP command:
   database cluster initialize
4. Attach the other databases to the primary by running the following MMP command:
   database cluster join <primary hostname/IP>
5. Check the status of the new cluster to make sure that all the databases are in sync and to check which is the primary database.
   database cluster status

Last update:

08-Sep-2020

FAQ ID:

1074