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

BLR: Improve disconnection reporting of connections via the MySQL interface

    XMLWordPrintable

Details

    • New Feature
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Fixed
    • None
    • 1.3.0
    • binlogrouter
    • None

    Description

      Maxscale logging shows in syslog after a disconnection from the binlog server's MySQL port:
      Jun 25 17:34:00 xxxxx MaxScale[12049]: blr_service: Slave 1.2.3.4, server id 0, disconnected after 43 seconds. 0 events sent, 0 bytes.

      I had actually sent some SQL commands to the binlog router, so it looks odd.

      So the data shown are "binlog events", events and bytes.

      Given that a SQL connection may be used for slave streaming or configuring the BLR it might be useful to adjust the logging:

      Jun 25 17:34:00 xxxxx MaxScale[12049]: blr_service: Slave 1.2.3.4, server id 0, disconnected after 43 seconds. 999 SQL commands, 9999 binlog events (99999 bytes).

      Attachments

        Activity

          People

            Massimiliano Pinto Massimiliano Pinto (Inactive)
            simon.mudd Simon J Mudd
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.