外语网站建设,网站建设管理人员工作职责,网站免费域名申请,绥化市住房和城乡建设网网站一.设置mysql同步信息两节点安装msyql略#配置节点11.配置权限允许远程访问mysql -u root -p
grant all on *.* to root% identified by Root1212# with grant option;
flush privileges;2.修改my.cnf#作为主节点配置(节点1)#作为主节点配置
server-id 1 …一.设置mysql同步信息两节点安装msyql略#配置节点11.配置权限允许远程访问mysql -u root -p
grant all on *.* to root% identified by Root1212# with grant option;
flush privileges;2.修改my.cnf#作为主节点配置(节点1)#作为主节点配置
server-id 1 #节点ID
log_bin mysql-bin.log #日志
binlog_format ROW #日志格式
auto_increment_increment 2 #自增ID间隔(节点数防止ID冲突)
auto_increment_offset 1 #自增ID起始值(节点ID)
#binlog_ignore_dbmysql #不同步的数据库
#binlog_ignore_dbinformation_schema
#binlog_ignore_dbperformance_schema# 作为从节点配置(节点2)mysql修改my.cnfserver-id 2
log_bin mysql-bin.log
relay_log mysql-relay-bin.log #中继日志
log_slave_updates ON #中继日志执行后变化计入日志
read_only 0
binlog_format ROW
auto_increment_increment 2
auto_increment_offset 2
#binlog_ignore_dbmysql
#binlog_ignore_dbinformation_schema
#binlog_ignore_dbperformance_schema
#replicate_ignore_dbmysql
#replicate_ignore_dbinformation_schema
#replicate_ignore_dbperformance_schema3.开启同步节点1mysql -P3306 -hxxx.xxx.xxx.xxx -uroot -p密码
CHANGE MASTER TOMASTER_HOST10.10.16.50,MASTER_USERroot,MASTER_PASSWORDRootsql1212#,MASTER_LOG_FILEmysql-bin.000001,MASTER_LOG_POS2959; MASTER_HOST10.10.16.50 节点2的ip MASTER_USERroot, 节点2的mysql用户名MASTER_PASSWORD密码,节点2的mysql密码 MASTER_LOG_FILEmysql-bin.000014, 和 MASTER_LOG_POS453768;;为节点2同步日志位置。查看节点2的MASTER_LOG_FILE和MASTER_LOG_POS#登录主节点2,mysql
mysql -P3306 -h10.10.16.50 -uroot -pRootsql1212#
show master status节点2配置主从需要暂停同步stop slave如果不暂停同步则无法设置同步信息。mysql -P3306 -hxx.xx.xx.xx -uroot -p密码#暂停同步
stop slave;#同步信息设置
CHANGE MASTER TOMASTER_HOST10.10.16.44,MASTER_USERroot,MASTER_PASSWORD密码,MASTER_LOG_FILEbinlog.000014,MASTER_LOG_POS490354;#开启同步
start slave; MASTER_HOST10.10.16.44 节点1的ip MASTER_USERroot, 节点1的mysql用户名MASTER_PASSWORD密码,节点1的mysql密码MASTER_LOG_FILEbinlog.000014 和 MASTER_LOG_POS490354;为节点1同步日志位置。查看节点1的MASTER_LOG_FILE和MASTER_LOG_POS#登录主节点2,mysql
mysql -P3306 -h10.10.16.40 -uroot -pRootsql1212#
show master status#在mysql里面查看同步状态 Slave_IO_Running和Slave_SQL_Running需要均为Yesshow slave status\G;二.安装keepalived两节点服务器都安装keepalived#编译安装安装依赖sudo apt install gcc # 安装gcc
sudo apt install make # 安装make
sudo apt install libssl-dev # 安装ssl编译依赖文件
sudo apt install libnfnetlink-dev # 安装libnfnetlink-dev
sudo apt install libnl-3-dev # 安装libnl-3-dev
sudo apt install libnl-genl-3-dev # 安装libnl-genl-3-dev安装cd /usr/local
wget https://www.keepalived.org/software/keepalived-2.2.2.tar.gz
tar -zxvf keepalived-2.2.2.tar.gz
mv keepalived-2.2.2 keepalived
cd /usr/local/keepalived
./configure --prefix/usr/local/keepalived
sudo make make install#开启日志sudo vim /etc/rsyslog.d/50-default.conf*.info;*.notice;*.warn;\ auth,authpriv.none;\ cron,daemon.none;\ mail,news.none -/var/log/messages打开日志sudo service rsyslog restart
#查看日志
tail -f /var/log/messages复制文件sudo mkdir /etc/sysconfig
sudo cp /usr/local/keepalived/etc/sysconfig/keepalived /etc/sysconfig/
sudo cp /usr/local/keepalived/sbin/keepalived /sbin/
sudo mkdir /etc/keepalived
sudo cp /usr/local/keepalived/etc/keepalived/keepalived.conf /etc/keepalived/配置节点信息节点1 vim /etc/keepalived/keepalived.confbal_defs {router_id MYSQL_HA #当前节点名
}
vrrp_instance VI_1 {state BACKUP #两台配置节点均为BACKUPinterface enahisic2i0 #绑定虚拟IP的网络接口virtual_router_id 51 #VRRP组名两个节点的设置必须一样以指明各个节点属于同一VRRP组priority 101 #节点的优先级,另一台优先级改低一点advert_int 1 #组播信息发送间隔两个节点设置必须一样nopreempt #不抢占只在优先级高的机器上设置即可优先级低的机器不设置authentication { #设置验证信息两个节点必须一致auth_type PASSauth_pass 123456}virtual_ipaddress { #指定虚拟IP,两个节点设置必须一样192.168.1.111}
}
virtual_server 192.168.1.111 3306 { #linux虚拟服务器(LVS)配置delay_loop 2 #每个2秒检查一次real_server状态lb_algo wrr #LVS调度算法,rr|wrr|lc|wlc|lblc|sh|dhlb_kind DR #LVS集群模式 ,NAT|DR|TUNpersistence_timeout 60 #会话保持时间protocol TCP #使用的协议是TCP还是UDPreal_server 10.10.16.44 3306 {weight 3 #权重notify_down /usr/local/bin/mysql.sh #检测到服务down后执行的脚本TCP_CHECK {connect_timeout 10 #连接超时时间nb_get_retry 3 #重连次数delay_before_retry 3 #重连间隔时间connect_port 3306 #健康检查端口}}
}重启keepalivedsystemctl daemon-reloadservice keepalived restart查看虚拟ipip addr show enahisic2i0节点2vim /etc/keepalived/keepalived.confbal_defs {router_id MYSQL_HA #当前节点名
}
vrrp_instance VI_1 {state BACKUP #两台配置节点均为BACKUPinterface enahisic2i0 #绑定虚拟IP的网络接口virtual_router_id 51 #VRRP组名两个节点的设置必须一样以指明各个节点属于同一VRRP组priority 100 #节点的优先级,另一台优先级改低一点advert_int 1 #组播信息发送间隔两个节点设置必须一样nopreempt #不抢占只在优先级高的机器上设置即可优先级低的机器不设置authentication { #设置验证信息两个节点必须一致auth_type PASSauth_pass 123456}virtual_ipaddress { #指定虚拟IP,两个节点设置必须一样192.168.1.111}
}
virtual_server 192.168.1.111 3306 { #linux虚拟服务器(LVS)配置delay_loop 2 #每个2秒检查一次real_server状态lb_algo wrr #LVS调度算法,rr|wrr|lc|wlc|lblc|sh|dhlb_kind DR #LVS集群模式 ,NAT|DR|TUNpersistence_timeout 60 #会话保持时间protocol TCP #使用的协议是TCP还是UDPreal_server 10.10.16.50 3306 {weight 3 #权重notify_down /usr/local/bin/mysql.sh #检测到服务down后执行的脚本TCP_CHECK {connect_timeout 10 #连接超时时间nb_get_retry 3 #重连次数delay_before_retry 3 #重连间隔时间connect_port 3306 #健康检查端口}}
}重启keepalivedsystemctl daemon-reloadservice keepalived restart查看虚拟ipip addr show enahisic2i0虚拟ip只存在一个节点上测试是否成功mysql -P3306 -h192.168.1.111 -uroot -pRootsql1212#停止其中的一个节点mysql查看ip是否漂移到另一个节点ip addr show enahisic2i0另外mysql是否还可以登录mysql -P3306 -h192.168.1.111 -uroot -pRootsql1212#
