VMware Greenplum 6 Documentation

• 语言: 英语
• 格式: .pdf
• 来源: docs.vmware.com

摘要

VMware Greenplum 6 is a massively parallel processing (MPP) database server designed for next-generation data warehousing and large-scale analytics. It supports SQL and MapReduce parallel processing, enabling clusters of servers to operate as a single database supercomputer. The document highlights differences between VMware Greenplum 6 and the open-source version, including additional features such as QuickLZ compression, data connectors, and enhanced contrib modules. It also provides details on system requirements, installation, configuration, and upgrade processes, along with performance monitoring tools and resource management strategies.

AI总结

### VMware Greenplum 6 Documentation Summary

#### 1. **Introduction**
- VMware Greenplum 6 is a massively parallel processing (MPP) database server designed for next-generation data warehousing and large-scale analytics.
- It supports SQL, MapReduce parallel processing, and data volumes ranging from hundreds of gigabytes to hundreds of terabytes.

#### 2. **Key Features Compared to Open Source Greenplum Database**
- Includes all functionality from the open source version.
- Adds:
- Support for QuickLZ compression (not available in open source due to licensing).
- Data connectors: VMware Greenplum, Apache NiFi, Apache Spark, Informatica, Kafka, RabbitMQ, S3.
- Enhanced contrib modules: advanced_password_check, greenplum_fdw, ip4r, pgaudit, postgresql-hll, timestamp9.

#### 3. **Release Notes**
- Document covers VMware Greenplum 6.x releases, including release dates and updates.
- **Release 6.27.1 (2024-05-08)**:
- Introduces `wal_sender_archiving_status_interval` parameter.
- No longer removes pg_rewind and pg_basebackup logs.
- Resolves issues with `gpssh` and debugging features.

#### 4. **Compatibility**
- **Java Support**: Open JDK 8/11 or Oracle JDK 8/11.
- **Client Tools**: Supported on Red Hat Enterprise Linux (RHEL 6, 7, 8), Ubuntu 18.04 LTS, SUSE Linux Enterprise Server (SLES 12), and various Windows versions (10, 8, Server 2012, 2012 R2, 2008 R2).

#### 5. **Performance Monitoring and Management**
- **Greenplum Command Center**: Optional web-based tool for monitoring and managing Greenplum Database.
- **Utilities**: Command-line tools for administration tasks like backup, restore, data loading, and system monitoring.

#### 6. **Installation and Configuration**
- **Platform Requirements**: Hardware and software prerequisites for installation.
- **Storage Estimation**: Guidelines for estimating system capacity, including space for backups and data loads.
- **Installation Steps**: Includes enabling passwordless SSH for the `gpadmin` user and validating system configurations.

#### 7. **Upgrading Greenplum**
- Instructions for upgrading from Greenplum Database 6.x to VMware Greenplum 6.
- **Upgrade Paths**: Detailed in the documentation.

#### 8. **Cluster Management**
- **Two-Tier Architecture**: Segregates master/standby and segment hosts for scalability and fault tolerance.
- **Deployment Examples**: Configurations for 10 TiB, 100 TiB, and 1 PiB databases, based on physical host specifications (e.g., 152 logical cores, 1024 GB RAM, 32 TB storage).

#### 9. **Security and Performance**
- **SELinux and Firewalls**: Requires deactivation or custom configuration to ensure Greenplum Database functionality.
- **Virtual Memory Calculator**: For resource queue-based workload management.

#### 10. **Extensions and Modules**
- Additional modules and extensions, including PostgreSQL and Greenplum-sourced contrib modules, are available for enhanced functionality.

#### 11. **Performance Optimization**
- **Workload Management**: Uses resource queues for managing system resources.
- **Storage Recommendations**: Based on the number of segment hosts and expected data size.

This summary captures the essential information from the VMware Greenplum 6 documentation, focusing on key features, releases, compatibility, and operational considerations.