Get in Touch
 Duration 21 hours

Course Outline

Introduction to Greenplum

  • Conceptual overview of MPP databases and Greenplum's architectural design.
  • Differentiating features: Greenplum versus PostgreSQL.
  • Identifying key use cases and integration scenarios.

Pre-Installation Planning and Preparation

  • Defining system requirements and verifying prerequisites.
  • Designing cluster topology and networking strategies.
  • Optimizing disk configuration and adhering to performance best practices.

Installing Greenplum

  • Deploying Greenplum Database on Linux systems.
  • Configuring master and segment instances effectively.
  • Initializing the cluster and validating the installation process.

Core Greenplum Administration

  • Utilizing core utilities such as gpstart, gpstop, and gprecoverseg.
  • Navigating the Greenplum Command Center interface.
  • Managing user roles, resource queues, and workload allocation.

System Updates and Patch Management

  • Navigating Greenplum versioning structures.
  • Implementing safe patching strategies and scheduling maintenance windows.
  • Executing rolling upgrades while considering backup integrity.

Managing Libraries and Extensions

  • Utilizing and administering PL/Java, PL/Python, and other procedural languages.
  • Installing extensions using gpkg and the CREATE EXTENSION command.
  • Tracking dependencies and managing library updates.

Monitoring, Logging, and Troubleshooting

  • Leveraging performance monitoring tools and interpreting key metrics.
  • Analyzing logs to diagnose and resolve errors.
  • Addressing common operational issues with effective resolution strategies.

Course Summary and Future Learning Paths

Requirements

  • A solid grasp of fundamental database concepts and SQL language.
  • Practical experience in Linux system administration.
  • Prior familiarity with PostgreSQL, while beneficial, is not strictly mandatory.

Target Audience

  • Database administrators.
  • System administrators.
  • DevOps and platform engineers.

Testimonials (2)

Related Categories