show master status empty解决方案

最新推荐文章于 2024-03-29 11:22:07 发布

weixin_30677617

最新推荐文章于 2024-03-29 11:22:07 发布

阅读量363

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/fanelephant/p/3754327.html

版权

The following MySQL error might occur if you are using MySQL replication and binary logs.

mysql> show binary logs;
ERROR 1381 (HY000): You are not using binary logging

Solution:

I have already discussed the same problem here. If you are still facing issues then it might be possibility that problem is with MySQL my.cnf file.

The my.cnf file structure for replication should be as below:

[mysqld] .

.

bind-address= 192.168.0.6
binlog-do-db=exampledb
server-id=1
log-bin=/var/lib/mysql/log-bin.log
[mysqld_safe] log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Make sure that "log-bin" is present under mysld and not mysqld_safe, else it will not have any effect.

Restart the MySQL service.

Check by logging in the MySQL prompt:

mysql> show binary logs;
+----------------+-----------+
| Log_name | File_size |
+----------------+-----------+
| log-bin.000001 | 106 |
+----------------+-----------+
1 row in set (0.03 sec)

That's all!

转载于:https://www.cnblogs.com/fanelephant/p/3754327.html