Date: Thu, 10 Oct 2019 14:35:53 +0700 From: Willsz CS <willsznet@gmail.com> To: freebsd-questions@freebsd.org Subject: Double database name in Binlog_Do_DB Message-ID: <CAMby-etKcg_jczpOKdY=6Qf8-ismTsQNyB6V_S49RtQp2rwVgA@mail.gmail.com>
next in thread | raw e-mail | index | archive | help
Hi, folks
I need to know about double Binlog_Do_DB database name goes wrong display.
root@BEC-DB-P1:~ # uname -a
FreeBSD BEC-DB-P1 12.0-RELEASE-p10 FreeBSD 12.0-RELEASE-p10 GENERIC amd64
root@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@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@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.
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAMby-etKcg_jczpOKdY=6Qf8-ismTsQNyB6V_S49RtQp2rwVgA>