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

90 Lord 91 Lord

|

|

|

------------------------------

| |

| |

| |

92 from 93 from

systemctl stop firewalld.service ;systemctl disable firewalld.service ;setenforce 0

MySQL-mmm

I. Configuration of master-slave synchronization structure

1) Configure master-slave synchronization

90: User Configuration Enable binlog Log Restart Database Service Specify primary database server information

91: User Configuration Enable binlog logging Allow cascading replication Restart database service Specify primary database server information

[root@pc91 ~]# vim /etc/my.cnf

[mysqld]

validate_password_policy=0

validate_password_length=6

server_id=91

log-bin=master91

binlog_format="mixed"

log_slave_updates

-> grant replication slave on *.* to slaveuser@"%" identified by '123456';

-> change master to

-> master_host="master server ip address",

-> master_user="authorized user name",

-> master_password="authorized user password",

-> master_log_file="binlog in use by master server",

-> master_log_pos= current offset of master service;

#Specify primary server

2) Configure a master multi-slave structure

92: Specify server_id Restart database service Specify primary database server information

93: Specify server_id Restart database service Specify primary database server information

[root@pc92 ~]# vim /etc/my.cnf

[mysqld]

validate_password_policy=0

validate_password_length=6

server_id=92

-> change master to

-> master_host="master server ip address",

-> master_user="authorized user name",

-> master_password="authorized user password",

-> master_log_file="binlog in use by master server",

-> master_log_pos= current offset of master service;

#Specify primary server

mysql> show master status\G;

mysql> start slave;

mysql> show slave status\G;

3) Test master-slave synchronization configuration on client side

a、

Add a user guser to access data on 90 hosts, and you can have the same authorized users on the other 3 hosts

-> grant select on gamedb.* to guser@'%' identified by '123456';

b、

The client host 94 uses the authorized user guser to connect to the server 14, and the new data generated is also available on his 3 hosts.

-> select user,host from mysql.user where user="guser";

II. Configuration mysql-mmm

1) Introduction to mysql-mmm

Monitoring service: runs on management node to monitor data node

Proxy service: runs on the data node to provide the system to the monitoring host

2) Install mysql-mmm software (90-94) on all hosts

#yum -y install perl-*

#unzip mysql-mmm.zip

#cd mysql-mmm

#make install

#ls /etc/mysql-mmm/*.conf

3) Modify configuration file

a Modify Data Node Proxy Service Profile (90 91 92 93)

vim /etc/mysql-mmm/mmm_agent.conf

include mmm_command.conf

this custom name

b Modify the profile of the management node monitoring service (94)

vim /etc/mysql-mmm/mmm_mon.conf

>

include mmm_common.conf

ip 192.168.4.94 IP

pid_path /var/run/mmm_mond.pid

bin_path /usr/lib/mysql-mmm/

status_path /var/lib/misc/mmm_mond.status

ping_ips 192.168.4.90, 192.168.4.91, 192.168.4.93 server IP 192.168.4.92

monitor_user monitor //user name used when monitoring status

monitor_password 123456 //User password used when monitoring status

>

C. Modification of public documents

vim /etc/mysql-mmm/mmm_command.conf

>

active_master_role writer

cluster_interface eth0

pid_path /var/run/mmm_agentd.pid

bin_path /usr/lib/mysql-mmm/

replication_user slaveuser //Set the user for master-slave synchronization

replication_password 123456 //Set master-slave synchronization user password

agent_user agent //control database user

agent_password 123456 //Control database user password

//Set the first master server

ip 192.168.4.90

mode master

peer db91 //Specify another primary server

//Set up the second primary server

ip 192.168.4.91

mode master

peer db90

//set slave server

ip 192.168.4.92

mode slave

//set slave server

ip 192.168.4.93

mode slave

//Specify the main server VIP address

hosts db90, db91

ips 192.168.4.100

mode exclusive

//Specify the slave server VIP address

hosts db92, db93

ips 192.168.4.101, 192.168.0.102

mode balanced

>

d Add the corresponding authorized user to the data node host according to the configuration file setting

-> grant replication client on *.* to monitor@'%' identified by '123456';

-> grant replication client,process,super on *.* to agent@'%' identified by '123456';

-> select user,host from mysql.user where user in ("monitor","agent");

4) Start-up service

a Start proxy service on data node host: mmm_agent

install services run dependent packages install get vip address packages arp_net start services

[root@pc90 ~]# /etc/init.d/mysql-mmm-agent start

[root@pc90 ~]# netstat -pantu | grep 9989

b Start monitoring service on management node host: mmm_mond

Installation Services Running Dependent Packages Startup Services

[root@pc94 ~]# /etc/init.d/mysql-mmm-monitor start

[root@pc94 ~]# netstat -pantu | grep 9988

III. Verify mysql-mmm configuration

a Check whether database services are running on database nodes

[root@pc94 ~]# systemctl status mysqld

b IO threads and SQL threads are both Yes

mysql> show slave status\G;

c View the status of the database server in the login management interface of the monitoring server.

[root@pc94 ~]# mmm_control show

defined(@array) is deprecated at /usr/share/perl5/vendor_perl/Log/Log4perl/Config.pm line 863.

(Maybe you should just omit the defined()?)

db90(192.168.4.90) master/AWAITING_RECOVERY. Roles:

db91(192.168.4.91) master/AWAITING_RECOVERY. Roles:

db92(192.168.4.92) slave/AWAITING_RECOVERY. Roles:

db93(192.168.4.93) slave/AWAITING_RECOVERY. Roles:

[root@pc94 ~]# mmm_control set_online db90

[root@pc94 ~]# mmm_control show

defined(@array) is deprecated at /usr/share/perl5/vendor_perl/Log/Log4perl/Config.pm line 863.

(Maybe you should just omit the defined()?)

db90(192.168.4.90) master/ONLINE. Roles: writer(192.168.4.100)

db91(192.168.4.91) master/ONLINE. Roles:

db92(192.168.4.92) slave/ONLINE. Roles: reader(192.168.0.102)

db93(192.168.4.93) slave/ONLINE. Roles: reader(192.168.4.101)

[root@pc94 ~]# mmm_control show

defined(@array) is deprecated at /usr/share/perl5/vendor_perl/Log/Log4perl/Config.pm line 863.

(Maybe you should just omit the defined()?)

db90(192.168.4.90) master/ONLINE. Roles: writer(192.168.4.100)

db91(192.168.4.91) master/HARD_OFFLINE. Roles:

db92(192.168.4.92) slave/ONLINE. Roles: reader(192.168.0.102)

db93(192.168.4.93) slave/ONLINE. Roles: reader(192.168.4.101)

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.