Restoring Master Mirroring After a Recovery
A newer version of this documentation is available. Use the version menu above to view the most up-to-date release of the Greenplum 6.x documentation.
Restoring Master Mirroring After a Recovery
After you activate a standby master for recovery, the standby master becomes the primary master. You can continue running that instance as the primary master if it has the same capabilities and dependability as the original master host.
You must initialize a new standby master to continue providing master mirroring unless you have already done so while activating the prior standby master. Run gpinitstandby on the active master host to configure a new standby master. See Enabling Master Mirroring.
You can restore the primary and standby master instances on the original hosts. This process swaps the roles of the primary and standby master hosts, and it should be performed only if you strongly prefer to run the master instances on the same hosts they occupied prior to the recovery scenario.
For information about the Greenplum Database utilities, see the Greenplum Database Utility Guide.
To restore the master and standby instances on original hosts (optional)
- Ensure the original master host is in dependable running condition; ensure the cause of the original failure is fixed.
- On the original master host, move or remove the data directory,
gpseg-1. This example moves the directory to
backup_gpseg-1:
$ mv /data/master/gpseg-1 /data/master/backup_gpseg-1
You can remove the backup directory once the standby is successfully configured.
- Initialize a standby master on the original master host. For example, run
this command from the current master host,
smdw:
$ gpinitstandby -s mdw
- After the initialization completes, check the status of standby master, mdw. Run
gpstate with the -f option to check the
standby master status:
$ gpstate -f
The standby master status should be passive, and the WAL sender state should be streaming. - Stop the Greenplum Database master instance on the standby master. For
example:
$ gpstop -m
- Run the gpactivatestandby utility from the original
master host, mdw, that is currently a standby master. For
example:
$ gpactivatestandby -d $MASTER_DATA_DIRECTORY
Where the -d option specifies the data directory of the host you are activating.
- After the utility completes, run gpstate with the
-b option to display a summary of the system
status:
$ gpstate -b
The master instance status should be Active. When a standby master is not configured, the command displays No master standby configured for the standby master state.
- On the standby master host, move or remove the data directory, gpseg-1.
This example moves the
directory:
$ mv /data/master/gpseg-1 /data/master/backup_gpseg-1
You can remove the backup directory once the standby is successfully configured.
- After the original master host runs the primary Greenplum Database master,
you can initialize a standby master on the original standby master host. For
example:
$ gpinitstandby -s smdw
After the command completes, you can run the gpstate -f command on the primary master host, to check the standby master status.
To check the status of the master mirroring process (optional)
$ gpstate -f
The standby master status should be passive, and the WAL sender state should be streaming.
For information about the gpstate utility, see the Greenplum Database Utility Guide.