YMatrix
Quick Start
Simulate Time Series Scenarios
Standard Cluster Deployment
Data Modeling
Connecting to The database
Data Writing
Data Migration
Data Query
Maintenance and Monitoring
Performance Tuning
Troubleshooting
Reference Guide
Tool Guide
Data Type
Storage Engine
Execution Engine
Configuration Parameters
SQL Reference
FAQ
Start a YMatrix database system.
The mxstart tool is used to start YMatrix's database cluster. It requires that this database cluster deploy the new architecture introduced by YMatrix. When you start a YMatrix cluster, you are actually using the database replica service to start multiple postgres database server listener processes managed by the service.
| Parameter name | Description |
|---|---|
| -c or --db-cluster-id |
The ID of the target database cluster, if omitted, uses the default ID. |
| -m or --master-only | Start only the master instance, which may be useful for maintenance tasks. After using this option to start, only master connections in utility mode are allowed. For example: ` PGOPTIONS='-c gp_role=utility' psql |
| -a or --no-prompt | Do not prompt the user to confirm |
| -y | Do not start the standby instance. Without using this parameter, the standby instance and synchronization process will be started by default. |
| -q | Run in silent mode. The command output is not displayed on the screen, but is still written to the log file. |
| -R | Start the database in restricted mode (only allow database superuser connections). |
| -t |
Specifies the timeout (seconds) waiting for the segment instance to start. If a segment instance shuts down abnormally (for example due to a power failure or terminated its postgres database listener process), it may take a long time to start due to the database recovery and verification process. If not specified, the default timeout is 60 seconds. |
| -h or --help | Show help information. |
| --log-level |
The level of output log (Error / debug / verbose / info ), default is info |
Start YMatrix's default cluster (no prompt for confirmation):
mxstart -aStart the YMatrix database system in restricted mode (super user connections are allowed only):
mxstart -RStart only the YMatrix master instance and connect in utility mode:
mxstart -m PGOPTIONS='-c gp_role=utility' psqlNotes!
YMatrix 5 deploys a brand new database schema, enables the mxstart tool to start the cluster, which is incompatible with gpstart. Previous versions were available with the gpstart tool.