Enabling Segment Mirroring

    Important: During the online data replication process, Greenplum Database should be in a quiescent state, workloads and other queries should not be running.

    1. Use to ensure that the segment hosts can SSH and SCP to each other without a password prompt.

    2. 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:

    To add segment mirrors to an existing system (different hosts from primaries)

    1. Allocate the data storage area for mirror data on all segment hosts.

    2. Use gpssh-exkeys to ensure the segment hosts can SSH and SCP to each other without a password prompt.

    3. Run the utility to enable mirroring in your Greenplum Database system:

      Where -i names the mirror configuration file you created.

    Parent topic: Enabling Mirroring in Greenplum Database