开启Binlog日志
-
修改配置文件,并重启服务
vim /etc/my.cnf [mysqld] server_id=1 #指定server_id log-bin=/mylog/db50 #指定日志目录及名称 :wq mkdir /mylog #创建目录 chown mysql /mylog #修改所有者 systemctl restart mysqld #重启服务
-
查看日志信息
mysql -uroot -p #管理员登录 mysql> show master status; #查看日志信息 +-------------+----------+--------------+------------------+-------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +-------------+----------+--------------+------------------+-------------------+ | db50.000001 | 154 | | | | +-------------+----------+--------------+------------------+-------------------+ 1 row in set (0.00 sec)
-
手动创建3个新的日志文件
mysql> mysql> flush logs; #刷新日志 Query OK, 0 rows affected (0.14 sec) mysql> flush logs; #刷新日志 Query OK, 0 rows affected (0.11 sec) mysql> flush logs; #刷新日志 Query OK, 0 rows affected (0.12 sec) mysql> system ls /mylog/ #查看日志文件 db50.000001 db50.000002 db50.000003 db50.000004 db50.index mysql> mysql> show master status; #查看日志信息 +-------------+----------+--------------+------------------+-------------------+ | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set | +-------------+----------+--------------+------------------+-------------------+ | db50.000004 | 154 | | | | +-------------+----------+--------------+------------------+-------------------+ 1 row in set (0.00 sec