YMatrix
Quick Start
Standard Cluster Deployment
Data Modeling
Connecting to The database
Data Migration
Data Query
Maintenance and Monitoring
Performance Tuning
Troubleshooting
Reference Guide
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.