文章目录
一、Centos7、Mac安装MySQL
笔记地址:https://www.cnblogs.com/ZhuChangwu/p/12984153.html
视频串讲地址:https://www.bilibili.com/video/BV19g411N7NR?p=2
二、主从复制原理
2.1、基于binlog_filename + position
原理图:
笔记地址:https://mp.weixin.qq.com/s/cSToNVQPK8QCpkjapxNoEw
视频串讲地址:https://www.bilibili.com/video/BV19g411N7NR?p=3
2.2、基于GTID
原理图:
笔记地址:https://mp.weixin.qq.com/s/V5hU2ATeey871loWQIqHKg
视频串讲地址:https://www.bilibili.com/video/BV19g411N7NR?p=4
三、my.cnf
[mysqld]
# 端口
port = 3306
# 数据目录
datadir=/var/lib/mysql
# 错误日志
log-error=/var/log/mysqld.log
# 为每张表单独创建一个表空间文件
# 大家常说的表空间到底是什么?究竟什么又是数据表呢? https://mp.weixin.qq.com/s/CwxRjGI843UerF89G_WJ-Q
innodb_file_per_table=on
innodb_file_format = Barracuda
# binlog 相关配置
# 1、MySQL的 bin log有啥用?在哪里?谁写的?怎么配置?
# https://mp.weixin.qq.com/s/DN1shuyxPJ6BkE_RLezAnA
# 2、了解bin log的写入机制吗?说说你们线上如何调整参数的!
# https://mp.weixin.qq.com/s/MtWzoiJtupso5M8z1KUaQQ
# 3、bin log有哪些格式?有啥区别?优缺点?线上用哪种格式?
# https://mp.weixin.qq.com/s/ar-wVbDi4CYjPI1t6fTjVw
log_bin=mysql-bin
log-bin-index = mysql-bin.index
max_binlog_size = 256M
sync-binlog = 1000
binlog-format = ROW
# relaylog相关配置
relay_log_recovery = 1
master_info_repository=TABLE
relay_log_info_repository=TABLE
relay-log = relay-log
relay-log-index = relay-log.index
sync_relay_log = 1000
max_relay_log_size = 256M
# 设置server-id,集群唯一
server-id=1
# pid、socket
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/lib/mysql/mysql.sock
symbolic-links=0