YMatrix
English
Русский
简体中文

Blog Document About
Blog Document About
Version Release History
Platform Requirements

YMatrix

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

Quick Start

  • Quick Install
  • Simulate Time Series Scenarios
  • Time Series Scenario Practice
  • Loading Performance Experience
  • Basic Management

Standard Cluster Deployment

  • Online Cluster Deployment
  • 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

Connecting to The database

  • Client Connection
  • Code Connection

Data Writing

  • Data Writing Characteristics in Time Series Scenarios
  • Write Tool
  • Write Scenarios

Data Migration

  • Migration Approach
  • Migration Tool
  • Migrating Data from Greenplum to YMatrix 5
  • Migrating Data from YMatrix 4 to YMatrix 5

Data Query

  • Basic Query
  • Advanced Query
  • Federal Query

Maintenance and Monitoring

  • Daily Management
  • Automated Partition Management
  • Routine Vacuuming
  • Statistics Query
  • Backup and Restore
  • Crash Recover
  • Cluster Expansion
  • 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

  • Tool Guide
  • Data Type
  • Storage Engine
  • Execution Engine
  • Mirror Distribution Policy
  • Continuous Aggregation
  • Sliding Window
  • Grafana Interpretation
  • Prometheus Interpretation
  • Glossary

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
  • Install FAQ
  • SQL Query FAQ
  • MatrixGate FAQ
  • Maintenance FAQ
  • Alert FAQ
  • PXF FAQ
  • PLPython FAQ
  • Performance FAQ
scenario

Migration Tools

This document introduces the migration tools for YMatrix.

Single Table Migration Tool - mxgate

Full Database Migration Tool - mxshift

← Previous
Migration Approach
Next →
Migrating Data from Greenplum to YMatrix 5
Email: [email protected]
Tel: +86-010-61253503
北京四维纵横数据技术有限公司       Beijing Siwei Zongheng Data Technology Co.