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

Add slave nodes in reader node count in galera/node monitor log.

    Details

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

      Description

      Add slave nodes in reader node count in galera/node monitor log.

      [2018-10-25 04:22:41] ###### proxysql_galera_checker.sh SUMMARY ######
      [2018-10-25 04:22:41] Hostgroup writers 20
      [2018-10-25 04:22:41] Hostgroup readers 21
      [2018-10-25 04:22:41] Number of writers 1
      [2018-10-25 04:22:41] Writers are readers ondemand
      [2018-10-25 04:22:41] Log file          /dev/shm/proxysql/proxysql_6032/cluster_one_proxysql_galera_check.log
      [2018-10-25 04:22:41] Mode              singlewrite
      [2018-10-25 04:22:41] ###### HANDLE WRITER NODES ######
      [2018-10-25 04:22:41] --> Checking WRITE server 20:127.0.0.1:26100, current status ONLINE, wsrep_local_state 4
      [2018-10-25 04:22:41] server 20:127.0.0.1:26100 is already ONLINE: 1 of 1 write nodes
      [2018-10-25 04:22:41] ###### HANDLE READER NODES ######
      [2018-10-25 04:22:41] --> Checking READ server 21:127.0.0.1:26200, current status ONLINE, wsrep_local_state 4
      [2018-10-25 04:22:41] server 21:127.0.0.1:26200 is already ONLINE
      [2018-10-25 04:22:41] --> Checking READ server 21:127.0.0.1:26300, current status ONLINE, wsrep_local_state 4
      [2018-10-25 04:22:41] server 21:127.0.0.1:26300 is already ONLINE
      [2018-10-25 04:22:41] --> Checking SLAVE server 21:127.0.0.1:30100
      [2018-10-25 04:22:41] slave server (21:127.0.0.1:30100) current status 'ONLINE' in ProxySQL. (io:Yes sql:Yes)
      [2018-10-25 04:22:41] --> Checking READ server 21:127.0.0.1:26100, current status OFFLINE_SOFT, wsrep_local_state 4
      [2018-10-25 04:22:41] server 21:127.0.0.1:26100 is OFFLINE_SOFT, keeping node as OFFLINE_SOFT,as it is an ONLINE writer and we prefer not to have writers as readers (writer-is-reader:ondemand)
      [2018-10-25 04:22:41] ###### SUMMARY ######
      [2018-10-25 04:22:41] --> Number of writers that are 'ONLINE': 1 : hostgroup: 20
      [2018-10-25 04:22:41] --> Number of readers that are 'ONLINE': 2 : hostgroup: 21
      [2018-10-25 04:22:41] ###### ASYNC-SLAVE ACTIVITY ######
      [2018-10-25 04:22:41] ###### Not loading mysql_servers, no change needed ######
       
      [2018-10-25 04:36:44] Percona XtraDB Cluster membership looks good
      [2018-10-25 04:36:47] ###### Percona XtraDB Cluster status ######
      [2018-10-25 04:36:47] Cluster node (20:127.0.0.1:26100) current status 'ONLINE' in ProxySQL.
      [2018-10-25 04:36:47] Cluster node (21:127.0.0.1:26200) current status 'ONLINE' in ProxySQL.
      [2018-10-25 04:36:47] Cluster node (21:127.0.0.1:26300) current status 'ONLINE' in ProxySQL.
      [2018-10-25 04:36:47] Percona XtraDB Cluster membership looks good
      [2018-10-25 04:36:50] ###### Percona XtraDB Cluster status ######
      [2018-10-25 04:36:50] Cluster node (20:127.0.0.1:26100) current status 'ONLINE' in ProxySQL.
      [2018-10-25 04:36:50] Cluster node (21:127.0.0.1:26200) current status 'ONLINE' in ProxySQL.
      [2018-10-25 04:36:50] Cluster node (21:127.0.0.1:26300) current status 'ONLINE' in ProxySQL.
       

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                kenn.takara Kenn Takara
                Reporter:
                ramesh.sivaraman Ramesh Sivaraman
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: