Quick onboard
Deployment
Data Modeling
Connecting
Migration
Query
Operations and Maintenance
Common Maintenance
Partition
Backup and Restore
Expansion
Mirroring
Resource Management
Security
Monitoring
Performance Tuning
Troubleshooting
Reference Guide
Tool guide
Data type
Storage Engine
Executor
Stream
DR (Disaster Recovery)
Configuration
Index
Extension
SQL Reference
Start a YMatrix database system.
The mxstart utility starts a YMatrix database cluster. It requires the cluster to be deployed with the new architecture introduced by YMatrix. When you start a YMatrix cluster, you are actually launching multiple PostgreSQL database server listener processes managed by the database replica service.
| Option | Description |
|---|---|
| -c or --db-cluster-id |
Specifies the target database cluster ID. Uses the default ID if omitted. |
| -m or --master-only | Starts only the master instance. Useful for maintenance tasks. After starting with this option, only utility-mode connections to the master are allowed. For example:PGOPTIONS='-c gp_role=utility' psql |
| -a or --no-prompt | Do not prompt for user confirmation. |
| -y | Do not start the standby instance. By default, the standby instance and synchronization process are started. |
| -q | Run in quiet mode. Command output is suppressed on screen but still written to log files. |
| -R | Start the database in restricted mode (only superusers can connect). |
| -t |
Sets the timeout (in seconds) to wait for segment instances to start. Segment startup may take longer due to recovery and validation processes if an instance was abnormally terminated (e.g., power failure or killed postgres process). Default is 60 seconds if not specified. |
| -h or --help | Show help information. |
| --log-level |
Set the logging level (error / debug / verbose / info). Default is info. |
Start the default YMatrix cluster without confirmation prompt:
mxstart -aStart the YMatrix database system in restricted mode (only superusers allowed):
mxstart -RStart only the YMatrix master instance and connect in utility mode:
mxstart -m PGOPTIONS='-c gp_role=utility' psqlNote!
YMatrix 5 uses a completely new database architecture. Themxstarttool must be used to start clusters. It is not compatible withgpstart. Earlier versions usedgpstart.