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
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'); ``