Get in Touch
 Duration 21 hours

Course Outline

Introduction to Greenplum

  • An overview of MPP databases and the specific architecture of Greenplum
  • Distinguishing Greenplum from standard PostgreSQL: key architectural differences
  • Exploring typical use cases and integration scenarios

Planning and Preparation for Installation

  • Identifying system requirements and meeting prerequisites
  • Designing cluster topology and networking structures
  • Optimizing disk configuration and adhering to performance best practices

Installing Greenplum

  • Deploying the Greenplum Database on Linux systems
  • Setting up master and segment instances
  • Initializing the cluster and validating the successful installation

Fundamentals of Greenplum Administration

  • Utilizing core administrative tools such as gpstart, gpstop, and gprecoverseg
  • Interacting with the Greenplum Command Center for administrative tasks
  • Managing user roles, resource queues, and overall workload distribution

Managing System Updates and Patches

  • Grasping Greenplum versioning schemes
  • Implementing safe patching strategies and scheduling maintenance windows
  • Executing rolling upgrades while considering backup requirements

Library and Extension Oversight

  • Utilizing and administering libraries such as PL/Java and PL/Python
  • Installing extensions using gpkg and the CREATE EXTENSION command
  • Handling library dependencies and managing their updates

Monitoring, Logging, and Problem Resolution

  • Employing performance monitoring tools and tracking key metrics
  • Analyzing logs to identify and diagnose errors effectively
  • Addressing common operational issues and applying resolution strategies

Conclusion and Future Directions

Requirements

  • A solid grasp of fundamental database concepts and SQL syntax
  • Practical experience in Linux system administration
  • Prior familiarity with PostgreSQL is advantageous

Target Audience

  • Database administrators
  • System administrators
  • DevOps and platform engineers

Number of participants


Price per participant

Testimonials (2)

Upcoming Courses

Related Categories