mysql主主加keepalived

---------主主-------
yum -y install mysql mysql-server
service mysqld start
service iptables stop
setenforce 0
vim /etc/my.cnf
log-bin=mysql-bin
server-id=1
relay_log=relaylogs
service mysqld restart
mysql
grant all on . to ‘tongbu’@‘192.168.71.%’ identified by ‘123’;
flush privileges;
reset master;
show master status;
去第二台
yum -y install mysql mysql-server
service mysqld start
service iptables stop
setenforce 0
vim /etc/my.cnf
log-bin=mysql-bin
server-id=2
relay_log=relaylogs
service mysqld restart
mysql
grant all on . to ‘tongbu’@‘192.168.71.%’ identified by ‘123’;
flush privileges;
reset master;
show master status;
第一台
change master to
master_host=‘192.168.71.150’,
master_user=‘tongbu’,
master_password=‘123’,
master_log_file=‘mysql-bin.000001’,
master_log_pos=106;
start slave;
show slave status \G;
第二台
change master to
master_host=‘192.168.71.147’,
master_user=‘tongbu’,
master_password=‘123’,
master_log_file=‘mysql-bin.000001’,
master_log_pos=106;
start slave;
show slave status \G;
然后一建库
create database wg charset utf8；
二去查然后建表
create table student(name varchar(20),
sudject varchar(20),
fs int(50));
一去插入数据
insert student values(“张三”,“语文”,80);
select * from student;
-----------keepalived--------------
yum -y install keepalived
vim /etc/keepalived/keepalived.conf
第一台
17行改成自己的eth1
26行改成vip自己网段的
30行改成自己的vip和3306
38行改成自己的ip和3306
40行改成TCP_CHECK
下面的删了看到connect就停
在下面加上connect_port 3306
service keepalived start
ip addr
第二台上
16行改成 BACKUP
17行改成自己的eth2
19改的比主上的小1就行了99
26行改成跟上面那个vip一样
30行改成自己的vip和3306
38行改成自己的ip和3306
40行改成TCP_CHECK
在下面加上connect_port 3306
service keepalived start
第一台
ip addr show dev eth1
第二台
ip addr show dev eth2
第一台关闭他就会跑到第二台
service keepalived stop