VMware Tanzu Greenplum 6 Documentation

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

摘要

VMware Tanzu Greenplum 6 is a massively parallel processing (MPP) database server designed for next-generation data warehousing and large-scale analytics. It automatically partitions data and runs parallel queries, enabling a cluster of servers to operate as a single supercomputer. Compared to the open-source Greenplum Database, Tanzu Greenplum includes additional features such as product packaging, QuickLZ compression, data connectors, and enhanced contrib modules. The documentation covers installation, configuration, maintenance, and performance monitoring, providing insights into system architecture, security, and query optimization.

AI总结

### VMware Tanzu Greenplum 6 Documentation Summary

#### 1. **Introduction to Tanzu Greenplum**
- **Overview**: Tanzu Greenplum is a massively parallel processing (MPP) database server designed for next-generation data warehousing and large-scale analytics. It enables faster performance by automatically partitioning data and running parallel queries across a cluster of servers.
- **Key Features**:
- Supports SQL and MapReduce parallel processing.
- Handles data volumes from hundreds of gigabytes to hundreds of terabytes.

#### 2. **Differences from Open Source Greenplum Database**
- Tanzu Greenplum 6 includes all functionality from the open source version and adds:
- Product packaging and installation scripts.
- Support for QuickLZ compression (not available in open source due to licensing).
- Data connectors: Greenplum-NiFi, Greenplum-Spark, Greenplum-Informatica, Greenplum-Kafka, and Greenplum Streaming Server.
- Enhanced contrib modules: advanced_password_check, diskquota, gp_array_agg, etc.

#### 3. **Performance Monitoring and Maintenance**
- **Monitoring**:
- Includes tools like `gp_toolkit` for system monitoring.
- Performance factors: system resources, workload, throughput, contention, and optimization.
- **Maintenance**:
- Routine tasks: vacuum, analyze, reindex, and log file management.
- System catalog maintenance and query optimization.

#### 4. **Installation and Upgrading**
- **Hardware Requirements**:
- Virtual machine recommendations: 256 Compute, 256 Memory, 256 Network, 256 Storage.
- Azure recommendations for master and segment nodes.
- **Upgrade Process**:
- Detailed steps for upgrading clusters and maintaining transaction IDs.
- Includes guidance on patching and upgrading Tanzu Greenplum.

#### 5. **Security Configuration**
- **Security Features**:
- Configuring client authentication and database authorization using roles and permissions.
- Auditing database events for security threat detection.
- **Important Notes**:
- Tanzu Greenplum is based on PostgreSQL 9.4, and certain security scanning tools may misidentify vulnerabilities.
- VMware supports PostgreSQL 9.4 until Tanzu Greenplum reaches End of Support (EOS/EOL).

#### 6. **New Features and Resolved Issues**
- **Release Highlights**:
- Improved query planning and performance.
- Enhanced index creation on partitioned tables.
- Security improvements, including reduced risk of LDAP credentials exposure.
- **Resolved Issues**:
- Fixed inefficient query plans, index VACUUM strategy, and query hangs.

#### 7. **Data Loading and Unloading**
- **Data Loading**:
- Supports external tables for file-based and command-based data loading.
- Tools like `gpload` and `gpfdist` for efficient data ingestion.
- **Data Unloading**:
- Uses writable external tables and `COPY` command for data export.

#### 8. **Platform Requirements**
- **Hardware and Software**:
- Specific requirements for on-premise hardware, operating systems, and dependencies (e.g., Java).
- Recommendations for Tanzu Greenplum on DCA systems and storage considerations.

### Conclusion
VMware Tanzu Greenplum 6 provides a robust, scalable solution for data warehousing and analytics. The documentation covers installation, configuration, performance optimization, security, and data management, making it a comprehensive resource for administrators and developers.