Get in Touch

Course Outline

Introduction to Greenplum

  • Overview of MPP databases and the underlying Greenplum architecture.
  • Distinguishing Greenplum from PostgreSQL: key architectural and functional differences.
  • Exploring use cases and potential integration scenarios.

Planning and Preparation for Installation

  • Reviewing system requirements and necessary prerequisites.
  • Designing cluster topology and networking infrastructure.
  • Optimizing disk configuration and adhering to performance best practices.

Greenplum Installation Process

  • Deploying the Greenplum Database on a Linux environment.
  • Configuring master and segment instances for optimal performance.
  • Initializing the cluster and validating the installation integrity.

Foundational Greenplum Administration

  • Utilizing core administrative tools such as gpstart, gpstop, and gprecoverseg.
  • Operating within the Greenplum Command Center for system oversight.
  • Managing user roles, resource queues, and workload distribution.

System Updates and Patching Strategies

  • Understanding Greenplum versioning protocols.
  • Implementing safe patching strategies and planning maintenance windows.
  • Executing rolling upgrades while maintaining backup integrity.

Library and Extension Management

  • Deploying and managing libraries such as PL/Java and PL/Python.
  • Installing extensions via gpkg and the CREATE EXTENSION command.
  • Managing library dependencies and coordinating updates.

Monitoring, Logging, and Troubleshooting

  • Leveraging performance monitoring tools and key metrics.
  • Analyzing logs and diagnosing system errors effectively.
  • Addressing common operational issues with proven resolution strategies.

Summary and Future Directions

Requirements

  • A solid grasp of fundamental database concepts and SQL.
  • Practical experience in Linux system administration.
  • Prior knowledge of PostgreSQL is beneficial.

Target Audience

  • Database Administrators
  • System Administrators
  • DevOps and Platform Engineers
 21 Hours

Number of participants


Price per participant

Testimonials (3)

Upcoming Courses

Related Categories