Shulou(Shulou.com)06/01 Report--

Deploy mysql highly clustered mysql-mmm + mysql master-slave synchronization

Environment preparation (four database servers 12 11 10 9)

Systemctl stop firewalld

Setenforce 0

Configure YUM Feed

Yum-y install gcc gcc-c++ perl-*

Systemctl start mysqld

+ +

Configure mysql master-slave synchronization (12 11 10 9)

9 and 10 are configured as the main main structure

12 and 11 slave database servers configured as 10

Requirement: the database tables created when the client accesses database server 9 are recorded at 11 and 12

You have to have it on the board, too.

User authorization:

1 users with synchronous data permissions (9 and 10)

Grant replication slave on *. * to slaveuser@ "%"

Identified by "123456"

Configure 9 and 10 as the main main structure

nine

Vim / etc/my.cnf

[mysqld]

Server_id=9

Log_bin=master9

Binlog_format= "mixed"

: wq

ten

Vim / etc/my.cnf

[mysqld]

Server_id=10

Log_bin=master10

Binlog_format= "mixed"

Log_slave_updates

: wq

nine

Mysql > change master to

Master_host= "192.168.4.10", master_user= "slaveuser"

Master_password= "123456", master_log_file= "master10

.000001 ", master_log_pos=154

Mysql > show slave status\ G

ten

Mysql > change master to

Master_host= "192.168.4.9", master_user= "slaveuser", m

Aster_password= "123456", master_log_file= "master9.00

0001 ", master_log_pos=154

Mysql > show slave status\ G

12 and 11 slave database servers configured as 10

eleven

Vim / etc/my.cnf

[mysqld]

Server_id=11

: wq

twelve

Vim / etc/my.cnf

[mysqld]

Server_id=12

: wq

11 and 12

Mysql > change master to

Master_host= "192.168.4.10", master_user= "slaveuser"

Master_password= "123456", master_log_file= "master10

.000001 ", master_log_pos=154

Mysql > show slave status\ G

Test the registration synchronization configuration:

nine

Mysql > create database gamedb

Mysql > grant all on gamedb.* to stu10@'% 'identified

By "123456"

two hundred and fifty four

Mysql-h292.168.4.9-ustu10-p123456 gamedb

Mysql > create table T1 (id int)

Mysql > insert into T1 values

You can view records and authorized users on the other three database servers

Select user,host from mysql.user where user= "stu10"

Select * from gamedb.t1

2. Configure mysql-mmm

Introduction of mysql-mmm Software

The mmm_monitor monitoring service runs on the monitoring side.

The mmm_agentd proxy service runs on the database server

Ip planning

Write the vip address 192.168.4.100 (9, 10)

Read the vip address 192.168.4.101Purple 102 (11,12)

Configure Monitoring Server 8

Systemctl stop firewalld

Setenforce 0

Configure YUM Feed

Yum-y install gcc gcc-c++ perl-*

Pack (12, 11, 10, 9, 8)

5 unzip mysql-mmm.zip

Cd mysql-mmm/

Tar-zxvf mysql-mmm-2.2.1.tar.gz

Cd mysql-mmm-2.2.1/

Make install

Profile description

Ls / etc/mysql-mmm/

Master profile for the mmm_mon.conf mmm_monitor monitoring service

Mmm_agent.conf mmm_agentd proxy service

Mmm_common.conf public files (monitoring server and database server

All have to have)

Modify the configuration file

1. Modify the master configuration of mmm_agentd proxy service on 4 database servers

File

Vim / etc/mysqlmmm/mmm_agent.conf

Include mmm_common.conf

This hostname # Custom

: wq

2 modify the main configuration file of the mmm_monitor monitoring service on the monitoring server

3 modify public files mmm_common.conf public files

4 on 4 database servers according to the mmm_common.conf configuration file

Add the corresponding authorized user to the settings of

Mysql > grant replication client on *. * to

Monitor@ "%" identified by "123456"

Mysql > grant replication client,process,super on *. * to

Agent@ "%" identified by "123456"

IV. Start the service

4.2 start the agnetd service on the database server

2 rpm-ivh perl-Log-Log4perl-1.26-1.el6.rf.noarch.rpm

4 tar-zxvf Algorithm-Diff-1.1902.tar.gz

6 cd Algorithm-Diff-1.1902/

8 perl Makefile.PL

9 make

10 make install

13 tar-zxvf Proc-Daemon-0.03.tar.gz

14 cd Proc-Daemon-0.03/

16 perl Makefile.PL

17 make

18 make install

21 gunzip Net-ARP-1.0.8.tgz

23 tar-xvf Net-ARP-1.0.8.tar

25 cd Net-ARP-1.0.8/

27 perl Makefile.PL

28 make

29 make install

31 / etc/init.d/mysql-mmm-agent status

32 / etc/init.d/mysql-mmm-agent start

33 netstat-utnalp | grep: 9989

Ls / var/log/mysql-mmm/mmm_agentd.log

4.3 start the monitor service on the monitoring server

2 rpm-ivh perl-Log-Log4perl-1.26-1.el6.rf.noarch.rpm

4 tar-zxvf Algorithm-Diff-1.1902.tar.gz

6 cd Algorithm-Diff-1.1902/

8 perl Makefile.PL

9 make

10 make install

13 tar-zxvf Proc-Daemon-0.03.tar.gz

14 cd Proc-Daemon-0.03/

16 perl Makefile.PL

17 make

18 make install

27 / etc/init.d/mysql-mmm-monitor status

28 / etc/init.d/mysql-mmm-monitor start

29 netstat-utnalp | grep: 9988

30 ls / var/log/mysql-mmm/mmm_mond.log

Log in to the management page of monitoring server 8 to view the status of the database server

# mmm_control help

# mmm_control show

# mmm_control set_online master9

# mmm_control set_online master10

# mmm_control set_online master11

# mmm_control set_online master12

# mmm_control show

View the acquired virtual ip address locally on the database server

# ip addr show | grep 192.168.4.100

Test configuration

254 client access

Ping 192.168.4.100

Mysql-h292.168.4.100-ustu10-p123456 gamedb

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.