YMatrix

• Introduction
• Architecture
• SSB Benchmark
• TPC-H Benchmark
• Database Features
• Conventions

Quick Start

• Quick Install

• Simulate Time Series Scenarios

• Easy to Get Started
• Datainput Test
• Dataquery Test
• Time Series Scenario Practice
• Loading Performance Experience
• Basic Management

Standard Cluster Deployment

• Online Cluster Deployment

• CentOS 7, Red Hat 7, etc.
• CentOS 8, Red Hat 8, etc.
• Ubuntu 20.04, etc.
• Major Version Upgrade
• Minor Version Upgrade
• Deployment under Kubernetes
• Cluster Uninstall

Data Modeling

• Time Series Data Model
• Time Series Modeling Approach
• Vehicle Networking Best Practices
• Smarthome Best Practice
• DDL Best Practice

Connecting to The database

• Client Connection
• Code Connection

Data Writing

• Data Writing Characteristics in Time Series Scenarios
• Write Tool

• Write Scenarios

• Kafka Writing
• Code Writing MatrixGate
• File Writing
• Batch Merge Data (UPSERT)

Data Migration

• Migration Approach

• Migration Tool

• Single Table Migration - mxgate
• Full-database Migration - mxshift
• Migrating Data from Greenplum to YMatrix 5
• Migrating Data from YMatrix 4 to YMatrix 5

Data Query

• Basic Query
• Advanced Query

• Federal Query

• Overview
• FDW for PostgreSQL
• FDW for MySQL
• FDW for MongoDB
• PXF Install
• PXF Access HDFS
• PXF Access Hive ORC
• PXF Access S3
• PXF Access Oracle
• PXF Access SQL Server

Maintenance and Monitoring

• Daily Management
• Self-service Inspection
• Automated Partition Management
• Routine Vacuuming
• Statistics Query
• Backup and Restore
• Crash Recover

• Cluster Expansion

• Overview
• MXUI Expansion
• Command Line Online Expansion
• Expand System Directory
• Query Monitoring
• Grafana Monitoring
• Prometheus Monitoring
• etcd Monitoring
• Health Monitoring
• Alert Settings

Performance Tuning

• Overview
• Approach
• SQL Tuning - Query Processing
• SQL Tuning - Understanding Query Plans

Troubleshooting

• Log
• Field Preservation Tools - minirepro
• Core Packaging tool - packcore

Reference Guide

• MPP Architecture
• Mirror Distribution Policy
• Continuous Aggregation
• Sliding Window
• Grafana Interpretation
• Prometheus Interpretation
• Glossary

• Tool Guide

• mxaddmirrors
• mxbackup
• mxbench
• mxdeletesystem
• mxgate
• mxinitstandby
• mxmoveseg
• mxpacklogs
• mxrecover
• mxrestore
• mxshift
• mxstart
• mxstate
• mxstop
• gpconfig

• Data Type

• General Type
• JSON、JSONB、MXKV
• Spatial Types

• Storage Engine

• Overview
• Introduction
• Best Practices for Table Design
• Use Compression
• Status Diagnosis

• Execution Engine

• Overview
• Get Started
• Best Practice
• Runtime Filter

• Configuration Parameters

• Overview (required)
• Categories
• File Locations Parameters
• Connections andAuthentication Parameters
• Client Connection Defaults Parameters
• Error Reporting and Logging Parameters
• Resource Consumption Parameters
• Query Tuning Parameters
• Runtime Statistics Parameters
• Automatic Vacuum Parameters
• Database Table Parameters
• Lock Management Parameters
• Resource Management Parameters
• YMatrix Database Cluster Parameters
• Write-Ahead Log Parameters
• Replication Parameters
• PL/JAVA Parameters
• Version and Platform Compatibility Parameters

SQL Reference

• ABORT
• ALTER_DATABASE
• ALTER_EXTENSION
• ALTER_EXTERNAL_TABLE
• ALTER_FOREIGN_DATA_WRAPPER
• ALTER_FOREIGN_TABLE
• ALTER_FUNCTION
• ALTER_INDEX
• ALTER_RESOURCE_GROUP
• ALTER_RESOURCE_QUEUE
• ALTER_ROLE
• ALTER_RULE
• ALTER_SCHEMA
• ALTER_SEQUENCE
• ALTER_SERVER
• ALTER_TABLE
• ALTER_TABLESPACE
• ALTER_TYPE
• ALTER_USER_MAPPING
• ALTER_VIEW
• ANALYZE
• BEGIN
• CHECKPOINT
• COMMIT
• COPY
• CREATE_DATABASE
• CREATE_EXTENSION
• CREATE_EXTERNAL_TABLE
• CREATE_FOREIGN_DATA_WRAPPER
• CREATE_FOREIGN_TABLE
• CREATE_FUNCTION
• CREATE_INDEX
• CREATE_RESOURCE_GROUP
• CREATE_RESOURCE_QUEUE
• CREATE_ROLE
• CREATE_RULE
• CREATE_SCHEMA
• CREATE_SEGMENT_SET
• CREATE_SEQUENCE
• CREATE_SERVER
• CREATE_TABLE
• CREATE_TABLE_AS
• CREATE_TABLESPACE
• CREATE_TYPE
• CREATE_USER_MAPPING
• CREATE_VIEW
• DELETE
• DROP_DATABASE
• DROP_EXTENSION
• DROP_EXTERNAL_TABLE
• DROP_FOREIGN_DATA_WRAPPER
• DROP_FOREIGN_TABLE
• DROP_FUNCTION
• DROP_INDEX
• DROP_RESOURCE_GROUP
• DROP_RESOURCE_QUEUE
• DROP_ROLE
• DROP_RULE
• DROP_SCHEMA
• DROP_SEGMENT_SET
• DROP_SEQUENCE
• DROP_SERVER
• DROP_TABLE
• DROP_TABLESPACE
• DROP_TYPE
• DROP_USER_MAPPING
• DROP_VIEW
• END
• EXPLAIN
• GRANT
• INSERT
• LOAD
• LOCK
• REINDEX
• RELEASE_SAVEPOINT
• RESET
• REVOKE
• ROLLBACK_TO_SAVEPOINT
• ROLLBACK
• SAVEPOINT
• SELECT INTO
• SET ROLE
• SET TRANSACTION
• SET
• SHOW
• START TRANSACTION
• TRUNCATE
• UPDATE
• VACUUM

FAQ

• Architecture FAQ
• High Availability FAQ
• Install FAQ
• SQL Query FAQ
• MatrixGate FAQ
• Maintenance FAQ
• Alert FAQ
• PXF FAQ
• PLPython FAQ
• Performance FAQ