Build a high-availability MySQL cluster with dual VIP

1. Project Description:

2. Project Environment:

8 servers (2G, 2 cores), centos7.8
mysql5.7.30 mysqlrouter8.0.21
keepalived2.0.10 zabbix ansible

2. Project steps:

3. Project concept map:

4. Deploy the zabbix monitoring system

4.1 Preparation:

Deploy a Zabbix monitoring server and a monitored host to prepare for further specific monitoring tasks:

Install LNMP environment

Install Zabbix from source

Install the monitoring host and modify the basic configuration

Initialize Zabbix monitoring web page

Modify the PHP configuration file to meet Zabbix requirements

Install the monitored host and modify the basic configuration

Use a RHEL7 virtual machine to install and deploy the LNMP environment, Zabbix and related dependency packages, configure the database and initialize the Zabbix monitoring platform. Use two monitored terminals and install Zabbix Agent from source code. To complete the Zabbix experiment, we need to build an experimental environment. The topology is shown in Table 1.

Table 1 Experimental topology

4.2 Steps:

Step 1: Deploy monitoring server

1) Install the LNMP environment

The Zabbix monitoring management console needs to be displayed through a web page and MySQL needs to be used to store data, so you need to prepare a basic LNMP environment for Zabbix first.

2) Modify the Nginx configuration file

Configure Nginx to support PHP dynamic websites. Because there are a large number of PHP scripts that need to be executed, it is also necessary to enable various fastcgi caches of Nginx to speed up the execution of PHP scripts.

3) Start the service

Start Nginx, PHP-FPM, and MariaDB services, and disable SELinux and firewall.

4) Client test LNMP environment

The server creates a PHP test page, and the browser accesses the page to test web connectivity.

Step 2: Deploy monitoring server Zabbix Server 1) Install Zabbix Server from source code

Most source code packages require dependent packages, and the same is true for zabbix. Before compiling the source code, you need to install the relevant dependent packages.

2) Initialize Zabbix

Create a database and launch the Zabbix web page

Tip: If the service cannot be started due to an incorrect configuration file, do not execute zabbix_server again.
Be sure to shut down the service using killall zabbix_server and then restart it.
Modify the Zabbix_agent configuration file and start the Zabbix_agent service

Tip: If the service cannot be started due to an incorrect configuration file, do not execute zabbix_agentd again.

Be sure to use killall zabbix_agentd to shut down the service and then restart it.
Browser accesses the web page of the Zabbix_server server

After modifying the PHP configuration file, use the browser to access the server again
The following prompt message will be displayed.

Note: There is no problem with a PHP LDAP warning status!
On the Initialize Database page, fill in the database related parameters as shown in the figure.

On the login page, log in with the user (admin) and password (zabbix)
After logging in, set the language environment to Chinese, as shown in the figure.

Step 3: Deploy Zabbix Agent on the monitored host 1) Install Zabbix agent software from source code

Do the same operation in 2.100 and 2.200 (taking zabbixclient_web1 as an example).

2) Modify the agent configuration file and start the Agent

3) Copy the startup script (optional)

There are startup scripts to facilitate the management of services, starting and shutting down services

The startup script is located in the zabbix source directory

5. Project experience:

1. Be sure to plan the architecture of the entire cluster, configure carefully, prepare scripts in advance, and modify them as you go.

2. Firewall and selinux issues need more attention

3. Have a deep understanding of MySQL clustering and high availability

4. More applications and understanding of automated batch deployment and monitoring

5. Keepalived configuration requires more carefulness and IP address planning has a new understanding

6. For the use of dual VIP, add 2 load balancing records to implement DNS polling to achieve the diversion to 2 VIP load balancers

This is the end of this article about building a high-availability MySQL cluster with dual VIPs. For more relevant high-availability MySQL cluster content, please search for previous articles on 123WORDPRESS.COM or continue to browse the following related articles. I hope everyone will support 123WORDPRESS.COM in the future!