Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-1163

Log flood using binlog server on Ubuntu Yakkety Yak

    XMLWordPrintable

    Details

    • Sprint:
      2017-42, 2017-43

      Description

      maxsclale log is lofin around 500M per day of such information,

      The only way to get read of it is to disable the binlog router
      This happen as well if nothing is connecting to maxscale

      2017-03-04 13:26:45 error : Write to dcb 0x7c89b0 in state DCB_STATE_ALLOC fd 18 failed due errno 104, Connection reset by peer
      2017-03-04 13:26:46 error : Write to dcb 0x7c89b0 in state DCB_STATE_ALLOC fd 18 failed due errno 104, Connection reset by peer
      2017-03-04 13:26:47 error : Write to dcb 0x7c89b0 in state DCB_STATE_ALLOC fd 18 failed due errno 104, Connection reset by peer
      2017-03-04 13:26:48 error : Write to dcb 0x7c89b0 in state DCB_STATE_ALLOC fd 18 failed due errno 104, Connection reset by peer
      2017-03-04 13:26:50 error : Write to dcb 0x7c89b0 in state DCB_STATE_ALLOC fd 18 failed due errno 104, Connection reset by peer
      2017-03-04 13:26:51 error : Write to dcb 0x7c89b0 in state DCB_STATE_ALLOC fd 18 failed due errno 104, Connection reset by peer
      2017-03-04 13:26:52 error : Write to dcb 0x7c89b0 in state DCB_STATE_ALLOC fd 18 failed due errno 104, Connection reset by peer
      2017-03-04 13:26:54 error : Write to dcb 0x7c89b0 in state DCB_STATE_ALLOC fd 18 failed due errno 104, Connection reset by peer
      2017-03-04 13:26:55 error : Write to dcb 0x7c89b0 in state DCB_STATE_ALLOC fd 18 failed due errno 104, Connection reset by peer
      2017-03-04 13:26:56 error : Write to dcb 0x7c89b0 in state DCB_STATE_ALLOC fd 18 failed due errno 104, Connection reset by peer
      2017-03-04 13:26:58 error : Write to dcb 0x7c89b0 in state DCB_STATE_ALLOC fd 18 failed due errno 104, Connection reset by peer
      2017-03-04 13:27:00 error : Write to dcb 0x7c89b0 in state DCB_STATE_ALLOC fd 18 failed due errno 104, Connection reset by peer
      2017
      Os used
      Linux version 4.8.0-30-generic (buildd@lcy01-08) (gcc version 6.2.0 20161005 (Ubuntu 6.2.0-5ubuntu12) ) #32-Ubuntu SMP Fri Dec 2 03:43:27 UTC 2016
      Config used
      deb used
      maxscale-2.0.4-1.ubuntu.xenial.x86_64.deb
      cat /etc/debian_version
      lsb_release -r
      Release: 16.10

      stretch/sid
      [maxscale]
      threads=1

      [MaxInfo]
      type=service
      router=maxinfo
      user=monitor
      passwd=EBD2F49C3B375812A8CDEBA632ED8BBC

      [MaxInfo JSON Listener]
      type=listener
      service=MaxInfo
      protocol=HTTPD
      port=4002

      [Replication]
      type=service
      router=binlogrouter
      version_string=5.6.17-log
      user=skysql
      passwd=skyvodka
      router_options==send_slave_heartbeat=on,transaction_safety=on,semisync=1,mariadb10-compatibility=1,server-id=999,user=skysql,password=skyvodka,binlogdir=/var/cache/maxscale/
      #router_options=send_slave_heartbeat=on,transaction_safety=on,semisync=1,mariadb10-compatibility=1,server-id=999,user=skysql,password=skyvodka,binlogdir=/var/lib/maxscale/

      [Replication Listener]
      type=listener
      service=Replication
      protocol=MySQLClient
      port=3306

      [MySQL Monitor]
      type=monitor
      module=mysqlmon
      servers=server1,server2
      user=skysql
      passwd=skyvodka
      monitor_interval=2000
      detect_stale_master=true

      1. Service definitions
        #
      2. Service Definition for a read-only service and
      3. a read/write splitting service.
        #
      1. ReadConnRoute documentation:
      2. https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Routers/ReadConnRoute.md

      [Read-Only Service]
      type=service
      router=readconnroute
      servers=server1
      user=skysql
      passwd=skyvodka
      router_options=slave

      1. ReadWriteSplit documentation:
      2. https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Routers/ReadWriteSplit.md

      [Read-Write Service]
      type=service
      router=readwritesplit
      servers=server1
      user=skysql
      passwd=skyvodka
      max_slave_connections=100%

      1. This service enables the use of the MaxAdmin interface
      2. MaxScale administration guide:
      3. https://github.com/mariadb-corporation/MaxScale/blob/master/Documentation/Reference/MaxAdmin.md

      [MaxAdmin Service]
      type=service
      router=cli

      1. Listener definitions for the services
        #
      2. These listeners represent the ports the
      3. services will listen on.
        #

      [Write Connection Router]
      type=service
      router=readconnroute
      router_options=master
      servers=server1,server2
      user=skysql
      passwd=skyvodka
      enable_root_user=true

      [Read-Only Listener]
      type=listener
      service=Read-Only Service
      protocol=MySQLClient
      port=4008

      [Write-Only Listener]
      type=listener
      service=Write Connection Router
      protocol=MySQLClient
      port=4007

      [Read-Write Listener]
      type=listener
      service=Read-Write Service
      protocol=MySQLClient
      port=4006

      #[MaxAdmin Listener]
      #type=listener
      #service=MaxAdmin Service
      #protocol=maxscaled
      #socket=default

      1. Internet Socket
        [CLI Inet Listener]
        type=listener
        service=MaxAdmin Service
        protocol=maxscaled
        address=0.0.0.0
        port= 3307

      [server2]
      type=server
      address=192.168.0.41
      port=5056
      protocol=MySQLBackend

      [server1]
      type=server
      address=192.168.0.41
      port=5055
      protocol=MySQLBackend

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Massimiliano Pinto Massimiliano Pinto (Inactive)
              Reporter:
              stephane@skysql.com VAROQUI Stephane
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.