本文章配套视频 | https://www.ixigua.com/7092295507124748831 |
本专栏全部文章 | https://blog.csdn.net/tonghu_note/category_11716546.html |
总目录 | https://blog.csdn.net/tonghu_note/article/details/124333034 |
来我的dou音 aa10246666, 看配套视频
一、实战环境
节点 node4 | mysql 8.0.28 | 10.211.55.7 |
二、配置信息
1、查看配置参数
登录mysql后执行命令 show variables like '%log_bin%';
+------------------------------------------+---------------------------------------------+
| Variable_name | Value |
+------------------------------------------+---------------------------------------------+
| log_bin | ON |
| log_bin_basename | /usr/local/mysql/data/binlog |
| log_bin_index | /usr/local/mysql/data/binlog.index |
| log_bin_trust_function_creators | OFF |
| log_bin_use_v1_row_events | OFF |
| sql_log_bin | ON |
+------------------------------------------+---------------------------------------------+
6 rows in set (0.00 sec)
其中:
log_bin为ON说明这个参数是开启的,就是说系统是记录了bin log的