MySQL
一、MySQL安装摆设1.1 安装Mysql
# tar zxf mysql-boost-5.7.44.tar.gz --- 解压MySQL
对mysql进行编译
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYWQzN2MwNjgxMDQxNGIxOTgyODQ0ZTZiMWU4NGJkZDkucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMmUxMGM3Mzc4MWM2NGFlZGE5ZmI2ZDQ0MjIxMDZjNDgucG5n
缺少c、c++，yum安装后继续编译
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYTE3MzdjYjAwOGMxNDI2ZDlhMmQwMjhhZTQ4MzAwZjUucG5n
缺少openssl,下载openssl-devel包
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYTRlNGM1MjUyNzJmNGU4Yjg0MmI3OGFlZDgyYjUyNDQucG5n
同理安装
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYzAxYmY5MTM0MDc4NDEzNWE2OGM2N2NjMTgwMzZhMzAucG5n
安装后，发现又报了一次没有ncurses的错误，是由于要删除CMake-cache缓存文件，删除后重新编译
完成后make -j2 安装
最后make install 将生成的信息自动拷入对应位置
ps：位置就是编译过程中选择的目标地位置
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvODg4OTcyNDZiMjg5NDBhNjgxNjlkNzE0YTE0OWExNmUucG5n
1.2 摆设Mysql
修改环境变量
# vim ~/.bash_profile
对下列文件位置进行更改
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZjk3OGVkOWJkYzBjNDlhZDg3YTUwMThlYjg4YTBkM2UucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMGE1NTNlYzJjNzAxNGUwMWFmMWNkNzNkMDc5MmE5ZmIucG5n
生成数据目录，加权限
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvM2MxMjc0MDE3NWU3NDIyMTk1OTlmNWYyYWI3ZjhmMmMucG5n
修改环境变量与设置文件
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvOGVkODk1M2RhZDljNGJiODhmYjhmYTZlY2ZlYjYyMDIucG5n
初始化建立数据
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvODJmOWUyMTI1NDQ0NGI3ZGE4NDkyYzFlNmE5OTI4YTQucG5n
启动mysql
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvOWMwNGI5N2ZiM2Q0NGFjODg1ZmZiMDA1YzA4ZDQ0NjAucG5n
开机启动
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvY2IwOWZhZWQyODUyNGUyMTlhYzQ1MjdhOTBiMjZlZDUucG5n
输入密码启动
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZDJmN2VjN2NmMzRiNDdlODlhYTBlNmMyZjVjYzFlMGEucG5n
此时打开数据库，它要求我们修改密码
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZjdiZWMzMjY2M2ZmNDliOWI5ZTJiZTExODAxMDUxOTUucG5n
安全初始化
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZDk3ZGM2NmI2YTI5NGNmZTg5MDkyNGEzNDU4N2VlN2MucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMGRmODRkZDFjYmRhNGI4NTgxZTM0NjM4Njk3YWIzYzgucG5n
此时再登陆就可以查询了
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvOGE2NTQ4YWMyY2JkNDAyODgwNGFkOTdkOGZjZDdmNTUucG5n
将数据库拷贝到另一台主机上
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZWI1YTM2NGNmNjBiNDk1OGFmODNkOTE5MzczNzBmM2UucG5n
添加用户，建立目录
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZDkwMzZiNjYwMmRmNGJiYmJkYzI3ZmY2NTRhMzk4NDcucG5n
传输
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNTc1NzkyNGMzMDBiNDQ4MjkzNWVhYjNhMmExYjU2ZDMucG5n
传输完成
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYmUxZGY3YjE1YzI5NGQzYzk2ZjE2ZDQ4ZWQwNGI3MDkucG5n
然后在第二台机中继续进行编译环境变量、设置启动脚本、修改设置文件、初始化等操作
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvODVmMTdjODg5NjNkNDRlZGFkNjQ3ZTIzNTRjNGIyZDgucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMzI2YTIzNjg5MDUyNDU1NGEzNDkyMmY4NDliZGY0ODMucG5n
最后，打开数据库，拷贝设置完毕。
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYzIzNGFmNjYzMGMyNDM4ZWIxMDNiNGU0MjhhNmNiNjQucG5n
二、MySQL主从复制
2.1 一主一从(无数据)
设置ID
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNzZhYjM0NTdhMGIwNDc2N2E3NTM3ZDM5Yjg5MzIyODQucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMjE1YjFlMzZlMzBmNDUwOWJmMmRkN2Q5YmM0ZTBjYTYucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvN2I1ODY3ZThlYWFjNGE1ODk2MmVjOTYyZWI0OTQ3YWUucG5n
log-bin 二进制日志(将操作进行生存记录)
检察mysql文件夹，发现并没有日志存在
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYjExZThhMzYyMDk0NDViM2FhNWM3YjI3ODZjZjk4N2YucG5n
重启后，ll查询到日志的存在
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYmEwM2IwNmYyYzQ3NDM2MWEyNzJhMjg1MDRkZjNmMmUucG5n
检察日志信息
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYWJmMzhlNDZjZGYzNGFmZjkzN2NjYTVkMDVlNTc2MjAucG5n
登录mysql，建立用户用于slave认证
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZmU4YTY5OWFlMWEzNGIyZjlkMDIzMWU4OTEyY2QyYTkucG5n
授权，然后检察状态
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvOGIxMzgwYmE1YWNjNDg0Nzk4ZDc4ZWQxMmUzN2M3ZWQucG5n
在slave端设置
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMGUxNjg1ODhmZjM2NDcxOTgzMzZkZDcxMmIyZTYzZGIucG5n
设置后启动
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvOTFjNWVjZGYyNmY0NDkwNmExNGZjNzVkMGYyZjk2MDcucG5n
启动后检察状态，发现俩yes，说明储备成功
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNTU4NTUyZjBiOTM1NDgyNDgwZDhmZDY0YjgwMmU3NzEucG5n
给主机创建数据库，在slave机查询，看是否能查到
master：
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNmM5MjQ3NDhjNjUyNDM0ZmFjN2YyMWJmNmE5MjFkYTUucG5n
slave：
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNDZiZjJjOTMwMjg2NDEyMmIzZDRhYWNiMjIwMTAzNmIucG5n
在从数据库中插入也可查询到
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZTJiODU5NmRhODg2NGU0OWIyZTZkNDRmNzhiNTNmZTgucG5n
但是主数据库查不到
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNzJiMTI4ZmQyMWEyNDVlMmE2MjhiOWExZjJkODE4ZGUucG5n
2.2 当有数据时添加slave2
前面设置与先前类似
master主机上实行备份
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvM2QwMTA2YjJlYTUyNDM2MWI4ZDMyOWJkOGNlNDAzYjAucG5n
备份后检察表信息
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYWM4OTgxOGRlN2Y4NGRhMzhkMTA5ZWJjMWEzZDQyMDAucG5n
将备份的文件发送到slave2上
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMzAyY2VlYzU1MDk4NDgxN2EwYjI3NDIxZjkwNTlhYmIucG5n
在slave2中备份数据库，然后恢复
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYjA1ZDU5NmMwZTdmNDU0YThiMDFmMjA0M2RkMGQxN2MucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMmNlMmY5OTYyN2ExNDJlN2IzMGNhZWJhMGUzZWZmYzcucG5n
接下来，打开数据库进行连接
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMjhhMGE0ZWQ5YzU2NGUwMmE3OWViZDM1NmQwZDI4MTIucG5n
连接发现有错误
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZTUzYTQ3YzZhMDgwNDAyMTgxNDdhZDZiMjYzZmM4YzgucG5n
停掉，修改。
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZDE1ZDVkZmJjNDYyNDIwNWE4NmJhM2NlNGVmMjk4ZjYucG5n
有错误可能是密码有误，可以打开主机多尝试几次，确保登录信息无误再去副机进行登录
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNjQ1NDUxNGQzYWUxNGJkMDliZWMyNjc2NjkzODMwZTkucG5n
确认密码后，在副机上进行登录
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMTkxYTYwMjU4YjIzNDEzMDg2NzRmN2MzMGFlNDhiZDMucG5n
检察状态，显示已经登录完毕
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvOWYyM2E0YzAyNmUwNDNmZGExY2ViZmZkNzhkYWU5NjMucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMjhkYzIzYzBlMzUyNDkzMWJmMDQzYjdiZTUyOWJlYjQucG5n
此时在主机上添加数据库信息，在slave2上可以查到
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZDdkNDkwNTlhOWM1NDE3OWE1MmNmODRkNDM4ZDRjYzYucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvODQzN2U4ZDk1MDZhNGZjM2JjZjYyZmFkMmFhMzU4ZjkucG5n
在slave1上也可以查到，说明一主两从设置完毕
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNzk5N2Y1YmY4YzViNGM5Mjk1NjY5MTIzOGZjMWEzNWYucG5n
当读取>写入 从的个数要大于主的个数，反之小于。
2.3 延迟复制
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvOWY4MWE5MmI1MWIwNDhjY2E2OGJiOTA0NDQ0ODg0MDkucG5n
设置延迟为60s
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMGQ3ZjMyZTYzOWM1NDA0MGFkOTNiMjMyMmJjMDg0MzgucG5n
主机删除数据，slave2上并没有立即变革
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYzc5YjMwZTU3YzBlNDExNDg4YWZmMTNhZTFlYjRjNGEucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYWMwZmJjMGZhNTEwNDU3ZGI4YzYxNWUwMzhmZjg5YmQucG5n
过了一分钟后，才复制到主机内容
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvY2RiNzQ3MDQ0ZmRkNDRiY2FlMmE2N2U0YWU3ZTg1ZWEucG5n
2.4 慢查询
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvOWViNmZjNjA1OGY4NDI2ODhiOTI4MWRhMjhjZDI3Y2IucG5n
设定后查询
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvM2E2MjhkYTE4NWVjNGU0NTgxMzNhYWNiMzA3ZWNlYjYucG5n
查询设定的慢查询的时间
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMDhhYjJjMmI5ZjI1NGE5Njk0OTE2ODdkMTUwZTZmZTIucG5n
慢查询
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNjA4YTE3YTlkMDY5NDgyYzg2MDIxM2YxOGM2Y2ZlMDcucG5n
检察日志
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZGEzMTE4OTg0ZmFlNDVlNmJkYTI4NmE0ZDI2MzA1NzAucG5n
2.5 Mysql并行复制
默认情况下slave中使用的是sql单线程回放
在master中时多用户读写，如果使用sql单线程回放那么会造成组从延迟严重
开启MySQL的多线程回放可以办理上述问题
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZjY1ODRhYjgyNzc1NGI5N2JhNTEyMjE0NDY4OWNkYjUucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNTU3OGY5NDVhMzZiNGI0YThjNWFhNWViMDM1YzQxNzIucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYmI3ODE2OWI0NTRiNDEzNDlmOWI0MmJjYzEwYjNhNmMucG5n
此时sql线程转化为和谐线程，16个worker负责处理sql和谐线程发送过来的处理哀求。
2.6 Mysql主从复制原理
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNjFjMTA0MDlmOTViNDY3Mjk3NTIyNDI0MzViOTNiOGMucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNmNmNjliNmJhZjZlNDFhMmE5ODdkMzg2Y2I3ZWM1YzMucG5n
三、半同步模式
3.1 gtid设置
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYTdlOTY5NGQ3ZGZmNDU0OGI1ZmNkOTA3MzBkYzYzYjYucG5n
设置后重启
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvOTE2MWIzYmNmM2UzNGQ2MWI3N2ZhNDM2YjkxOTZmMDcucG5n
gtid已开启
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZDE0Y2Q4YjAzY2RjNDI3YmFlYzE3ZmRmMzY5M2EyY2QucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZGZhYjAyNGNhZmFiNGQ1ODk5MTRhY2EwYzgzN2VlZWQucG5n
设置后打开slave，实现自动辨认
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYzJkY2IzNjUwNTRiNDRlZTlhMTg5MzE2MWYxOTJjZWUucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYjRlOGFhNTAwYmIyNDk3OWFjZWI4OWNmNzZlMzc1ZGMucG5n
3.2 半同步模式
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZTU1NTQ0ODAzODIxNDgyNGEwMjA1Njg4ZTYxYmZkMTQucG5n
进入设置文件，到场参数，开启半同步模式
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvODk4YjI3ZGMxMTUwNGVmNGE4M2EwYmM1NzdjNGE5YjkucG5n
在mysql中下载相关包
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvODEyNmU2ZjMxYmJkNGZiMTgzYWJmYjJiOTcwZjYzYTYucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZWYyMWYzNTM3Zjk4NDk2Y2FmZmRkNzViNTYwNTM4MzYucG5n
检察相关内容的状态
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZmM0NmJmYWIzMjRmNGIzZmIzZmU5MDA5NmUxNWNkYTUucG5n
master设置完毕后，再在其他slave机上设置相关内容
留意，要先打开数据库，再添加设置，否则会启动失败
原因是在数据库内部没有安装对应的包
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMDUzZWE3YjA4YTkwNDYyOWIzZDA5MWM4NDIwYjhiZWEucG5n
slave机上查询可以查到
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvOGJhNTJkZDMwNzVlNGMyODk0Zjg3YmI2MjVjMGRkMTQucG5n
关闭IO线程
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMzQxZWI4MGVhOGU3NDcyZWIxYWJmMmExOWIwYTJiODcucG5n
关闭后在主机存在十秒超时，说明半同步成功
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZDBlNjYwODQ0MTAzNGFkYzkzZTcyYjNmNDQzMmY2MmMucG5n
四、MySQL组复制
关闭mysql，然后删除原有数据
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZTlkYWRiODg1NTdlNGFlMmJjMzAyNWM2MmNlMmZmN2IucG5n
更新设置
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMDgxMjE3MzM5NTg4NDdlYzlhMGU0MmE0YTEyZWE5Y2YucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMDZkYjJkM2NiZDZlNDk2OWJiMmJhNTZiZTJhYThkOWEucG5n
重新进行初始化
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYzAxMjE0YjA3MmMwNGYwNzkyYTZkN2M4NWMzNWVmOWYucG5n
初始化后，进入mysql，改密码
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNTE5MTc3NjIwMTQwNDJiODhkMGU5YTVjNzlkYTMzZTcucG5n
为了保证数据的一致性，背面要建立在数据建立用到的用户，以是先把日志功能关闭
设置
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMzhmMzY1ZjkyOThlNDBmM2E3MzgxOTMyYjA3MzJhNTMucG5n
设置完成后，会生存在performance中，可在该数据库中检察
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNDQ0NTk0ZmFmNDlmNDE5ZmIwZmUxYzVlZTlmZjFlMDQucG5n
检察已有信息后，针对主机名进行ip解析(三台都做)
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZWFhNDZiODEwMzIzNGFlZWJhOTc5N2I0M2NlYTlhMzUucG5n
设定完毕后，组设定完成，此时需要把另两台添加进来
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMmNkN2U4NDlhNzJmNDg3NWJlMmMwYWM5ZDViNThkMTYucG5n
复制完初始化启动
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNGMxN2IxNTQwMjI1NGVmYmI3MGVhM2I5NjAyZjM1OTIucG5n
重复之前操作，操作完成后查询
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMzdkZjM0NjI3YTU2NDRiNzhlMGQ3OWMzNDJmMTdmOGQucG5n
30同理 最后检察
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZGQ5N2VkMmYzNjYzNDU5YzhlMzdiZmFiNGQ1MzEwYzUucG5n
此时，三台完成组复制功能
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNDg5NzlmZDMxZmVjNDNlZmJhM2JjZTgwNzJkMmViZWEucG5nhttps://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNmMxZjg4ZGU2MWJlNDhlMDk5YTYxNjQ3NDZjNzdjYTgucG5n
在30建的数据库，在20也可以查询到
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYzJlODU3Mzk4MTBiNDc4ZTg3N2ZmOTkzOTk2NmMzYzUucG5n
30建立的表，20也可以查询到
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZDFkN2EzNWE2MDEyNGI0ZWE1MTUzMWI1MDhkYzFlYjcucG5n
同理，20上插入数据。30也可以查到
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMTlkOTJhNDRjOWM5NDViN2I1M2Q5MmJmYmI2OWNlYjgucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZWI3OTk1MTMxMDQ1NDdlMjlkOThkMzY5ZjcyMjM0MGEucG5n
10也同理
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZmM0NDQxMzZkOWZlNDFkM2EyZTY0YjhiMGVkMDM4MWQucG5n
但是，如果有一台呆板挂了，再开启，不会自动进入组中
此时把20挂了
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMGM3ZDI3YTQ5YTcwNGUzOThiMDUyYzYzMjExOTI3ZWEucG5n
重启后再查询
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZDhiZDk0ZTE1MDJmNDU2ZGJkNWZhNDE1NDgzNDk3YTUucG5n
为什么呢？由于在设置中，参数已经写入，开启不会自动激活组复制目录中
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNWY4MTFkZTAwZTFhNGI3Y2E2ODdjZjAwNWY4ZTU5NDYucG5n
那如何办理呢？
检察20状态，是offline
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMDFjZWQ1MTgwYjc4NDVkNmFhYTlmNDE2MDljZmQ1MTcucG5n
打开就可以了
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvOTMzODg1MWNlYmFlNGUyNjk4YTQzMWU5OGIzNTk0NGUucG5n
五、MySQL路由
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZmUwY2E2MWJkMWI5NDMyODk0OWZkOTE3ODE5ZTE0ZjQucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMTA5OWQ0YWQ2MDY4NDY2M2FmMDIwMWI0MjgxZmE0ZDcucG5n
30设定的是lee，lee
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZGM5OWU4OGZlOGU0NDdiNGI4ZGYwYTVlY2ViYmNmNjEucG5n
查询是哪一台服务器
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNDg5NjE0YmIzNWFmNGYyYThmOTc2MzRkOWU5YTgwMTgucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNDIzNzI1ZTM4OWNkNDAwZjg3NzBlNTg1NzNhZTA5MTQucG5n
六、MHA
将压缩包解压
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMjJkZDA2MmE5NjRlNDJkMjgxOTM0ZTM2ZWQ2NDA2MzMucG5n
mha与其他主机之间实现免密认证
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZmYwODUzYjJiNDhjNDI2N2IxMmRkODlhY2NhYjdlNzAucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZWJmMjFiN2U0NWI4NDcwYjkwYjI4ZGYyYjUyMzRkMDUucG5n
20、30相同，然后做本地ip解析
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMjIwYmY0YzkyODdjNGE3NzkyODEwZTg2ZjQ0MDBkNjkucG5n
将数据库信息清除，初始化恢复一主两从
master开半同步
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZGZlOTMzZDNlODI4NDI5ZTk1ODhjNmEyMDRkN2M2MmYucG5n
slave完成相关设置
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMmVlZWVkMGQ3ZTFlNGUzNGJhZWQwYmZjODQ5N2Y2MGIucG5n
安装mha的rpm包
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMTE1OGI1Y2E5MWJlNGZkOWE4YjJiODhjNGY0NzA1NDUucG5n
然后把node包发送给三台呆板，进行安装
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZDM1NWMyZjQ5YzVlNDM0NDhjZGQzMGNhY2NmODZiMzQucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMDUwYjlhMTk2ZjlkNDliZWIwYTg2MjQwMDU4YTllNjAucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZTJmMTUwNjU5NzhhNDVmMDgwZDViNDM4ZTQwYjQ3NDEucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYjkzZmMwMDVmNzE2NDJmNDkwZjhhYzk2NzdiMDYzZWEucG5n
设置mha环境
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNjQ3ODU1ZGNkOGY5NGQxNmFlMjYzZjJjYWE3MWNmNmQucG5n
建立目录
将安装包解压到对应目录下
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvM2I1YWU4OTU2MjA3NDQ0MmI4NTM4NjE0N2UyYmRhN2UucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZGJkYzQyNWI5NmVhNDY2MWI3MjlhODQyZjBlNzA1ZGQucG5n
将安装包安装在本地，然后进入对应文件app1.cnf进行编辑
但现在并不能远程登录，以是要在设备上设置超级用户
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNjU5Nzc4ZjExZDM3NGRjNDk5MzE0OWZkZjc2MzM1MjMucG5n
在master上做了，其他两台也可以登录。
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMjdhNDdhYjA1OTZlNGJhY2E3MTE1NWMyMmYyNzllZDEucG5n
mha设置内容
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNGVkZmE1NTI1ZDA4NDhkMTljZmNjZDc0MGVmZjA1MzUucG5n
连接10设置不通，换20检测
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNjM3MWFjMjM2NzZiNGM1Yjk4YWYyODgzNmRlZjg2YzEucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNTIyNzhhZjY3YmUwNGE2MDgxYzdkZjcyYjg3YTFjMjYucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMThmOTZjZGQ1ZGQxNDhkYmE5YzdiZTQ4OGMwMmM4MjcucG5n
第二个 -s后网络地点不应该是20 否则会被认为是双主，应该是一个下面所没有的ip地点
检测是否进行免密登录
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvMWVhOTI3MGRiNGJjNGE5Y2JlY2NhOWI2MDRjMDU3YzcucG5n
原因是现在只有mha机可以对其他呆板进行免密登录，三台呆板自己不可。
办理方法：
将做了ssh的mha机私钥发送给其他主机
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYTdkMWI3NzdmNmJjNDk3ODg3MTU1OTBiNjZmZDQxYWMucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZTIzNmY2OGFlODhiNDUwYjhjMTgzNDljYmVhYTRiZjQucG5n
此时再进行网络检测，成功。
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYjhhZTYzODRhZDk1NDQ2M2I0MGNjYmRiNjRhYWE0YjcucG5n
检测主从复制情况，成功。
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvZjkxMGY5OGRiMDczNDQ5NTljZDg1YTU0OTk4OWY1NDkucG5n
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvYzYwYTIzZWRhZGIzNGMyOWJmOTgyYmU1MjJiYjAwNTcucG5n
添加mysql主从复制中负责认证的用户
ssh检测
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNTgxN2UyNDQ5NDM0NDZjYjkxYmIxOGQ1ZTU4OTUwYjEucG5n
设置检测
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNGIwYzUzYTMzYTZkNDk0ZjllNzYxNzJjMDRjMGVlMzgucG5n
MHA故障切换
https://dis.qidao123.com/imgproxy/aHR0cHM6Ly9pLWJsb2cuY3NkbmltZy5jbi9kaXJlY3QvNDY4OWY0ZGYwOGI1NDFjNjk5ODgzYWU1NzcyNGI4OWQucG5n
页:
[1]