YMatrix
Quick Start
Simulate Time Series Scenarios
Standard Cluster Deployment
Data Modeling
Connecting to The database
Data Writing
Data Migration
Data Query
Scene Application Examples
Federal Query
Maintenance and Monitoring
Global Maintenance
Partition Maintenance
Backup and Restore
Cluster Expansion
Monitoring
Performance Tuning
Troubleshooting
Reference Guide
Tool Guide
Data Type
Storage Engine
Execution Engine
Configuration Parameters
Index
Extension
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');