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

PXC Operator does not populate proxysql rules

    Details

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

      Description

       

      $ kubectl exec -it cluster1-proxysql-0 -- mysql -h 127.0.0.1 -P6032 -uproxyadmin -padmin_password
      Defaulting container name to proxysql.
      Use 'kubectl describe pod/cluster1-proxysql-0 -n pxc' to see all of the containers in this pod.
      mysql: [Warning] Using a password on the command line interface can be insecure.
      Welcome to the MySQL monitor. Commands end with ; or \g.
      Your MySQL connection id is 437
      Server version: Percona XtraDB Cluster Operator 1.1.0 (ProxySQL Admin Module)
      Copyright (c) 2009-2019 Percona LLC and/or its affiliates
      Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
      mysql> select * from runtime_mysql_query_rules;
      Empty set (0.00 sec)
      mysql> select * from mysql_query_rules;
      Empty set (0.00 sec)
      

       

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  ramesh.sivaraman Ramesh Sivaraman
                  Reporter:
                  matthew.boehm@percona.com Matthew Boehm
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  5 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 - 5 hours, 15 minutes
                    5h 15m