Uploaded image for project: 'Percona Server for MySQL'
  1. Percona Server for MySQL
  2. PS-1804

LP #1684347: semisync replication is slow and incompatible with slave_compressed_protocol

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by monty solomon last update 20-04-2017 06:25:08

      The QPS drops from around 300 QPS to around 30 QPS when
      slave_compressed_protocol is enabled running the following command on the master with two (2) slaves.

      pt-heartbeat --database heartbeat --table heartbeat --update --create-table
      --daemonize --interval 0.01

      The state on the master is "Waiting for semi-sync ACK from slave"

      master my.cnf settings

      plugin-load = rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so
      rpl_semi_sync_master_timeout = 1000000000000000000
      rpl_semi_sync_master_wait_no_slave = 1
      rpl_semi_sync_master_enabled = 1
      rpl_semi_sync_slave_enabled = 0
      slave_compressed_protocol = 1

      slave my.cnf settings

      plugin-load = rpl_semi_sync_master=semisync_master.so;rpl_semi_sync_slave=semisync_slave.so
      rpl_semi_sync_master_timeout = 1000000000000000000
      rpl_semi_sync_master_wait_no_slave = 1
      rpl_semi_sync_master_enabled = 0
      rpl_semi_sync_slave_enabled = 1
      slave_compressed_protocol = 1

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: