What is gpmovemirrors?
gpmovemirrors is a utility in Greenplum Database used to perform the relocation of mirror segments within a Greenplum Database system. This utility is especially useful for tasks such as rebalancing data, recovering from mirror segment failures, or optimizing system performance.
Why is it important?
Maintaining healthy and balanced mirror segments is critical to the reliability and performance of a Greenplum Database cluster. gpmovemirrors ensures the efficient distribution of data across segments, minimizes downtime, and safeguards against data loss.
How to use gpmovemirrors:
Using gpmovemirrors involves specifying the source and destination mirrors for the data movement. Below is an example of how to use the utility:
gpmovemirrors [options] --source <source-mirror> --destination <destination-mirror>
gpmovemirrors -d <dbname>
{ -s <schema> |
{ -t <schema>.<table>
[ -i <col1>[, <col2>, ...] |
-x <col1>[, <col2>, ...] ] } |
{ -f | --file} <config-file> }
[ -l | --list ]
[ --gen_profile_only ]
[ -p <parallel-level> ]
[ --full ]
[ --skip_root_stats ]
[ -v | --verbose ]
[ --debug ]
[ -a ]
gpmovemirrors { --clean_last | --clean_all }
gpmovemirrors --version
gpmovemirrors { -? | -h | --help }