昨天对于Ubuntu的Mysql 进行配置,发现配置的时候,频繁出现问题:
问题1. log-bin的开启
这里的log-bin就是Mysql 的配置文件中的配置字段名:log-bin
在[Mysqld]添加
log-bin = mysql-bin binlog_format = row max_binlog_size = 200M
保存重启,发现重启不成功:
sudo systemctl status mysql.service
错误提示:
use --explicit_defaults_for_timestamp server option (see documentation for more details). as process 3838 ... mandatory server-id. Please refer to the proper server start-up parameters documentation
提示,配置log-bin的时候,要开启server-id 选项
参考文档:https://www.ilanni.com/?p=7816