主从复制集群:
1、mysql主
1.1 开启二进制文件:
[root@localhost ~]
[mysqld]
log_bin
server-id=1
gtid_mode=ON
enforce_gtid_consistency=1
1.2 重启服务:
[root@localhost ~]
1.3 进入数据库,为从服务器授权
[root@localhost ~]
mysql> grant replication slave,replication client on *.* to 'rep'@'IP或网段'
identified by'123';
mysql> flush privileges;
mysql> flush privileges;
2、mysql从
2.1 测试rep用户是否可用:
[root@localhost ~]
2.2 启动服务序:
[root@localhost ~]
[mysqld]
log_bin
server-id=2
gtid_mode=ON
enforce_gtid_consistency=1
2.3 重启服务:
[root@localhost ~]
2.4 再次测试rep用户是否可用:
[root@localhost ~]
2.5 从设备上设置主服务
81. 关系型数据库原则:ACID(注:数据库事务通常指对数据库进行读或写的一个操作序列)
mysql> change master to master_host='mysql主
IP',master_user='rep',master_password='123',master_auto_position=1;(自动获取)
3、主主、多从
高可用:
3.1 mysql主主同步
3.2 在两台mysql上安装keepalived:
[root@localhost ~]
3.3 keepalived主备配置文件:
[root@localhost ~]
! Configuration File for keepalived
global_defs {
router_id mysql1
}
vrrp_scriptcheck_run{
check_run
script "python/root/keepalived_check_mysql.sh"
interval 5
}
vrrp_instance VI_1 {
state MASTER
interface ens33
virtual_router_id 88
priority 100
advert_int 1
authentication {
auth_type PASS
auth_pass 1111
}
track_script{
check_run
}
virtual_ipaddress {
192.168.122.100devens33
}
}
3.4 编写mysql状态检测脚本(主主):
[root@localhost ~]
[root@localhost ~]
[root@localhost ~]
3.5 测试及诊断