YMatrix

• Introduction
• Architecture
• Features
• Scenarios

Quick Start

• Overview
• Install Cluster
• Enable Cluster
• Management

• Connecting

• Connect from clients
• Connect from code

• Benchmarks

• TPC-H
• TPC-DS
• SSB

Deployment

• Requirements

• Standard Deployment

• CentOS 7, Red Hat 7, etc.
• CentOS 8, Red Hat 8, etc.
• CentOS 9, Red Hat 9, etc.
• Ubuntu 20.04, etc.
• Kubernetes
• Unbalanced mode

Data Usage

• Data Ingestion

• MatrixGate
• Kafka
• Spark
• File
• Batch Merge Data (UPSERT)
• Connecting to MatrixGate

• Data Migration

• Single-table migration - MatrixGate
• Full-database migration - MatrixShift
• From Greenplum to YMatrix 6
• From YMatrix 4/5 to YMatrix 6
• Recommendations

• Data Query

• Basic Query
• Advanced Query

Manage Clusters

• Upgrade

• Major version
• Minor version
• Uninstall
• Daily Maintenance

• Global Maintenance

• MXUI Enable Mirroring
• Automated Partition
• Self-service Inspection
• Routine Vacuuming
• Load Analysis
• Statistics Query

• Expansion

• Overview
• Expansion: MatrixUI
• Expansion: Command Line
• Expand Catalogs

• Monitoring

• Overview
• MXUI Query Monitoring
• MXUI Health Monitoring

Security

• Overview
• Row and column Permissions
• GSSAPI
• SSL Transmission
• Encryption
• TDE
• Anonymizer
• Audit
• User Permissions Control
• etcd Encryption

Best Practice

• Data Modeling

• Overview
• Time-series Modeling
• Example: Vehicle Networking
• Example: Smarthome Best Practice
• DDL Best Practice
• Table Design
• Onboard: Executor
• Onboard: Streaming

• Onboard: Time-series

• Easy to Get Started
• Datainput Test
• Dataquery Test
• Onboard: Time-series
• Onboard: Performance

Technical Principles

• MPP Architecture
• Mirror Distribution
• Instance Process

• Data Type

• General Type
• JSON/JSONB、MXKV/MXKV2
• mxnumeric
• Spatial Type

• Storage Engine

• Overview
• Introduction
• Distribution Strategy
• Compression

• Execution Engine

• Overview
• Get Started
• Runtime Filter

• Streaming Engine(Domino)

• Overview
• Maintenance
• Function
• GUC

• MARS3 Index

• mars3_brin
• mars3_default_brin

• Extension

• matrixmgr

Advanced Features

• Advanced Query

• Continuous Aggregation
• Sliding Window
• Full-text Search
• Resource Group

• 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 ClickHouse
• PXF Access Oracle
• PXF Access SQL Server
• Automated Downgrade Storage
• ORCA

• Grafana

• Prometheus Installation
• Grafana Installation and Management
• Grafana Cluster Monitoring
• Grafana Cluster Alerts

• Backup and Restore

• Basic Tools
• Incremental Online Backup
• High Availability

• Disaster Recovery

• Overview
• Deployment
• Monitoring
• Switching

Graph Database

• Introduction

• Overview
• Setup
• Query Format
• Data Types
• Operators
• Aggregation
• Comparability, Equality, Orderability and Equivalence
• Importing Graph from Files

• Clauses

• CREATE
• MATCH
• RETURN
• WITH
• UNWIND
• SET
• REMOVE
• DELETE
• MERGE
• ORDER BY
• SKIP
• LIMIT

• Functions

• Aggregation Functions
• Scalar Functions
• String Functions
• Numeric Functions
• Trigonometric Functions
• Logarithmic Functions
• List Functions
• Predicate Functions
• Map Functions
• User Defined Functions

• Advanced

• Overview
• Using Cypher in a CTE/JOIN/SQL Expression
• PL/pgSQL Functions
• Prepared Statements
• SQL In Cypher

Guide

• Program Directories

• Performance Tuning

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

• Troubleshooting

• Log
• Advance Tools - minirepro
• Core Packaging tool - packcore

• Tools

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

• Configuration Parameters

• Overview
• Categories
• File Locations
• Connections and Authentication
• Client Connection Defaults
• Error Reporting and Logging
• Resource Consumption
• Query Tuning
• Runtime Statistics
• Automatic Vacuum
• Database Table
• Lock Management
• Resource Management
• Cluster
• Write-Ahead Log
• Replication
• PL/JAVA
• Version and Platform Compatibility
• Using MatrixUI
• Grafana Parameter
• Prometheus Parameter
• Glossary

SQL Reference

• ABORT
• ALTER_AGGREGATE
• ALTER_COLLATION
• ALTER_CONVERSION
• ALTER_DATABASE
• ALTER_DEFAULT_PRIVILEGES
• ALTER_DOMAIN
• ALTER_EXTENSION
• ALTER_EXTERNAL_TABLE
• ALTER_FOREIGN_DATA_WRAPPER
• ALTER_FOREIGN_TABLE
• ALTER_FUNCTION
• ALTER_GROUP
• ALTER_INDEX
• ALTER_LANGUAGE
• ALTER_MATERIALIZED_VIEW
• ALTER_OPERATOR
• ALTER_OPERATOR_CLASS
• ALTER_OPERATOR_FAMILY
• ALTER_POLICY
• ALTER_PROCEDURE
• ALTER_PROTOCOL
• ALTER_RESOURCE_GROUP
• ALTER_RESOURCE_QUEUE
• ALTER_ROLE
• ALTER_ROUTINE
• ALTER_RULE
• ALTER_SCHEMA
• ALTER_SEQUENCE
• ALTER_SERVER
• ALTER_STATISTICS
• ALTER_TABLE
• ALTER_TABLESPACE
• ALTER_TEXT_SEARCH_CONFIGURATION
• ALTER_TEXT_SEARCH_DICTIONARY
• ALTER_TEXT_SEARCH_PARSER
• ALTER_TEXT_SEARCH_TEMPLATE
• ALTER_TRIGGER
• ALTER_TYPE
• ALTER_USER
• ALTER_USER_MAPPING
• ALTER_VIEW
• ANALYZE
• BEGIN
• CALL
• CHECKPOINT
• CLOSE
• CLUSTER
• COMMENT
• COMMIT
• COPY
• CREATE_ACCESS_METHOD
• CREATE_AGGREGATE
• CREATE_CAST
• CREATE_COLLATION
• CREATE_CONVERSION
• CREATE_DATABASE
• CREATE_DOMAIN
• CREATE_EXTENSION
• CREATE_EXTERNAL_TABLE
• CREATE_FOREIGN_DATA_WRAPPER
• CREATE_FOREIGN_TABLE
• CREATE_FUNCTION
• CREATE_INDEX
• CREATE_LANGUAGE
• CREATE_MATERIALIZED_VIEW
• CREATE_OPERATOR
• CREATE_OPERATOR_CLASS
• CREATE_OPERATOR_FAMILY
• CREATE_POLICY
• CREATE_PROCEDURE
• CREATE_PROTOCOL
• CREATE_RESOURCE_GROUP
• CREATE_RESOURCE_QUEUE
• CREATE_ROLE
• CREATE_RULE
• CREATE_SCHEMA
• CREATE_SEGMENT_SET
• CREATE_SEQUENCE
• CREATE_SERVER
• CREATE_STATISTICS
• CREATE_STREAM
• CREATE_TABLE
• CREATE_TABLE_AS
• CREATE_TABLESPACE
• CREATE_TEXT_SEARCH_CONFIGURATION
• CREATE_TEXT_SEARCH_DICTIONARY
• CREATE_TEXT_SEARCH_PARSER
• CREATE_TEXT_SEARCH_TEMPLATE
• CREATE_TRIGGER
• CREATE_TYPE
• CREATE_USER
• CREATE_USER_MAPPING
• CREATE_VIEW
• DEALLOCATE
• DECLARE
• DELETE
• DISCARD
• DO
• DROP_ACCESS_METHOD
• DROP_AGGREGATE
• DROP_CAST
• DROP_COLLATION
• DROP_CONVERSION
• DROP_DATABASE
• DROP_DOMAIN
• DROP_EXTENSION
• DROP_EXTERNAL_TABLE
• DROP_FOREIGN_DATA_WRAPPER
• DROP_FOREIGN_TABLE
• DROP_FUNCTION
• DROP_GROUP
• DROP_INDEX
• DROP_LANGUAGE
• DROP_MATERIALIZED_VIEW
• DROP_OPERATOR
• DROP_OPERATOR_CLASS
• DROP_OPERATOR_FAMILY
• DROP_OWNED
• DROP_POLICY
• DROP_PROCEDURE
• DROP_PROTOCOL
• DROP_RESOURCE_GROUP
• DROP_RESOURCE_QUEUE
• DROP_ROLE
• DROP_ROUTINE
• DROP_RULE
• DROP_SCHEMA
• DROP_SEGMENT_SET
• DROP_SEQUENCE
• DROP_SERVER
• DROP_STATISTICS
• DROP_TABLE
• DROP_TABLESPACE
• DROP_TEXT_SEARCH_CONFIGURATION
• DROP_TEXT_SEARCH_DICTIONARY
• DROP_TEXT_SEARCH_PARSER
• DROP_TEXT_SEARCH_TEMPLATE
• DROP_TRIGGER
• DROP_TYPE
• DROP_USER
• DROP_USER_MAPPING
• DROP_VIEW
• END
• EXECUTE
• EXPLAIN
• GRANT
• IMPORT_FOREIGN_SCHEMA
• INSERT
• LISTEN
• LOAD
• LOCK
• MOVE
• NOTIFY
• PREPARE
• REASSIGN_OWNED
• REFRESH_MATERIALIZED_VIEW
• REINDEX
• RELEASE_SAVEPOINT
• RESET
• RETRIEVE
• REVOKE
• ROLLBACK_TO_SAVEPOINT
• ROLLBACK
• SAVEPOINT
• SELECT
• SELECT_INTO
• SET
• SET_CONSTRAINTS
• SET_ROLE
• SET_SESSION_AUTHORIZATION
• SET_TRANSACTION
• SHOW
• START_TRANSACTION
• TRUNCATE
• UNLISTEN
• UPDATE
• VACUUM
• VALUES

FAQ

• High-availability FAQ
• Installation FAQ
• Query FAQ
• MatrixGate FAQ
• Maintenance FAQ
• Alert FAQ
• PXF FAQ
• PLPython FAQ
• Performance FAQ