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

LP #1736921: Inconsistent and unsafe FLUSH behavior in terms of replication

    XMLWordPrintable

    Details

      Description

      **Reported in Launchpad by Przemek last update 07-12-2017 13:25:26

      Description:
      Many of the FLUSH commands are bin-logged (but not all), and if GTID mode enabled, adding GTID sequence with local UUID.

      These commands also do not respect super_read_only=1.

      An example ones affected:
      FLUSH SLOW LOGS
      FLUSH HOSTS
      FLUSH STATUS
      FLUSH PRIVILEGES
      FLUSH USER_RESOURCES
      etc.

      Not affected:
      FLUSH LOGS
      FLUSH ENGINE LOGS
      FLUSH BINARY LOGS

      This may cause replication problems later as the cluster becomes inconsistent.

      Upstream report:
      https://bugs.mysql.com/bug.php?id=88720

      Somewhat related bugs:
      https://bugs.mysql.com/bug.php?id=83232
      https://bugs.launchpad.net/percona-server/+bug/1631816

      How to repeat:
      Test case seen in upstream report.

      Suggested fix:
      I don't see much sense in actually replicating these FLUSH commands at all, especially that most of them are related to local resources, which can be different on the slave side.

      If though any of these has to be replicated/bin-logged for some reason, it should respect at least the super_read_only setting.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              yura.sorokin Yura Sorokin
              Reporter:
              lpjirasync lpjirasync (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 1 week, 2 days, 2 hours, 10 minutes
                  1w 2d 2h 10m

                    Smart Checklist