Details

    • Type: Bug
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0.5
    • Component/s: None
    • Labels:
      None

      Description

      STR

      1) setup pxc
      2) setup proxysql clustering for 3 instances
      3) run `proxysql-admin --config-file=/etc/proxysql-admin.cnf --cluster-hostname=cluster1-pxc-0.cluster1-pxc.run-master-2303.svc.cluster.local --use-ssl=yes --enable --update-cluster --remove-all-servers --force` for all instances
      4) add user 'user-test' and query rules for it
      5) create new proxysql instance from the scratch, add it into proxysql clustering
      6) run command 3) for newly created proxysql instance

      current result

      newly created instance became enabled, but delete the user and query rules on all servers

      expected result

      newly created instance became enabled, but sync configuration from the cluster

      solution

      when 'LOAD ... TO RUNTIME' command executed (by proxysql-admin) it updates 'version' and 'epoch' fields in 'runtime_checksums_values' table.
      in result, proxysql clustering replicates these changes to other instances.

      So, it is needed to disable updates in 'runtime_checksums_values' table during enabling.

        proxysql_exec "$LINENO" "SET admin-checksum_mysql_query_rules = 'false'"
        proxysql_exec "$LINENO" "SET admin-checksum_mysql_servers = 'false'"
        proxysql_exec "$LINENO" "SET admin-checksum_mysql_users = 'false'"
        proxysql_exec "$LINENO" "LOAD ADMIN VARIABLES TO RUNTIME"
      

      and return values back after enabling.

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                kenn.takara Kenn Takara
                Reporter:
                mykola.marzhan Mykola Marzhan
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 3 days, 1 hour
                  3d 1h