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

Update ProxySQL-2.0 document

    XMLWordPrintable

    Details

    • Type: Admin & Maintenance Task
    • Status: Done
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.0.5
    • Component/s: Documentation
    • Labels:
      None

      Description

      We need to update the following text from https://github.com/percona/proxysql-admin-tool/blob/v2.0.5-dev/README.md for ProxySQL-2.0.5 release.

      1) proxysql-admin usage info
      2) Option --add-query-rule usage text

      6) --add-query-rule
      
      Create query rules for synced mysql user. This is applicable only for singlewrite mode and works only with --syncusers and --sync-multi-cluster-users options.
      
      $ sudo proxysql-admin  --syncusers --add-query-rule
      
      Syncing user accounts from PXC to ProxySQL
      
      Note : 'admin' is in proxysql admin user list, this user cannot be addded to ProxySQL
      -- (For more info, see https://github.com/sysown/proxysql/issues/709)
      Adding user to ProxySQL: test_query_rule
        Added query rule for user: test_query_rule
      
      Synced PXC users to the ProxySQL database!
      $
      

      3) Option --force usage text

      11) --force
      
      This will skip existing configuration checks with --enable option in mysql_servers, mysql_users and mysql_galera_hostgroups tables
      
      

      4) Option --update-mysql-version usage text

      12) --update-mysql-version
      
      This option will updates mysql server version (specified by the writer hostgroup, either from --writer-hg or from the config file) in proxysql db based on online writer node.
      
      $  sudo proxysql-admin --update-mysql-version --writer-hg=10
      ProxySQL MySQL version changed to 5.7.26
      $
      

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              borys.belinsky Borys Belinsky (Inactive)
              Reporter:
              ramesh.sivaraman Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              1 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 - 2 hours
                  2h