Uploaded image for project: 'ProxySQL and Admin Scripts'
  1. ProxySQL and Admin Scripts
  2. PSQLADM-199

query rules cleanup during scale-up

    XMLWordPrintable

    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, 2 hours
                  3d 2h