VMware Tanzu Greenplum v6.23 Documentation

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

摘要

The document provides comprehensive guidance on installing, configuring, and upgrading VMware Tanzu Greenplum Database 6.23. It covers platform requirements, storage estimation, system configuration, and optional extensions. The document also details the differences between VMware Tanzu Greenplum and the open-source version, including additional features like QuickLZ compression, data connectors, and enhanced contrib modules. It includes information on upgrading from previous versions and resolving known issues. The architecture and deployment options are also discussed, along with best practices for handling single host failures and maintenance.

AI总结

### VMware Tanzu Greenplum v6.23 Documentation Summary

#### 1. **Product Overview**
- **VMware Tanzu Greenplum** 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.
- It operates as a single database supercomputer, offering performance improvements of tens to hundreds of times faster than traditional databases.

#### 2. **Key Features**
- **Enhanced Functionality Over Open Source Greenplum**:
- Product packaging and installation scripts.
- Support for QuickLZ compression (not available in open source due to licensing).
- Data connectors (Greenplum-NiFi, Greenplum-Spark, etc.).
- Additional contrib modules (e.g., advanced_password_check, diskquota).

- **New Features in v6.23**:
- Zstandard Compression Algorithm.
- Relaxed rules for table distribution columns.
- Enhanced resource groups and concurrency improvements.
- Support for PostgreSQL features like INTERVAL data type handling and PL/pgSQL enhancements.

- **Query Optimizer Improvements**:
- Resolved issues with incorrect cardinality estimates and query optimization.
- Improved query plans and fallback to Postgres Planner when necessary.

#### 3. **Platform Requirements**
- **Operating Systems**: Specific versions of Linux are supported.
- **Hardware and Network**: Minimum hardware specifications and network performance requirements are outlined.
- **Storage**: Recommendations for estimating storage capacity, including space for backups and data loads.

#### 4. **Installation and Configuration**
- **Installation Steps**:
- Prepare the operating system environment.
- Install Greenplum Database software binaries.
- Enable passwordless SSH for the `gpadmin` user.
- Validate hardware and network performance.

- **Data Storage Areas**:
- Directories for master, standby, and segment instances must be created.
- Backup and data load file storage is recommended on each segment host.

- **Cluster Management**:
- Initial setup and validation of the database system.
- Optional extensions and modules can be installed post-initialization.

#### 5. **Upgrading Greenplum**
- **Upgrade Paths**:
- Instructions for upgrading from Greenplum Database 6.x to newer versions.
- Migration paths for Tanzu Greenplum 4.x or 5.x data to 6.x.

- **Upgrade Process**:
- Includes playbooks and scripts for automated upgrades.
- Post-upgrade validation and configuration steps.

#### 6. **Known Issues and Limitations**
- **Single Host Failure**: If more than one host fails, it can result in service interruption.
- **Resolved Issues**: Fixes for problems like authentication mismatches, query crashes, and performance bottlenecks are included.

#### 7. **Documentation Resources**
- Links to related Tanzu products and additional documentation.
- Architecture diagrams and planning guides for deploying Greenplum on Dell EMC VxRail systems.

This summary provides a concise overview of the key features, installation, configuration, and upgrade processes for VMware Tanzu Greenplum v6.23, along with important platform requirements and known issues.