Ubuntu 20.04 offline deployment cluster under system

Operating system and platform requirements

Operating System	Supported CPU Architecture
Ubuntu 20.04	amd64

Notes!
This tutorial is limited to 64-bit installation packages. If you need a 32-bit installation package, please prepare it yourself.

Server installation

The server installation process includes 5 steps: viewing the basic server information, installation preparation, database DEB package installation, database deployment and post-installation settings.

1 View basic server information

Before performing the installation operation, check the basic server information first. It is rarely a good habit to understand that a server helps you better plan and deploy a cluster.

Step	Commands*	Purpose*
1	free -h	View operating system memory information
2	df -h	View disk space
3	lscpu	View CPU quantity
4	lsb_release -a	View operating system version information
5	uname -a	Out all kernel information in the following order (where the detection results of -p and -i are omitted if they are agnostic): kernel name; host name on network node; kernel issue number; kernel version; host hardware architecture name; processor type (not portable); hardware platform (not portable); operating system name
6	tail -11 /proc/cpuinfo	View CPU information

2 Installation preparation

Notes!
2 Installation preparation and 3 Database DEB package installation commands must be performed on all nodes.

2.1 Download and unzip offline warehouse packages

First download the offline warehouse compression package from the official website: matrixdb_local_repo_ubuntu20.tar. Copy the compressed package locally onto all nodes.

~ scp <本地文件路径> <用户名>@<服务器 IP 地址>:<服务器文件路径>

Unzip the installation package through root user or using root permissions.

# tar xf matrixdb_local_repo_ubuntu20.tar

After the execution is completed, you can see matrixdb_local_repo in the current directory, which includes the DEB installation package we need.

2.2 Replace the software list

Execute the following command under the root user or with root permissions:

# sudo su
# rm -rf /usr/local/matrixdb_local_repo
# mv matrixdb_local_repo /usr/local
# mv /etc/apt/sources.list /etc/apt/sources.list.bak
# echo "deb [arch=amd64 trusted=yes] file:/usr/local/matrixdb_local_repo ./" > /etc/apt/sources.list
# apt update
# apt upgrade -y

APT (Advanced Package Tool) is an advanced package tool. Its main functions are related to obtaining and installing software packages. You can download software packages, install software packages, analyze software package dependencies, update software lists, etc.

2.3 Regional Language Settings (Locale)

Set the regional language settings under root user or using root permissions.

# sudo apt install -y locales && sudo locale-gen "en_US.UTF-8" && sudo update-locale LC_ALL="en_US.UTF-8"

2.4 Modify the machine configuration

Make sure that there are persistent host names on all nodes. If they do not exist, please use the following command to set the host name. For example, you can set it in the master node like this:

# hostnamectl set-hostname mdw

The two child nodes also set corresponding host names:

# hostnamectl set-hostname sdw1

# hostnamectl set-hostname sdw2

Ensure that all nodes in the cluster can access each other through hostname and IP. Add a record in /etc/hosts and map the host name to a local network card address. For example, the /etc/hosts of the three nodes contain something like this:

192.168.100.10 mdw
192.168.100.11 sdw1
192.168.100.12 sdw2

3 Install the YMatrix DEB package

Install the YMatrix DEB package under the root user or with root permissions.

# sudo apt install -y /path/to/matrixdb5_5.0.0+enterprise-1_amd64.deb

Notes!
During the actual installation process, please replace the file name with the latest downloaded DEB package name. The DEB package download link is obtained from the official email. /path/to/ is replaced with the correct path, and ./ if it is the current path.

After the installation is successful, the supervisor and MXUI processes will be automatically started. These background processes are used to provide graphic operation interfaces and process management services.

If you have the requirement to configure ports, modify the /etc/matrixdb5/defaults.conf file for configuration after installing the DEB package. This operation is only done on the Master.

# vim /etc/matrixdb5/defaults.conf

4 Database Deployment

The graphic deployment provided by YMatrix is still used here. Remote graphic deployment requires server ports 8240 and 4617 to be accessible. After the installation is complete, these ports of all nodes will be opened by default. The graphic UI service is provided by the MXUI process.

Notes!
You cannot deploy YMatrix using a graphic interface, please refer to [Command Line Deployment] (/doc/5.0/faq/install_faq#command_line_install).

Use your browser to access the following graphic installation wizard URL, which is the IP of the mdw server:

http://<IP>:8240/

On the first page of the installation wizard, you need to fill in the super user password and use the sudo more /etc/matrixdb5/auth.conf command to view it. ![](https://img.ymatrix.cn/ymatrix_home/Multi-node deployment 1_1679456181.png)

Select "Multi-node deployment" on the second page and click Next. ![](https://img.ymatrix.cn/ymatrix_home/Multi-node deployment 2_1679456210.png)

Next, start the four steps of multi-machine deployment.

The first step is to add a node and click the "Add Node" button. ![](https://img.ymatrix.cn/ymatrix_home/Multi-node deployment 3_1679456256.png)

Enter the IP addresses or hostname or FQDN of sdw1 and sdw2 in the text box, click "OK", and click "Next". ![](https://img.ymatrix.cn/ymatrix_home/Multi-node deployment 4_1679456230.png)

The second step is to configure cluster parameters. "Data mirroring" determines whether the cluster data node contains backup images. It is recommended to enable it in the production environment so that the cluster is highly available. The system automatically recommends the largest space of disks and the number of segments matching the system resources, which can be adjusted according to the specific usage scenario. The configured cluster structure can be viewed through the schematic diagram. After confirming, click "Next". ![](https://img.ymatrix.cn/ymatrix_home/Multi-node deployment 7_1679456383.png)

The third step is to set the storage path. ![](https://img.ymatrix.cn/ymatrix_home/Multi-node deployment 8_1679456418.png)

Step 4: Execute deployment. This step will list the configuration parameters for the previous operation. After confirming that it is correct, click "Execute deployment". ![](https://img.ymatrix.cn/ymatrix_home/Multi-node deployment 10_1679466593.png)

The system will then automatically deploy the cluster and list detailed steps and execution progress. After all the steps are successfully executed, it means that the deployment is completed. ![](https://img.ymatrix.cn/ymatrix_home/Multi-node deployment 9_1679456463.png)

Complete the deployment. ![](https://img.ymatrix.cn/ymatrix_home/Multi-node deployment 11_1679466566.png)

5 Settings after installation

5.1 Configuring sysstat

On all nodes, modify the sysstat file, change ENABLED="false" to ENABLED="true", then click esc, enter :wq to save and exit.

# sudo vi /etc/default/sysstat

Restart the service.

# sudo service sysstat restart

5.2 Remote connection to the database

YMatrix default installation supports remote connections. If "Allow remote connection to database" is not checked during the installation process, please manually modify the $MASTER_DATA_DIRECTORY/pg_hba.conf file to add a line like this, indicating that users from any IP who access all databases are allowed to connect through password authentication. The IP range or database name can be limited according to actual needs to be used to reduce security risks:

# host all all 0.0.0.0/0 md5

After completing these modifications, you need to execute the following command to reload the pg_hba.conf configuration file:

# mxstop -u

5.3 Using database management tools

The start, stop, restart and status viewing of YMatrix can be completed by the following commands:

Command	Purpose
mxstop -a	Stop the cluster. (In this mode, if there is a session link, closing the database will be stuck)
mxstop -af	Quickly shut down the cluster
mxstop -arf	Restart the cluster. Wait for the currently executing SQL statement to end (in this mode, if there is a session link, closing the database will be stuck)
mxstate -s	View cluster status