Enabling Segment Mirroring
Mirror segments allow database queries to fail over to a backup segment if the primary segment is unavailable. By default, mirrors are configured on the same array of hosts as the primary segments. You may choose a completely different set of hosts for your mirror segments so they do not share machines with any of your primary segments.
Important: During the online data replication process, Greenplum Database should be in a quiescent state, workloads and other queries should not be running.
- Allocate the data storage area for mirror data on all segment hosts. The data storage area must be different from your primary segments’ file system location.
- Use gpssh-exkeys to ensure that the segment hosts can SSH and SCP to each other without a password prompt.
Run the gpaddmirrors utility to enable mirroring in your Greenplum Database system. For example, to add 10000 to your primary segment port numbers to calculate the mirror segment port numbers:
$ gpaddmirrors -p 10000
-pspecifies the number to add to your primary segment port numbers. Mirrors are added with the default group mirroring configuration.
- Ensure the Greenplum Database software is installed on all hosts. See the Greenplum Database Installation Guide for detailed installation instructions.
- Allocate the data storage area for mirror data, and tablespaces if needed, on all segment hosts.
gpssh-exkeysto ensure the segment hosts can SSH and SCP to each other without a password prompt.
Create a configuration file that lists the host names, ports, and data directories on which to create mirrors. To create a sample configuration file to use as a starting point, run:
$ gpaddmirrors -o <filename>
The format of the mirror configuration file is:
row_idis the row in the file, contentID is the segment instance content ID, address is the host name or IP address of the segment host, port is the communication port, and
data_diris the segment instance data directory.
For example, this is contents of a mirror configuration file for two segment hosts and two segment instances per host:
0=2|sdw1-1|41000|/data/mirror1/gp2 1=3|sdw1-2|41001|/data/mirror2/gp3 2=0|sdw2-1|41000|/data/mirror1/gp0 3=1|sdw2-2|41001|/data/mirror2/gp1
gpaddmirrorsutility to enable mirroring in your Greenplum Database system:
$ gpaddmirrors -i <mirror_config_file>
-ioption specifies the mirror configuration file you created.
Parent topic:Enabling Mirroring in Greenplum Database