YMatrix

Version Release History
Platform Requirements

YMatrix

Quick Start

Standard Cluster Deployment

Data Modeling

Connecting to The database

Data Writing

Data Migration

Data Query

Maintenance and Monitoring

Performance Tuning

Troubleshooting

Reference Guide

SQL Reference

FAQ

scenario

YMatrix official documentation instructions

This document introduces the content logic and code usage instructions of YMatrix official document.

Content description

This document is the official document for YMatrix database products, which contains all the features officially supported in the current version. To make all content about YMatrix clear, this document is divided into several chapters according to its function:

  • Version Release History

This chapter contains an iterative version of YMatrix 5.X and provides related release introductions, bug fix introductions, and release dates.

  • System requirements

This section describes the minimum system environment requirements for installing and deploying YMatrix databases.

  • About YMatrix

This chapter is a global introduction to the product direction and technical function direction of YMatrix database. Anyone interested in YMatrix should not miss this section.

  • Get quick to get started

This chapter introduces YMatrix's rapid stand-alone deployment, basic feature experience and the construction of common scenarios, and is suitable for novice users or friends who want to quickly experience the YMatrix functions.

  • Standard cluster deployment

This chapter introduces the steps and precautions for YMatrix to deploy, upgrade, uninstall and reinstall clusters under different software and hardware environments and different network environments. If you are an enterprise technician, please refer to this chapter to complete the construction and basic management of the production cluster.

  • Data Modeling

This chapter introduces the definition of the data model, as well as the ideas, key points, scenario examples and DDL best practices for modeling YMatrix clusters in timing scenarios. Individual users, corporate technicians or database enthusiasts can refer to this chapter to complete simple timing modeling and query, and extend it to specific business scenarios on this basis.

  • Connect to database

This section describes how users connect to the YMatrix database through different clients or programming languages.

  • Data writing

This chapter introduces the data writing characteristics in timing scenarios, as well as how YMatrix connects to different data sources and writes data at high speed.

  • Data migration

This chapter introduces the ideas and tools for data migration in YMatrix, and gives examples of data migration from Greenplum 4/5/6 to YMatrix 5, and from YMatrix 4 to YMatrix 5.

  • Data Query

This chapter describes how YMatrix can query data efficiently. In addition to basic query statements, advanced query statements, scenario examples and query methods for different data sources are also provided.

  • Operation and maintenance monitoring

This chapter introduces how YMatrix uses statistics, backup, recovery, expansion, migration, inspection, cleaning and other solutions to complete daily operation and maintenance, and also introduces a variety of monitoring and alarm settings methods. Anyone who is officially running YMatrix needs to read this chapter to ensure the security of the data and database system.

  • Performance Tuning

This chapter introduces the performance tuning ideas in YMatrix, covering server system resource tuning, database resource tuning, and SQL tuning, as well as introducing query processing mechanisms and query plans. It has a certain reading difficulty and is suitable for friends who have a certain database knowledge base or tuning experience.

  • Troubleshooting

This chapter introduces how YMatrix analyzes and diagnoses cluster failures through tools such as logs.

  • Reference Guide

This chapter provides basic principles reference and usage guide for the use of YMatrix functions, including MPP architecture, mirror distribution strategy, automated partition management, continuous aggregation, sliding window, Grafana/Prometheus monitoring indicator interpretation, cluster management tools, storage engine, execution engine, data type and complete system configuration parameter description, etc.

  • SQL Reference

This chapter provides detailed reference information for SQL statements supported by YMatrix and supports the use of other chapters.

  • FAQ

This chapter classifies the common problems encountered by YMatrix in actual applications. You can directly view the location of the three-level directory location problem.

  • Scenario Application

This chapter introduces the main application scenarios of YMatrix in a combination of pictures and texts in detail.

Code usage instructions

  • Before code "$" means that this code needs to be implemented in the server
  • Before the code "~" means that this code needs to be implemented locally
  • Before the code "#" means that this code needs to be implemented using root user
  • "< >" is the schematic content, and the "< >" and its schematic content need to be replaced with the corresponding specific information according to the situation
  • The contents after "#", "##", "/", "//" in the code are code comments