Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about how to achieve master-master replication in MySQL. Many people may not know much about it. In order to make you understand better, the editor has summarized the following content for you. I hope you can get something according to this article.

1 Machine Planning 192.168.6.119keepalive+ipvsadm (Lvs)

192.168.6.121keepalive+ipvsadm (Lvs)

192.168.6.66VIP

192.168.6.114 real machine (testing httpd load balancing), lvs client

192.168.6.115 real machine (testing httpd load balancing), lvs client

It's needed on 114.115.

[root@node1 ~] # more / usr/local/bin/lvs_real

#! / bin/bash

# description: start realserver

VIP=192.168.6.66

/ etc/rc.d/init.d/functions

Case "$1" in

Start)

Echo "start LVS of REALServer"

/ sbin/ifconfig lo:0$ VIP broadcast $VIP netmask 255.255.255.255 up

Echo "1" > / proc/sys/net/ipv4/conf/lo/arp_ignore

Echo "2" > / proc/sys/net/ipv4/conf/lo/arp_announce

Echo "1" > / proc/sys/net/ipv4/conf/all/arp_ignore

Echo "2" > / proc/sys/net/ipv4/conf/all/arp_announce

Stop)

/ sbin/ifconfig lo:0 down

Echo "close LVS Directorserver"

Echo "0" > / proc/sys/net/ipv4/conf/lo/arp_ignore

Echo "0" > / proc/sys/net/ipv4/conf/lo/arp_announce

Echo "0" > / proc/sys/net/ipv4/conf/all/arp_ignore

Echo "0" > / proc/sys/net/ipv4/conf/all/arp_announce

*)

Echo "Usage: $0 {start | stop}"

Exit 1

Esac

Start client script

[root@node1 ~] # sh / usr/local/bin/lvs_real start

4 the server keepalive configuration file is as follows

119 121 machines (master / slave modify key points are fine)

[root@localhost keepalived] # more keepalived.conf

# writed by sery, contact sery@163.com

# guration File for keepalived

# global define

Global_defs {

Router_id LVS_CNC_1

}

Vrrp_sync_group VGM {

Group {

VI_CACHE

}

}

#

# vvrp_instance define #

#

Vrrp_instance VI_CACHE {

State MASTER

Interface eth0

Lvs_sync_daemon_inteface eth0

Virtual_router_id 51

Priority 180

Advert_int 5

Authentication {

Auth_type PASS

Auth_pass 1111

}

Virtual_ipaddress {

192.168.6.66

}

}

# # #

# virtual machine setting #

# # #

# setting port 80 forward

Virtual_server 192.168.6.66 80 {

Delay_loop 6

Lb_algo wlc

Lb_kind DR

# persistence_timeout 20

Protocol TCP

Real_server 192.168.6.114 80 {

Weight 100

TCP_CHECK {

Connect_timeout 3

Nb_get_retry 3

Delay_before_retry 3

Connect_port 80

}

}

Real_server 192.168.6.115 80 {

Weight 100

TCP_CHECK {

Connect_timeout 3

Nb_get_retry 3

Delay_before_retry 3

Connect_port 80

}

}

}

Start keepalive

[root@localhost ~] # / etc/init.d/keepalived start

Check the ipvsadm situation

[root@localhost keepalived] # ipvsadm-ln

IP Virtual Server version 1.2.1 (size=4096)

Prot LocalAddress:Port Scheduler Flags

-> RemoteAddress:Port Forward Weight ActiveConn InActConn

TCP 192.168.6.66:80 wlc

-> 192.168.6.115 Route 80 100

-> 192.168.6.114 Route 80 100

After reading the above, do you have any further understanding of how to achieve master-master replication in MySQL? If you want to know more knowledge or related content, please follow the industry information channel, thank you for your support.

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.