YMatrix
Quick Start
Standard Cluster Deployment
Data Modeling
Connecting to The database
Data Migration
Data Query
Maintenance and Monitoring
Performance Tuning
Troubleshooting
Reference Guide
SQL Reference
FAQ
Small version upgrade refers to upgrading to a new version under the premise that the main version number remains unchanged. For example: upgrade from 5.0.0 to 5.0.2; upgrade from 5.0.0 to 5.1.0.
Below, take the example of upgrading from YMatrix 5.0.0 to 5.1.0 to introduce the detailed steps. In the example, the master node name is mdw.
Obtain the 5.1.0 installation package, matrixdb5-5.1.0+enterprise-1.el7.x86_64.rpm from the official website, and copy it to all nodes.
Switch to mxadmin user.
[<username>@mdw ~]$ sudo su - mxadmin
Stop the cluster.
[mxadmin@mdw ~]$ mxstop -af
Use the root user to execute:
# systemctl stop matrixdb5.supervisor.service
Copy the new RPM package to all nodes.
~ scp <local path> <username>@<server IP address>: <server path>
Upgrade to a new RPM package using root user:
# yum upgrade -y matrixdb5-5.1.0+community-1.el7.x86_64.rpm
# yum reinstall -y matrixdb5-5.1.0+community-1.el7.x86_64.rpm
Notes!
Do not useyum erase
, otherwise the configuration of the previous version will be deleted.
Notes!
Due to changes in the installation directory structure, be sure to execute thereinstall
command once after theupgrade
command to ensure that the installation directory is correct.
# systemctl start matrixdb5.supervisor.service
Switch to mxadmin user:
# su - mxadmin
Start the cluster:
$ mxstart -a
If the cluster topology has changed (added or decreased servers) in the new version of the database and Grafana monitoring is used in the cluster, then you need to log in to the matrixmgr database to upgrade the matrixmgr plug-in and reset the acquisition task:
[mxadmin@mdw ~]$ psql -d matrixmgr
matrixmgr=# ALTER EXTENSION matrixmgr UPDATE;
matrixmgr=# SELECT mxmgr_remove_all('local');
matrixmgr=# SELECT mxmgr_deploy('local');