From owner-freebsd-questions@freebsd.org Thu Oct 10 07:36:08 2019 Return-Path: Delivered-To: freebsd-questions@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id E328E14BC81 for ; Thu, 10 Oct 2019 07:36:08 +0000 (UTC) (envelope-from willsznet@gmail.com) Received: from mail-qt1-x844.google.com (mail-qt1-x844.google.com [IPv6:2607:f8b0:4864:20::844]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) server-signature RSA-PSS (4096 bits) client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1O1" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 46pjZ00MX9z4jZ4 for ; Thu, 10 Oct 2019 07:36:07 +0000 (UTC) (envelope-from willsznet@gmail.com) Received: by mail-qt1-x844.google.com with SMTP id w14so7306886qto.9 for ; Thu, 10 Oct 2019 00:36:07 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:from:date:message-id:subject:to; bh=pMYbMHzuRlxamI31+aOCtA9wZQaRW8dm5sy4ndLdG6s=; b=XsVwrKuoxUq0Yjoi5U8NefJPqNrLyFqj89sF4pVTGxlKCKG+vk1+7suoYyW8kBKF4r kI9WXoXLf+G+esYWE0SlEHNqNQ/BhfvCaUzyxyodATh5I7mn99TfiAeWibw8MIez0dHi zjyyRHOOV6Qc8KzdwliH6xxL3TvEr6zi20RASR0Fj+tExFuiBV7uC3vAFkFZRKjjRhIy fONWLJa6VHGHNx94P7rQ6v11h96dnu6i+lab/ebV99QpFat+GE7Deu+7uYRmj6fKbdEB +AIZrojqaTirQdOJS9sUcGc276Aem091qLB7P/VHEP/2deQ+Hq8Ji3C3u5/QG3Vu8uQE VOWg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:from:date:message-id:subject:to; bh=pMYbMHzuRlxamI31+aOCtA9wZQaRW8dm5sy4ndLdG6s=; b=Ker455zyWvhMjnijPyxBeUK8TNow4tc/a4cx2lYqy9hzeP7kRaFfl/40MMhrqfKo8W LCjtr2wF6ih5wOvDK5yeUFF/r5jgPbruxsGlH8HWTeICa28rp2vt2nN5v2kd5wWigeIv eCQOs+J9EHs6t4+9NVu07CrBXMmBcrF7lXUwI+T9KUPZJgpyW46QMMKKpKp2pu9fXXwL cB1SUvLSV6Vohu3/izeBctWW50X3gV4saf0jtgAt1te4SNhEMHeh52+wHeDnfcPPXxfA n/b9zRmxxonQ5nuELIO7gpDipdRtc4h2rDSZGFsqgV0fGC9ieBwV/4Zj0J9IeM9oXOpQ wPXQ== X-Gm-Message-State: APjAAAVQzS5UKasENbrdF7GwzMiDBfa2n0VOI2MtRhWCOCEXjDlyCNXv nPubhh4YTa6ZIUhY/1yIfkyWhhYcV9iz4baVxGxinUn/ X-Google-Smtp-Source: APXvYqwKgm2aPvBtYZ3MnbbJCOFnAG37hwdKQ6JouOSr5NSaqFOmjirFmTFxlBR2n9d16AsgyullRyUv0PDu89FSerk= X-Received: by 2002:a0c:ff44:: with SMTP id y4mr2570076qvt.99.1570692966532; Thu, 10 Oct 2019 00:36:06 -0700 (PDT) MIME-Version: 1.0 From: Willsz CS Date: Thu, 10 Oct 2019 14:35:53 +0700 Message-ID: Subject: Double database name in Binlog_Do_DB To: freebsd-questions@freebsd.org X-Rspamd-Queue-Id: 46pjZ00MX9z4jZ4 X-Spamd-Bar: -- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20161025 header.b=XsVwrKuo; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of willsznet@gmail.com designates 2607:f8b0:4864:20::844 as permitted sender) smtp.mailfrom=willsznet@gmail.com X-Spamd-Result: default: False [-3.00 / 15.00]; ARC_NA(0.00)[]; NEURAL_HAM_MEDIUM(-1.00)[-1.000,0]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20161025]; FROM_HAS_DN(0.00)[]; R_SPF_ALLOW(-0.20)[+ip6:2607:f8b0:4000::/36]; FREEMAIL_FROM(0.00)[gmail.com]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; PREVIOUSLY_DELIVERED(0.00)[freebsd-questions@freebsd.org]; TO_DN_NONE(0.00)[]; IP_SCORE_FREEMAIL(0.00)[]; RCPT_COUNT_ONE(0.00)[1]; NEURAL_HAM_LONG(-1.00)[-1.000,0]; IP_SCORE(0.00)[ip: (2.56), ipnet: 2607:f8b0::/32(-2.53), asn: 15169(-2.14), country: US(-0.05)]; TO_MATCH_ENVRCPT_ALL(0.00)[]; DKIM_TRACE(0.00)[gmail.com:+]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; RCVD_IN_DNSWL_NONE(0.00)[4.4.8.0.0.0.0.0.0.0.0.0.0.0.0.0.0.2.0.0.4.6.8.4.0.b.8.f.7.0.6.2.list.dnswl.org : 127.0.5.0]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+,1:+,2:~]; FREEMAIL_ENVFROM(0.00)[gmail.com]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; RCVD_COUNT_TWO(0.00)[2]; RCVD_TLS_ALL(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com.dwl.dnswl.org : 127.0.5.0] Content-Type: text/plain; charset="UTF-8" X-Content-Filtered-By: Mailman/MimeDel 2.1.29 X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 10 Oct 2019 07:36:09 -0000 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.