Double database name in Binlog_Do_DB

Willsz CS willsznet at gmail.com
Thu Oct 10 07:36:09 UTC 2019


Hi, folks

I need to know about double Binlog_Do_DB database name goes wrong display.

root at BEC-DB-P1:~ # uname -a
FreeBSD BEC-DB-P1 12.0-RELEASE-p10 FreeBSD 12.0-RELEASE-p10 GENERIC  amd64

root at BEC-DB-P1:~ # pkg info | grep mysql57
mysql57-client-5.7.27          Multithreaded SQL database (client)
mysql57-server-5.7.27          Multithreaded SQL database (server)

root at BEC-DB-P1:~ # grep binlog_do /usr/local/etc/mysql/my.cnf
binlog_do_db                    = bec           # Database name will be
read by slave server - Master mode.
binlog_do_db                    = payrollbec    # Database name will be
read by slave server - Master mode.

root at BEC-DB-P1:~ # mysql -u root -p -e "SHOW MASTER STATUS;"
Enter password:
+------------------+----------+-----------------------------------------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB
   | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+-----------------------------------------------+------------------+-------------------+
| mysql-bin.000016 | 69149199 |
bec,payrollbec,absensi,bec,payrollbec,absensi |                  |
          |
+------------------+----------+-----------------------------------------------+------------------+-------------------+

On sample above, Binlog_Do_DB has double database name view. Anyone have a
similar issue?

Thank you.


More information about the freebsd-questions mailing list