Greenplum Administration Training in Marina Bay, Singapore

This course provides participants with a comprehensive understanding of Greenplum Database (GPDB) administration. It covers installation, configuration, resource management, data distribution, high availability, backup & recovery, monitoring, and performance tuning. By the end of the course, participants will be equipped with the skills to effectively manage, optimize, and secure Greenplum environments for enterprise-scale analytics.

Introduction & Setup

• Greenplum Database Overview

  • Evolution and use cases

  • MPP (Massively Parallel Processing) concepts

• Greenplum Architecture

  • Master, Standby, and Segment nodes

  • Interconnect and resource management

• Installation and Configuration

  • System requirements & environment setup

  • Installing Greenplum on Linux clusters

  • Initial configuration & gpconfigs

Administration & Maintenance

• Data Distribution and Storage

  • Distribution keys, partitioning, replication

  • Managing tablespaces and storage

• User & Role Management

  • Roles, privileges, security best practices

• Backup and Recovery

  • gpcrondump, gp_restore, incremental backups

  • Disaster recovery scenarios

• Monitoring & Logging

  • gpstate, gpconfig, gp_toolkit views

  • Integration with monitoring tools (Grafana, Prometheus)

Performance & High Availability

• Query Performance Tuning

  • Query plans, EXPLAIN, ANALYZE

  • Optimizer (ORCA vs legacy)

  • Workload management

• High Availability & Failover

  • Standby master configuration

  • Segment mirroring & fault tolerance

• Troubleshooting & Maintenance

  • Common issues & resolutions

  • Maintenance tasks (vacuum, analyze, reindex)

Hands-on Exercises

Summary and Conclusion