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
Deletes a YMatrix database instance and its data.
Functionality
The mxdeletesystem utility stops the postgres processes on all Segment instances and the Master instance, then removes all data directories, restoring the system to its pre-deployment state.
Prerequisites
Note!
mxdeletesystemonly deletes the database instance and data. It does not remove the operating system usermxadmin, nor does it uninstall the YMatrix software.
| Option | Description |
|---|---|
| -c or --db-cluster-id |
Specifies the target database cluster ID. Uses the default ID if omitted. |
| -a or --no-prompt | Skips the confirmation prompt before deletion. By default, the user is prompted for confirmation. |
| -t or --timeout | Sets the command timeout duration. Default is 1 minute. |
| -q or --quiet | Runs in quiet mode. Output is suppressed on screen but still written to log files. |
| -h or --help | Displays help information. |
Delete a database cluster, with confirmation prompted after printing cluster information.
Note!
mxdeletesystemmust be executed by a user with sudo privileges on the Master host (exceptmxadmin, use absolute path/opt/ymatrix/matrixdb5/bin/mxdeletesystem).
$ mxdeletesystemDelete a database cluster without confirmation.
$ mxdeletesystem -aNote!
YMatrix 5 introduces a new database architecture. Usemxdeletesystemto delete clusters. This tool is not compatible withgpdeletesystem. For earlier versions, usegpdeletesystem.