温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

Keepalived+Mysql如何配置主主复制

发布时间:2021-11-06 11:43:47 来源:亿速云 阅读:120 作者:小新 栏目:MySQL数据库

小编给大家分享一下Keepalived+Mysql如何配置主主复制,相信大部分人都还不怎么了解,因此分享这篇文章给大家参考一下,希望大家阅读完这篇文章后大有收获,下面让我们一起去了解一下吧!

安装环境:

HostnameIPvirtual IP
D2-TYMYSQL51192.168.12.51192.168.12.50
D2-TYMYSQL52192.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如何配置主主复制”这篇文章的所有内容,感谢各位的阅读!相信大家都有了一定的了解,希望分享的内容对大家有所帮助,如果还想学习更多知识,欢迎关注亿速云行业资讯频道!

向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI