mysql实现高可用架构之MHA

Linux 防火墙、SELinux 的开启和关闭

https://www.cnblogs.com/mdm131452095/p/10026733.html

mysql实现高可用架构之MHA

https://www.cnblogs.com/keerya/p/7883766.html

实战项目——mysql主从架构的实现

https://www.cnblogs.com/keerya/p/7873502.html

Mysql 5.7 CentOS 7 安装MHA

https://www.cnblogs.com/halberd-lee/p/8616851.html

mysql-创建用户报错ERROR 1396 (HY000): Operation CREATE USER failed for 'XXXX'@'XXXX'

https://blog.csdn.net/u011575570/article/details/51438841

该用户已存在了

普通用户ssh免密登陆完美解决(Permission denied (publickey,gssapi-keyex,gssapi-with-mic,password))

https://blog.csdn.net/qq_36523839/article/details/78885216

Add correct host key in /root/.ssh/known_hosts to get rid of this message.

https://blog.csdn.net/spark_Streaming/article/details/100528548

关于验证：ssh远程主机标识已更改

https://www.codenong.com/20840012/

ssh-keygen -R <host>

ssh-keygen -R 192.168.3.10

Mysql 高可用集群 MHA 搭建实例

https://cloud.tencent.com/developer/article/1084002

MySQL 高可用架构 之 MHA (Centos 7.5 MySQL 5.7.18 MHA 0.58)

https://www.cnblogs.com/winstom/p/11022014.html

所有mysql均需建立该账户

grant replication slave,replication client on *.* to 'slave'@'172.16.18.%' identified by '123qwe'; 

所有mysql增加主从用户

grant replication slave on *.* to 'repl'@'10.0.20.%' identified by '123456';

mysql报错 1142 - SELECT command denied to user 'root_ssm'@'localhost' for table 'user'

https://blog.csdn.net/qq_41097820/article/details/87643357

grant all on *.* to 'mha'@'192.168.50.%' identified by '123qwe';

centos7安装mha4mysql

https://blog.csdn.net/weixin_34095889/article/details/92855107

CentOS 7.6构建MariaDB MHA高可用集群，实现VIP漂移和邮件告警

https://blog.51cto.com/qiuyue/2403416

MHA实现mysql的高可用

https://blog.csdn.net/wzt888_/article/details/81639753

centos7 mysql+MHA高可用安装

https://www.cnblogs.com/kevincaptain/p/10333891.html

PS:以上注释不能写在mha管理结点的配置文件里，不然会报错

配置文件不能有中文注释。

解决Can't locate ExtUtils/MakeMaker.pm in @INC报错

https://www.jb51.net/article/155391.htm

Can't locate ExtUtils/MakeMaker.pm in @INC 错误的解决方式

https://blog.csdn.net/w87848608/article/details/13997271?utm_medium=distribute.pc_relevant_t0.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase&depth_1-utm_source=distribute.pc_relevant_t0.none-task-blog-BlogCommendFromMachineLearnPai2-1.nonecase

Simplest way to install forkmanager.pm

https://www.experts-exchange.com/questions/27583454/Simplest-way-to-install-forkmanager-pm.html

MySQL高可用架构之MHA（4）- 完结

https://zhuanlan.zhihu.com/p/35851390

Can't locate Params/Validate.pm in @INC (@INC contains: /usr/local/lib64/perl5 /

https://blog.csdn.net/cuantailuo7077/article/details/100478582

RPM resource perl-Params-Validate

https://rpmfind.net/linux/rpm2html/search.php?query=perl-Params-Validate 

Can't locate Log/Dispatch.pm in @INC

https://www.cnblogs.com/topicjie/p/6993274.html

http://www.bubuko.com/infodetail-2116341.html

安装MHA manager节点缺少 No package perl-Parallel-ForkManager available.

https://blog.csdn.net/u012599988/article/details/82745296

实现MySQL高可用之MHA过程错误记录集

https://blog.csdn.net/bacteriumX/article/details/81042147?utm_medium=distribute.pc_relevant_bbs_down.none-task-blog-baidujs-2.nonecase&depth_1-utm_source=distribute.pc_relevant_bbs_down.none-task-blog-baidujs-2.nonecase

MHA安装遇到的问题解决

https://blog.csdn.net/zhangjikuan/article/details/81780754?utm_medium=distribute.pc_relevant_bbs_down.none-task-blog-baidujs-1.nonecase&depth_1-utm_source=distribute.pc_relevant_bbs_down.none-task-blog-baidujs-1.nonecase

MHA报错[error][/usr/share/perl5/vendor_perl/MHA/MasterMonitor.pm, ln161] Binlog setting check failed!

https://blog.csdn.net/ss954773878/article/details/100284411

mysqldump 多实例备份

https://www.cnblogs.com/yancun8141/p/10985102.html

mysqldump -uroot -p --all-databases --add-drop-database -S /var/lib/mysql/mysql4406.sock   --single-transaction -R > /data/backup/4406backup/test.sql

MySQL5.7半同步复制配置

https://blog.csdn.net/weixin_39338423/article/details/107163229

INSTALL PLUGIN rpl_semi_sync_master SONAME 'semisync_master.so';

INSTALL PLUGIN rpl_semi_sync_slave SONAME 'semisync_slave.so';

show plugins;

show status like 'Rpl_semi_sync_master_status';

Mysql实现主从复制（一主双从）

https://blog.csdn.net/m_nanle_xiaobudiu/article/details/81086243

grant replication slave,replication client on *.* to slave@'172.17.0.9:3307' identified by '123qwe';

新设置用户或更改密码后需用flush privileges刷新MySQL的系统权限相关表，否则会出现拒绝访问。

change master to master_host='192.168.0.105', master_port=3306, master_user='xiaobudiu', master_password='xiaobudiu123', master_log_file='mysql-bin.000045', master_log_pos=402;

start slave;

取消mysql主从复制关系

https://www.cnblogs.com/duanlinxiao/p/12096054.html

stop slave;

reset slave all;

MySQL主从复制的实现过程

https://www.cnblogs.com/cocoxu1992/p/10670589.html

怎么查看mysql 的binlog日志存放的位置

https://www.cnblogs.com/jpfss/p/11112283.html

flush logs;

三种方式安装mysql及多实例安装

https://blog.csdn.net/baidu_33864675/article/details/94595786

Linux高级网络设置——给网卡绑定多个IP

https://www.cnblogs.com/woniu666/p/11196563.html

https://www.cnblogs.com/kelamoyujuzhen/p/9126022.html

用shell脚本安装MySQL-5.7.22-官方版本

https://www.cnblogs.com/allenhu320/p/11304784.html

用shell脚本安装MySQL-5.7.22-官方版本多实例

https://www.cnblogs.com/allenhu320/p/11304800.html

Linux CentOS7 中 完美解决VMTools失效，windows 与 Liunx间完美复制文件，无报错的解决方案

https://blog.csdn.net/qq_40982347/article/details/106329683

shell脚本安装mysql5.7及多实例

https://zhuanlan.zhihu.com/p/81862145

MySQL系列之一键安装脚本----单实例/多实例

https://blog.51cto.com/nolinux/1440414

mysql主从(主备)同步一键配置,配自动检测功能

https://www.cnblogs.com/chenglee/p/10249049.html

shell一键部署mysql主从同步

https://blog.csdn.net/hellowidow_2020/article/details/77280566?utm_medium=distribute.pc_relevant_download.none-task-blog-searchfrombaidu-10.nonecase&depth_1-utm_source=distribute.pc_relevant_download.none-task-blog-searchfrombaidu-10.nonecas

MySQL如何生成唯一的server-id

https://www.jb51.net/article/169550.htm