Enabling Master Mirroring
You can configure a new Greenplum Database system with a standby master using
gpinitsystem or enable it later using
gpinitstandby. This topic assumes you are adding a standby master to an existing system that was initialized without one.
- Ensure the standby master host is installed and configured:
gpadminsystem user created, Greenplum Database binaries installed, environment variables set, SSH keys exchanged, and that the data directories and tablespace directories, if needed, are created.
gpinitstandbyutility on the currently active primary master host to add a standby master host to your Greenplum Database system. For example:
$ gpinitstandby -s smdw
-sspecifies the standby master host name.
To switch operations to a standby master, see Recovering a Failed Master.
You can run the
gpstate utility with the
-f option to display details of the standby master host.
$ 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.
Parent topic:Enabling Mirroring in Greenplum Database