mysql keepalived双主_MySQL双主+keepalived实现高可用实现(热备)

ゞ浴缸里的玫瑰 2022-10-31 02:00 156阅读 0赞

环境：centos6.7 最小化安装

192.168.100.152 master 主

192.168.100.153 slave从

192.168.100.132 v\_ip浮动IP

配置ssh密码登录，关闭selinux，关闭防火墙

1、安装mysql

\#yum install mysql\* -y

2、配置mysql配置文件

\#配置/etc/my.cnf

\[mysqld\]

datadir=/var/lib/mysql

socket=/var/lib/mysql/mysql.sock

user=mysql

server-id = 1//这个ID是mysql数据库的唯一标识符

log-bin = mysql-bin

log\_bin\_trust\_function\_creators = 1

binlog\_format = mixed

relay-log = relay-bin

relay-log-index = slave-relay-bin.index

\# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

default-character-set=utf8

\#slave\_skip\_errors = 1146

\#binlog-ignore-db=mysql

\[client\]

default-character-set=utf8

\[mysqld\_safe\]

log-error=/var/log/mysqld.log

pid-file=/var/run/mysqld/mysqld.pid

3、启动mysqld服务(启动mysql数据库)

\#service mysqld start

\#chkconfig mysqld on

4、设置mysql数据库root密码

\#mysqladmin -uroot password '12345678'

4、创建授权用户,配置同步。

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

master上：

mysql>grant replication slave on \*.\* to 'rep'@'192.168.100.153' identified by '12345678';

查看slave上的mysql的master\_log\_file和master\_log\_pos;

master\_log\_file=\`mysql -uroot -p12345678-e "show master status;" | grep mysql | cut -f 1\`

master\_log\_pos=\`mysql -uroot -p12345678 -e "show master status;" | grep mysql | cut -f 2\`

mysql>change master to master\_host='192.168.100.153',master\_user='rep',master\_password='12345678',master\_log\_file="\\'$fsmanager\_log\_file\\'",master\_log\_pos=$fsmanager\_log\_pos;

mysql>start slave;

service mysqld restart

slave上：

mysql>grant replication slave on \*.\* to 'rep'@'192.168.100.152' identified by '12345678';

查看slave上的mysql的master\_log\_file和master\_log\_pos

master\_log\_file=\`mysql -uroot -p12345678 -e "show master status;" | grep mysql | cut -f 1\`

master\_log\_pos=\`mysql -uroot -p12345678 -e "show master status;" | grep mysql | cut -f 2\`

mysql>change master to master\_host='192.168.100.152',master\_user='rep',master\_password='12345678',master\_log\_file="\\'$fsmanager\_log\_file\\'",master\_log\_pos=$fsmanager\_log\_pos;

mysql>start slave;

service mysqld restart

mysql -uroot -p12345678 -e "grant all privileges on \*.\* to 'root'@'v\_ip' identified by '12345678' with grant option;"

mysql -uroot -p12345678 -e "grant all privileges on \*.\* to 'root'@'masterr' identified by '12345678' with grant option;"

\#\#\#\#\#\#\#\#\#\#\#\#\# 配置高可用 \#\#\#\#\#\#\#\#\#

1、安装

\#yum install -y kernel-devel openssl-devel popt-devel keepalived

\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#

master上：

vim /etc/keepalived/keepalived.conf

global\_defs \{

router\_id mysql1