Keepalived+Mysql如何配置主主复制
小编给大家分享一下Keepalived+MySQL如何配置主主复制,相信大部分人都还不怎么了解,因此分享这篇文章给大家参考一下,希望大家阅读完这篇文章后大有收获,下面让我们一起去了解一下吧!
创新互联公司是专业的上街网站建设公司,上街接单;提供成都网站设计、做网站,网页设计,网站设计,建网站,PHP网站建设等专业做网站服务;采用PHP框架,可快速的进行上街网站开发网页制作和功能扩展;专业做搜索引擎喜爱的网站,专业的做网站团队,希望更多企业前来合作!
安装环境:
Hostname | IP | virtual IP |
D2-TYMYSQL51 | 192.168.12.51 | 192.168.12.50 |
D2-TYMYSQL52 | 192.168.12.52 |
软件包:
keepalived-1.3.5.tar.gz
mysql-5.7.16-linux-glibc2.5-x86_64.tar.gz
节点51部署
(1)环境确认
[root@D2-TYMYSQL51 ~]# cat /etc/centos-release
CentOS Linux release 7.2.1511 (Core)
[root@D2-TYMYSQL51 ~]# hostnamectl status
Static hostname: D2-TYMYSQL51
Icon name: computer-vm
Chassis: vm
Machine ID: 4ff908d829c546f8a037b61638b50e43
Boot ID: 43cbb3326cd646f9aaa40b63c77384b5
Virtualization: vmware
Operating System: CentOS Linux 7 (Core)
CPE OS Name: cpe:/o:centos:centos:7
Kernel: Linux 3.10.0-327.el7.x86_64
Architecture: x86-64
[root@D2-TYMYSQL51 ~]# cat /etc/hosts
192.168. D2-
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.12.51 D2-TYMYSQL51
[root@D2-TYMYSQL51 ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
Active: inactive (dead)
[root@D2-TYMYSQL51 ~]# getenforce
Disabled
(2)安装数据库
参考http://blog.itpub.net/28536251/viewspace-2138854/安装Mysql,注意目录的位置。
[root@D2-TYMYSQL51 ~]# ps -ef | grep mysql
root 31799 1 0 11:16 pts/0 00:00:00 /bin/sh /opt/mysql/bin/mysqld_safe --datadir=/opt/mysql/data --pid-file=/opt/mysql/data/D2-TYMYSQL51.pid
mysql 32214 31799 37 11:16 pts/0 00:00:10 /opt/mysql/bin/mysqld --basedir=/opt/mysql --datadir=/opt/mysql/data --plugin-dir=/opt/mysql/lib/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/opt/mysql/data/D2-TYMYSQL51.pid
root 32754 30568 0 11:17 pts/0 00:00:00 grep --color=auto mysql
[root@D2-TYMYSQL51 ~]# rm -fr /opt/mysql/data/auto.cnf
[root@D2-TYMYSQL51 ~]# /etc/init.d/mysqld restart
Shutting down MySQL. SUCCESS!
Starting MySQL.. SUCCESS!
(3)主从配置
[root@D2-TYMYSQL51 ~]# vim /etc/my.cnf
[root@D2-TYMYSQL51 ~]# cat /etc/my.cnf
[mysqld]
server-id = 1251
character-set-server=utf8
binlog_format=mixed
log-bin=/opt/mysql/log/binlog
binlog-ignore-db=mysql,information_schema
auto-increment-increment=2
auto-increment-offset=1
slave-skip-errors=all
relay-log-index = /opt/mysql/log/relaylog
relay-log-info-file = /opt/mysql/log/relaylog
relay-log = /opt/mysql/log/relaylog
slow-query-log
long_query_time=3
log-output=TABLE
expire_logs_days = 7
basedir=/opt/mysql
datadir=/opt/mysql/data
event_scheduler=1
innodb_file_per_table=1
innodb_log_file_size=536870912
innodb_buffer_pool_size=1073741824
max_binlog_size=1073741824
log_bin_trust_function_creators=1
innodb_stats_on_metadata=0
max_connect_errors = 1000000
max_connections = 5000
skip_name_resolve = 1
symbolic-links=0
[mysql]
default-character-set=utf8
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[root@D2-TYMYSQL51 ~]# /etc/init.d/mysqld restart
Shutting down MySQL. SUCCESS!
Starting MySQL.. SUCCESS!
[root@D2-TYMYSQL51 ~]# /opt/mysql/bin/mysql -uroot -p123456
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.6.22-log Source distribution
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show master status;
+---------------+----------+--------------+--------------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+---------------+----------+--------------+--------------------------+-------------------+
| binlog.000003 | 120 | | mysql,information_schema | |
+---------------+----------+--------------+--------------------------+-------------------+
1 row in set (0.00 sec)
mysql> grant replication slave on *.* to 'replication'@'192.168.12.%' identified by 'replication';
Query OK, 0 rows affected (0.00 sec)
mysql> grant replication slave on *.* to 'root'@'192.168.12.%' identified by '123456';
Query OK, 0 rows affected (0.00 sec)
mysql> grant all privileges on *.* to 'root'@'192.168.12.%' identified by '123456' with grant option;
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> change master to master_host='192.168.12.52',master_user='replication',master_password='replication',master_log_file='binlog.000003',master_log_pos=637;
Query OK, 0 rows affected, 2 warnings (0.00 sec)
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.12.52
Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: binlog.000004
Read_Master_Log_Pos: 120
Relay_Log_File: relaylog.000005
Relay_Log_Pos: 280
Relay_Master_Log_File: binlog.000004
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 120
Relay_Log_Space: 606
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1252
Master_UUID: e3b13736-7258-11e5-b726-005056a70ab8
Master_Info_File: /opt/mysql/data/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
1 row in set (0.00 sec)
(4)主从测试
主库:
mysql> create database test;
Query OK, 1 row affected (0.00 sec)
mysql> use test;
Database changed
mysql> create table usr(number int(10),name varchar(255));
Query OK, 0 rows affected (0.01 sec)
mysql> insert into usr values(01,'aa');
Query OK, 1 row affected (0.00 sec)
从库:
mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| usr |
+----------------+
1 row in set (0.00 sec)
mysql> select * from usr;
+--------+------+
| number | name |
+--------+------+
| 1 | aa |
+--------+------+
1 row in set (0.00 sec)
确认同步正常后删除测试数据库:
mysql> drop database test;
Query OK, 1 row affected (0.00 sec)
(5)安装keepalived
[root@D2-TYMYSQL51 ~]# yum install -y pcre-devel openssl-devel popt-devel gcc
[root@D2-TYMYSQL51 ~]# tar -xvzf keepalived-1.3.5.tar.gz
[root@D2-TYMYSQL51 ~]# cd keepalived-1.3.5/
[root@D2-TYMYSQL51 keepalived-1.3.5]# ./configure --prefix=/usr/local/keepalived
[root@D2-TYMYSQL51 keepalived-1.3.5]# make && make install
[root@D2-TYMYSQL51 keepalived-1.3.5]# cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/
[root@D2-TYMYSQL51 keepalived-1.3.5]# mkdir /etc/keepalived
[root@D2-TYMYSQL51 keepalived-1.3.5]# cp /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/
[root@D2-TYMYSQL51 keepalived-1.3.5]# cp /usr/local/keepalived/sbin/keepalived /usr/sbin/
[root@D2-TYMYSQL51 keepalived-1.3.5]# vim /etc/keepalived/keepalived.conf
[root@D2-TYMYSQL51 keepalived-1.3.5]# cat /etc/keepalived/keepalived.conf
! Configuration File for keepalived
global_defs {
notification_email {
acassen@firewall.loc
failover@firewall.loc
sysadmin@firewall.loc
}
notification_email_from Alexandre.Cassen@firewall.loc
smtp_server 127.0.0.1
smtp_connect_timeout 30
router_id mysql01
}
vrrp_instance mysql01 {
state BACKUP
interface eno16777984
virtual_router_id 50
priority 100
advert_int 5
nopreempt
authentication {
auth_type PASS
auth_pass 123456
}
virtual_ipaddress {
192.168.12.50
}
}
virtual_server 192.168.12.50 3306 {
delay_loop 2
lb_algo wrr
lb_kind DR
persistence_timeout 60
protocol TCP
real_server 192.168.12.51 3306 {
weight 3
notify_down /usr/local/keepalived.sh
TCP_CHECK {
connect_timeout 10
nb_get_retry 3
delay_before_retry 3
connect_port 3306
}
}
}
[root@D2-TYMYSQL51 keepalived-1.3.5]# vim /usr/local/keepalived.sh
[root@D2-TYMYSQL51 keepalived-1.3.5]# cat /usr/local/keepalived.sh
#!/bin/bash
pkill keepalived
[root@D2-TYMYSQL51 keepalived-1.3.5]# chmod +x /usr/local/keepalived.sh
[root@D2-TYMYSQL51 keepalived-1.3.5]# /usr/local/keepalived/sbin/keepalived -D -d -S 0
[root@D2-TYMYSQL51 keepalived-1.3.5]# ps -ef | grep keepalived
root 17727 1 0 16:07 ? 00:00:00 /usr/local/keepalived/sbin/keepalived -D -d -S 0
root 17728 17727 0 16:07 ? 00:00:00 /usr/local/keepalived/sbin/keepalived -D -d -S 0
root 17729 17727 0 16:07 ? 00:00:00 /usr/local/keepalived/sbin/keepalived -D -d -S 0
root 17745 10101 0 16:08 pts/0 00:00:00 grep --color=auto keepalived
节点52部署
(1)环境确认
[root@D2-TYMYSQL52 ~]# cat /etc/centos-release
CentOS Linux release 7.2.1511 (Core)
[root@D2-TYMYSQL52 ~]# hostnamectl status
Static hostname: D2-TYMYSQL52
Icon name: computer-vm
Chassis: vm
Machine ID: 4ff908d829c546f8a037b61638b50e43
Boot ID: 458ee453a718418daf05dea5cac4788b
Virtualization: vmware
Operating System: CentOS Linux 7 (Core)
CPE OS Name: cpe:/o:centos:centos:7
Kernel: Linux 3.10.0-327.el7.x86_64
Architecture: x86-64
[root@D2-TYMYSQL52 ~]# cat /etc/hosts
192.168. D2-
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.12.52 D2-TYMYSQL52
[root@D2-TYMYSQL52 ~]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
Active: inactive (dead)
[root@D2-TYMYSQL52 ~]# getenforce
Disabled
(2)数据库安装
参考http://blog.itpub.net/28536251/viewspace-2138854/安装Mysql,注意目录的位置。
[root@D2-TYMYSQL52 ~]# ps -ef | grep mysql
root 728 30967 0 11:28 pts/0 00:00:00 grep --color=auto mysql
root 32212 1 0 11:28 pts/0 00:00:00 /bin/sh /opt/mysql/bin/mysqld_safe --datadir=/opt/mysql/data --pid-file=/opt/mysql/data/D2-TYMYSQL52.pid
mysql 32627 32212 33 11:28 pts/0 00:00:10 /opt/mysql/bin/mysqld --basedir=/opt/mysql --datadir=/opt/mysql/data --plugin-dir=/opt/mysql/lib/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/opt/mysql/data/D2-TYMYSQL52.pid
(3)主从配置
[root@D2-TYMYSQL52 ~]# vim /etc/my.cnf
[root@D2-TYMYSQL52 ~]# cat /etc/my.cnf
[mysqld]
server-id = 1252
character-set-server=utf8
binlog_format=mixed
log-bin=/opt/mysql/log/binlog
binlog-ignore-db=mysql,information_schema
auto-increment-increment=2
auto-increment-offset=2
slave-skip-errors=all
relay-log-index = /opt/mysql/log/relaylog
relay-log-info-file = /opt/mysql/log/relaylog
relay-log = /opt/mysql/log/relaylog
slow-query-log
long_query_time=3
log-output=TABLE
expire_logs_days = 7
basedir=/opt/mysql
datadir=/opt/mysql/data
event_scheduler=1
innodb_file_per_table=1
innodb_log_file_size=536870912
innodb_buffer_pool_size=1073741824
max_binlog_size=1073741824
log_bin_trust_function_creators=1
innodb_stats_on_metadata=0
max_connect_errors = 1000000
max_connections = 5000
skip_name_resolve = 1
symbolic-links=0
[mysql]
default-character-set=utf8
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
[root@D2-TYMYSQL52 ~]# /etc/init.d/mysqld restart
Shutting down MySQL.. SUCCESS!
Starting MySQL.. SUCCESS!
[root@D2-TYMYSQL52 ~]# /opt/mysql/bin/mysql -uroot -p123456
Warning: Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 2
Server version: 5.6.22-log Source distribution
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> grant replication slave on *.* to 'replication'@'192.168.12.%' identified by 'replication';
Query OK, 0 rows affected (0.00 sec)
mysql> grant replication slave on *.* to 'root'@'192.168.12.%' identified by '123456';
Query OK, 0 rows affected (0.00 sec)
mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)
mysql> show master status;
+---------------+----------+--------------+--------------------------+-------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+---------------+----------+--------------+--------------------------+-------------------+
| binlog.000003 | 637 | | mysql,information_schema | |
+---------------+----------+--------------+--------------------------+-------------------+
1 row in set (0.00 sec)
mysql> change master to master_host='192.168.12.51',master_user='replication',master_password='replication',master_log_file='binlog.000003',master_log_pos=120;
Query OK, 0 rows affected, 2 warnings (0.01 sec)
mysql> start slave;
Query OK, 0 rows affected (0.00 sec)
mysql> show slave status\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.12.51
Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: binlog.000004
Read_Master_Log_Pos: 120
Relay_Log_File: relaylog.000004
Relay_Log_Pos: 280
Relay_Master_Log_File: binlog.000004
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 120
Relay_Log_Space: 1351
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 0
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1251
Master_UUID: baf1f004-3471-11e7-ae2b-0050568a1967
Master_Info_File: /opt/mysql/data/master.info
SQL_Delay: 0
SQL_Remaining_Delay: NULL
Slave_SQL_Running_State: Slave has read all relay log; waiting for the slave I/O thread to update it
Master_Retry_Count: 86400
Master_Bind:
Last_IO_Error_Timestamp:
Last_SQL_Error_Timestamp:
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
1 row in set (0.01 sec)
(4)主从测试
主库:
mysql> create database test;
Query OK, 1 row affected (0.00 sec)
mysql> use test;
Database changed
mysql> create table usr(number int(10),name varchar(255));
Query OK, 0 rows affected (0.00 sec)
mysql> insert into usr values(01,'aa');
Query OK, 1 row affected (0.00 sec)
从库:
mysql> use test
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| usr |
+----------------+
1 row in set (0.00 sec)
mysql> select * from usr;
+--------+------+
| number | name |
+--------+------+
| 1 | aa |
+--------+------+
1 row in set (0.00 sec)
确认同步正常后删除测试数据库:
mysql> drop database test;
Query OK, 1 row affected (0.00 sec)
(5)安装keepalived
[root@D2-TYMYSQL52 ~]# yum install -y pcre-devel openssl-devel popt-devel gcc
[root@D2-TYMYSQL52 ~]# tar -xvzf keepalived-1.3.5.tar.gz
[root@D2-TYMYSQL52 ~]# cd keepalived-1.3.5/
[root@D2-TYMYSQL52 keepalived-1.3.5]# ./configure --prefix=/usr/local/keepalived
[root@D2-TYMYSQL52 keepalived-1.3.5]# make && make install
[root@D2-TYMYSQL52 keepalived-1.3.5]# cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/
[root@D2-TYMYSQL52 keepalived-1.3.5]# mkdir /etc/keepalived
[root@D2-TYMYSQL52 keepalived-1.3.5]# cp /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/
[root@D2-TYMYSQL52 keepalived-1.3.5]# cp /usr/local/keepalived/sbin/keepalived /usr/sbin/
[root@D2-TYMYSQL52 keepalived-1.3.5]# vim /etc/keepalived/keepalived.conf
[root@D2-TYMYSQL52 keepalived-1.3.5]# cat /etc/keepalived/keepalived.conf
! Configuration File for keepalived
global_defs {
notification_email {
acassen@firewall.loc
failover@firewall.loc
sysadmin@firewall.loc
}
notification_email_from Alexandre.Cassen@firewall.loc
smtp_server 127.0.0.1
smtp_connect_timeout 30
router_id mysql01
}
vrrp_instance mysql01 {
state BACKUP
interface eno16777984
virtual_router_id 50
priority 50
advert_int 5
authentication {
auth_type PASS
auth_pass 123456
}
virtual_ipaddress {
192.168.12.50
}
}
virtual_server 192.168.12.50 3306 {
delay_loop 2
lb_algo wrr
lb_kind DR
persistence_timeout 60
protocol TCP
real_server 192.168.12.52 3306 {
weight 3
notify_down /usr/local/keepalived.sh
TCP_CHECK {
connect_timeout 10
nb_get_retry 3
delay_before_retry 3
connect_port 3306
}
}
}
[root@D2-TYMYSQL52 keepalived-1.3.5]# vim /usr/local/keepalived.sh
[root@D2-TYMYSQL52 keepalived-1.3.5]# cat /usr/local/keepalived.sh
#!/bin/bash
pkill keepalived
[root@D2-TYMYSQL52 keepalived-1.3.5]# chmod +x /usr/local/keepalived.sh
[root@D2-TYMYSQL52 keepalived-1.3.5]# /usr/local/keepalived/sbin/keepalived -D -d -S 0
[root@D2-TYMYSQL52 keepalived-1.3.5]# ps -ef | grep keepalived
root 16652 1 0 16:10 ? 00:00:00 /usr/local/keepalived/sbin/keepalived -D -d -S 0
root 16653 16652 0 16:10 ? 00:00:00 /usr/local/keepalived/sbin/keepalived -D -d -S 0
root 16654 16652 0 16:10 ? 00:00:00 /usr/local/keepalived/sbin/keepalived -D -d -S 0
root 16660 11645 0 16:10 pts/0 00:00:00 grep --color=auto keepalived
(6)故障转移测试:
51节点:
[root@D2-TYMYSQL51 keepalived-1.3.5]# ip addr
1: lo: mtu 65536 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eno16777984: mtu 1500 qdisc mq state UP qlen 1000
link/ether 00:50:56:8a:19:67 brd ff:ff:ff:ff:ff:ff
inet 192.168.12.51/24 brd 192.168.12.255 scope global eno16777984
valid_lft forever preferred_lft forever
inet 192.168.12.50/32 scope global eno16777984
valid_lft forever preferred_lft forever
inet6 fe80::250:56ff:fe8a:1967/64 scope link
valid_lft forever preferred_lft forever
客户端发起连接:
[root@D2-EDUMSDB45 ~]# mysql -h 192.168.12.50 -uroot -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1866
Server version: 5.6.22-log Source distribution
Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql>
关闭51节点的mysql:
[root@D2-TYMYSQL51 keepalived-1.3.5]# /etc/init.d/mysqld stop
Shutting down MySQL............ SUCCESS!
查看52节点:
[root@D2-TYMYSQL52 keepalived-1.3.5]# ip addr
1: lo: mtu 65536 qdisc noqueue state UNKNOWN
link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
inet 127.0.0.1/8 scope host lo
valid_lft forever preferred_lft forever
inet6 ::1/128 scope host
valid_lft forever preferred_lft forever
2: eno16777984: mtu 1500 qdisc mq state UP qlen 1000
link/ether 00:50:56:8a:35:9c brd ff:ff:ff:ff:ff:ff
inet 192.168.12.52/24 brd 192.168.12.255 scope global eno16777984
valid_lft forever preferred_lft forever
inet 192.168.12.50/32 scope global eno16777984
valid_lft forever preferred_lft forever
inet6 fe80::250:56ff:fe8a:359c/64 scope link
valid_lft forever preferred_lft forever
45节点进行操作:
mysql> use mysql
No connection. Trying to reconnect...
Connection id: 1289
Current database: *** NONE ***
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Database changed
以上是“Keepalived+Mysql如何配置主主复制”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注创新互联行业资讯频道!
新闻名称:Keepalived+Mysql如何配置主主复制
文章路径:http://pwwzsj.com/article/pjgpdi.html