YMatrix
Quick Start
Connecting
Benchmarks
Deployment
Data Usage
Manage Clusters
Upgrade
Global Maintenance
Expansion
Monitoring
Security
Best Practice
Technical Principles
Data Type
Storage Engine
Execution Engine
Streaming Engine(Domino)
MARS3 Index
Extension
Advanced Features
Advanced Query
Federal Query
Grafana
Backup and Restore
Disaster Recovery
Guide
Performance Tuning
Troubleshooting
Tools
Configuration Parameters
SQL Reference
Deletes a YMatrix database instance and its data.
Functionality
The mxdeletesystem utility stops the postgres processes on all Segment and Master instances, removes all data directories, and restores the system to its pre-database deployment state.
Prerequisites
Warning!
mxdeletesystemdeletes only 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 not displayed on screen but still written to the log file. |
| -h or --help | Displays help information. |
Delete a database cluster. The tool prints cluster information and prompts for confirmation before proceeding.
Warning!
mxdeletesystemmust be run as a user with sudo privileges on the Master host (exceptmxadmin, use absolute path/opt/ymatrix/matrixdb5/bin/mxdeletesystem).
$ mxdeletesystemDelete a database cluster without confirmation prompt.
$ mxdeletesystem -aWarning!
YMatrix 5 introduces a new database architecture. Usemxdeletesystemto delete clusters. It is not compatible withgpdeletesystem. For earlier versions, usegpdeletesystem.