Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-894

proxysql galera checker doesn't work with writers-are-readers

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Done
    • Priority: Medium
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      We have a 4 node cluster. Running in 'singlewrite' mode setup with proxysql-admin.

      WRITERS_ARE_READERS=1

      I expect to see all 4 hosts in the READER pool. See below. Server .0.6 is NOT part of the reader hostgroup. According to this variable, it should be.

       

       

      Wed Nov 22 15:44:26 EST 2017 ###### proxysql_galera_checker.sh SUMMARY ######
      Wed Nov 22 15:44:26 EST 2017 Hostgroup writers 10
      Wed Nov 22 15:44:26 EST 2017 Hostgroup readers 11
      Wed Nov 22 15:44:26 EST 2017 Number of writers 1
      Wed Nov 22 15:44:26 EST 2017 Writers are readers 1
      Wed Nov 22 15:44:26 EST 2017 log file /var/lib/proxysql/proxysql_galera_check.log
      Wed Nov 22 15:44:26 EST 2017 ###### HANDLE WRITER NODES ######
      Wed Nov 22 15:44:26 EST 2017 --> Checking WRITE server 10:10.240.0.6:3306, current status ONLINE, wsrep_local_state 4
      Wed Nov 22 15:44:26 EST 2017 server 10:10.240.0.6:3306 is already ONLINE: 1 of 1 write nodes
      Wed Nov 22 15:44:26 EST 2017 ###### HANDLE READER NODES ######
      Wed Nov 22 15:44:26 EST 2017 --> Checking READ server 11:10.240.0.13:3306, current status OFFLINE_SOFT, wsrep_local_state 4
      Wed Nov 22 15:44:26 EST 2017 server 11:10.240.0.13:3306 is OFFLINE_SOFT
      Wed Nov 22 15:44:27 EST 2017 --> Checking READ server 11:10.240.0.5:3306, current status ONLINE, wsrep_local_state 4
      Wed Nov 22 15:44:27 EST 2017 server 11:10.240.0.5:3306 is already ONLINE
      Wed Nov 22 15:44:27 EST 2017 --> Checking READ server 11:10.240.0.7:3306, current status ONLINE, wsrep_local_state 4
      Wed Nov 22 15:44:27 EST 2017 server 11:10.240.0.7:3306 is already ONLINE
      Wed Nov 22 15:44:27 EST 2017 ###### SUMMARY ######
      Wed Nov 22 15:44:27 EST 2017 --> Number of writers that are 'ONLINE': 1 : hostgroup: 10
      Wed Nov 22 15:44:27 EST 2017 --> Number of readers that are 'ONLINE': 2 : hostgroup: 11
      Wed Nov 22 15:44:27 EST 2017 ###### Not loading mysql_servers, no change needed ######
      

       

        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:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: