itpub.net]Greenplum管理实践.ppt

1、Practice, 2011.07.24,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,All of these are my own opinion, not for any company.,Feel free to correct me if I am wrong.,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,Architecture share nothing(MPP),商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,Query Work

2、er Processes,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,Resource Queue,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,Data Mirror,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,Master Mirror,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,Parallel Backup,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,Non-Parallel Restore,商业智能研讨沙龙上海站 ITPUB ChinaUnix I

3、XPUB主办,Non-Parallel Restore,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,Q,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,4. Defining Database Objects,Multi-level Partition Design Check constraint,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,5. Managing Data,Vacuuming the Database,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,6. Loading

4、and Unloading Data,gpload YAML file,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,7. High Availability,Segment failure gprecoverseg Master failure gpactivatestandby Standby master out of sync gpinitstandby,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,8. Backup and restore,gp_dump and gp_restore pg_dump,商业智能研讨沙龙上海站 ITP

5、UB ChinaUnix IXPUB主办,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 schem

6、a: gpexpand -c,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,Q&A,Before going further and further, here comes Q&A,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,Troubleshooting(1),SIGSEGVs gp_reraise_signal If enabled, will attempt to dump core if a fatal server error occurs.,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,Troubles

7、hooting(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.,商业智能研讨沙龙

8、上海站 ITPUB ChinaUnix IXPUB主办,Troubleshooting(3),Hung query pg_locks pg_stat_activity pstack,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,Troubleshooting(4),Orphan process In version 4.1: pg_locks. gp_segment_id The Greenplum segment id (dbid) where the lock is held.,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,Trouble

9、shooting(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 inconsistencies.,商业智能研讨沙龙上海站 ITPUB ChinaUnix IXPUB主办,Q&A,Before goin