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
A minor version upgrade refers to upgrading to a new release while keeping the major version number unchanged.
For example: upgrading from 6.0.0 to 6.0.2, or from 6.0.0 to 6.1.0.
This document details the upgrade process from YMatrix 6.0.0 to 6.1.0. The master node in the example is named mdw.
Download the 6.1.0 installation package from the official website and copy it to all nodes in the cluster.
Copy the new RPM package to all nodes:
$ scp <local path> <username>@<server IP address>: <server path>
Switch to the mxadmin user:
[mxadmin@mdw ~]$ sudo su - mxadmin
Stop the cluster:
[mxadmin@mdw ~]$ mxstop -af
Run as root user:
$ sudo systemctl stop matrixdb6.supervisor.service
Upgrade to the new RPM package as root:
$ sudo yum upgrade -y matrixdb6-6.1.0+community-1.el7.x86_64.rpm $ sudo yum reinstall -y matrixdb6-6.1.0+community-1.el7.x86_64.rpm
Note!
Do not useyum erase, as it will remove configuration files from the previous version.
Note!
Due to changes in the installation directory structure, after running theupgradecommand, you must runreinstallto ensure the installation directories are correctly set.
Restart the supervisor service:
$ sudo systemctl start matrixdb6.supervisor.service
Switch to the mxadmin user:
$ su - mxadmin
Start the cluster:
$ mxstart -a
If the cluster topology has changed in the new database version (e.g., servers added or removed), and Grafana monitoring is used in the cluster, log in to the matrixmgr database and upgrade the matrixmgr extension. Then reset the data collection tasks:
``
[mxadmin@mdw ~]$ psql -d matrixmgr
matrixmgr=# ALTER EXTENSION matrixmgr UPDATE; matrixmgr=# SELECT mxmgr_remove_all('local'); matrixmgr=# SELECT mxmgr_deploy('local'); ``
