YMatrix

Version Release History
Platform Requirements

YMatrix

Quick Start

Standard Cluster Deployment

Data Modeling

Connecting to The database

Data Writing

Data Migration

Data Query

Maintenance and Monitoring

Performance Tuning

Troubleshooting

Reference Guide

SQL Reference

FAQ

scenario

MatrixDB 4 small version upgrade

This document introduces the small version upgrade method of MatrixDB 4 database software, as well as the hot upgrade function of the graphic client MXUI.

1 MatrixDB 4 small version upgrade

Small version upgrade refers to upgrading to a new version under the premise that the main version number remains unchanged. For example: upgrade from 4.0.0 to 4.0.2; upgrade from 4.0.0 to 4.1.0.

Below, take the example of upgrading from MatrixDB 4.6.0 to 4.8.0 to introduce detailed steps. In the example, the master node name is mdw.

1.1 Get the latest installation package

Obtain the 4.8.0 installation package from the official website, matrixdb-4.8.0.enterprise-1.el7.x86_64.rpm and copy it to all nodes.

1.2 Stop the cluster

Switch to mxadmin user.

[<username>@mdw ~]$ sudo su - mxadmin

Stop the cluster.

[mxadmin@mdw ~]$ gpstop -af

1.3 Execute update commands on all nodes

Upgrade RPM packages with root permissions:

[<username>@mdw ~]$ sudo yum upgrade matrixdb-4.8.0.enterprise-1.el7.x86_64.rpm

Notes!
Do not use yum erase, otherwise the configuration of the previous version will be deleted.

1.4 Restart the service

[<username>@mdw ~]$ sudo systemctl restart matrixdb.supervisor.service

1.5 Modify the configuration and restart the cluster (4.3.10 and later versions can be skipped)

Log in to the Master host and switch to the mxadmin user.

[<username>@mdw ~]$ sudo su - mxadmin

Start the cluster first, add the mars plugin to the shared_preload_libraries configuration and restart.

[mxadmin@mdw ~]$ gpstart -a
[mxadmin@mdw ~]$ gpconfig -c shared_preload_libraries -v "matrixts,matrixmgr,matrixgate,telemetry,mars"
[mxadmin@mdw ~]$ gpstop -arf

Notes!
The value of shared_preload_libraries needs to be added to MARS based on the original configuration.

1.6 Upgrade Plugin

If you use the matrixs plug-in and the mars plug-in, connect to the database and upgrade using the following SQL commands:

postgres=# ALTER EXTENSION matrixts UPDATE;
postgres=# ALTER EXTENSION mars UPDATE;

If you use Grafana monitoring, log in to the matrixmgr database, 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');

Notes!
4.5.2 and then there is no need to upgrade the matrixmgr plug-in. 4.6.0 and no need to upgrade the mars plug-in again.

2 Graphic client hot upgrade

Hot upgrade referers to supporting MXUI components to be upgraded independently of the database, allowing you to enjoy the iteration of graphic products faster, with minimal database operations. ![](https://img.ymatrix.cn/ymatrix_home/hot upgrade_1673337474.jpeg)

Click the "Upgrade Version" of the mxadmin user option in the lower left corner of the graphic interface. After obtaining the new version of the MXUI executable file, you can perform hot upgrades.