mysql

开机自启

配置Binlog

flinkcdc需要用

1
2
3
4
5
6
7
8
9
10
11
12
13
14
1 sudo vim /etc/my.cnf
2 写入
server id = 1
log-bin=mysql-bin
binlog_format=row
binlog-do-db=gmall2021
binlog-do-db=gmall2021_realtime
注意:binlog-do-db 根据自己的情况进行修 改,指定具体要同步的数据库,多个就写多行
3 重启mysql
sudo systemctl restart mysqld
4 查看有没有生效
cd /var/lib
sudo ls -l mysql | grep bin
修改mysql库里数据,观察"mysql-bin.最新"文件大小的变化

问题

1 Job for mysqld.service failed because the control process exited with error code

https://blog.csdn.net/qq_41179691/article/details/104598293

2 navicat连不上服务器的mysql

https://blog.csdn.net/u014264373/article/details/85564524

https://blog.csdn.net/MTbaby/article/details/56836986

Author

Lavine Hu

Posted on

2022-05-21

Updated on

2024-04-17

Licensed under

Comments

:D 一言句子获取中...