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