Greenplum管理实践.pptVIP

Practice Architecture – share nothing(MPP) Query Worker Processes Resource Queue Data Mirror Master Mirror Parallel Backup Non-Parallel Restore Non-Parallel Restore 1.Managing Roles and Privileges Role=User+Group 2. Configuring Client Authentication pg_hba.conf local all gpadmin trust host all gpadmin 127.0.0.1/32 password 3. Managing Workload and Resources Resource queue CREATE RESOURCE QUEUE executive WITH (ACTIVE_STATEMENTS=3, PRIORITY=MAX); 4. Defining Database Objects Multi-level Partition Design Check constraint 5. Managing Data Vacuuming the Database 6. Loading and Unloading Data gpload YAML file 7. High Availability Segment failure gprecoverseg Master failure gpactivatestandby Standby master out of sync gpinitstandby 8. Backup and restore gp_dump and gp_restore pg_dump 9. Expanding a Greenplum System gpexpand To interactively create an expansion input file: gpexpand -f hosts_file To initialize segments and create expansion schema: gpexpand -i input_file -D database_name To redistribute tables: gpexpand -d duration To remove the expansion schema: gpexpand -c Troubleshooting(1) SIGSEGVs gp_reraise_signal If enabled, will attempt to dump core if a fatal server error occurs. Troubleshooting(2) Out of memory gp_vmem_protect_limit Sets the amount of memory (in number of MBs) that all postgres processes of a segment instance can consume. Work_mem Specifies the amount of memory to be used by internal sort operations and hash tables before switching to temporary disk files. Troubleshooting(3) Hung query pg_locks pg_stat_activity pstack Troubleshooting(4) Orphan process In version 4.1: pg_locks. gp_segment_id The Greenplum segment id (dbid) where the lock is held. Troubleshooting(5) Catalog problem pg_stat_operations The view pg_stat_operations shows details about the last operation performed on a database object (such as a table, index, view or database) or a global object (such as a role). $GPHOME/bin/lib/gpcheckcat Check the system catalog tables for in