Wed Nov 15 08:48:39 CET 2017 ###### proxysql_galera_checker.sh SUMMARY ###### Wed Nov 15 08:48:39 CET 2017 Hostgroup writers 500 Wed Nov 15 08:48:39 CET 2017 Hostgroup readers 501 Wed Nov 15 08:48:39 CET 2017 Number of writers 1 Wed Nov 15 08:48:39 CET 2017 Writers are readers 0 Wed Nov 15 08:48:39 CET 2017 log file /var/lib/proxysql/proxysql_galera_checker.log Wed Nov 15 08:48:39 CET 2017 ###### HANDLE WRITER NODES ###### Wed Nov 15 08:48:39 CET 2017 --> Checking WRITE server 500:192.168.0.51:3306, current status ONLINE, wsrep_local_state 4 Wed Nov 15 08:48:39 CET 2017 server 500:192.168.0.51:3306 is already ONLINE: 1 of 1 write nodes Wed Nov 15 08:48:39 CET 2017 --> Checking WRITE server 500:192.168.0.52:3306, current status OFFLINE_SOFT, wsrep_local_state 4 Wed Nov 15 08:48:39 CET 2017 server 500:192.168.0.52:3306 is already OFFLINE_SOFT, max write nodes reached (1) Wed Nov 15 08:48:39 CET 2017 --> Checking WRITE server 500:192.168.0.53:3306, current status OFFLINE_SOFT, wsrep_local_state 4 Wed Nov 15 08:48:39 CET 2017 server 500:192.168.0.53:3306 is already OFFLINE_SOFT, max write nodes reached (1) Wed Nov 15 08:48:39 CET 2017 ###### HANDLE READER NODES ###### Wed Nov 15 08:48:39 CET 2017 --> Checking READ server 501:192.168.0.52:3306, current status ONLINE, wsrep_local_state 4 Wed Nov 15 08:48:39 CET 2017 server 501:192.168.0.52:3306 is already ONLINE Wed Nov 15 08:48:39 CET 2017 --> Checking READ server 501:192.168.0.53:3306, current status ONLINE, wsrep_local_state 4 Wed Nov 15 08:48:39 CET 2017 server 501:192.168.0.53:3306 is already ONLINE Wed Nov 15 08:48:39 CET 2017 --> Checking READ server 501:192.168.0.51:3306, current status OFFLINE_SOFT, wsrep_local_state 4 Wed Nov 15 08:48:39 CET 2017 server 501:192.168.0.51:3306 is OFFLINE_SOFT, keeping node in OFFLINE_SOFT is a writer ONLINE and it's preferred not to have writers as readers Wed Nov 15 08:48:39 CET 2017 ###### SUMMARY ###### Wed Nov 15 08:48:39 CET 2017 --> Number of writers that are 'ONLINE': 1 : hostgroup: 500 Wed Nov 15 08:48:39 CET 2017 --> Number of readers that are 'ONLINE': 2 : hostgroup: 501 Wed Nov 15 08:48:39 CET 2017 ###### Not loading mysql_servers, no change needed ###### Wed Nov 15 08:48:49 CET 2017 ###### proxysql_galera_checker.sh SUMMARY ###### Wed Nov 15 08:48:49 CET 2017 Hostgroup writers 500 Wed Nov 15 08:48:49 CET 2017 Hostgroup readers 501 Wed Nov 15 08:48:49 CET 2017 Number of writers 1 Wed Nov 15 08:48:49 CET 2017 Writers are readers 0 Wed Nov 15 08:48:49 CET 2017 log file /var/lib/proxysql/proxysql_galera_checker.log Wed Nov 15 08:48:49 CET 2017 ###### HANDLE WRITER NODES ###### Wed Nov 15 08:48:49 CET 2017 --> Checking WRITE server 500:192.168.0.51:3306, current status ONLINE, wsrep_local_state 4 Wed Nov 15 08:48:49 CET 2017 server 500:192.168.0.51:3306 is already ONLINE: 1 of 1 write nodes Wed Nov 15 08:48:49 CET 2017 Changing server 500:192.168.0.51:3306 to status OFFLINE_SOFT due to SHUTDOWN Wed Nov 15 08:48:49 CET 2017 Changing server 500:192.168.0.51:3306 to status OFFLINE_SOFT. Reason: Changed server 500:192.168.0.51:3306 to status OFFLINE_SOFT due to SHUTDOWN Wed Nov 15 08:48:49 CET 2017 --> Checking WRITE server 500:192.168.0.52:3306, current status OFFLINE_SOFT, wsrep_local_state 4 Wed Nov 15 08:48:49 CET 2017 server 500:192.168.0.52:3306 is already OFFLINE_SOFT, max write nodes reached (1) Wed Nov 15 08:48:49 CET 2017 --> Checking WRITE server 500:192.168.0.53:3306, current status OFFLINE_SOFT, wsrep_local_state 4 Wed Nov 15 08:48:49 CET 2017 server 500:192.168.0.53:3306 is already OFFLINE_SOFT, max write nodes reached (1) Wed Nov 15 08:48:49 CET 2017 ###### HANDLE READER NODES ###### Wed Nov 15 08:48:49 CET 2017 --> Checking READ server 501:192.168.0.52:3306, current status ONLINE, wsrep_local_state 4 Wed Nov 15 08:48:49 CET 2017 server 501:192.168.0.52:3306 is already ONLINE Wed Nov 15 08:48:49 CET 2017 --> Checking READ server 501:192.168.0.53:3306, current status ONLINE, wsrep_local_state 4 Wed Nov 15 08:48:49 CET 2017 server 501:192.168.0.53:3306 is already ONLINE Wed Nov 15 08:48:49 CET 2017 --> Checking READ server 501:192.168.0.51:3306, current status OFFLINE_SOFT, wsrep_local_state 4 Wed Nov 15 08:48:49 CET 2017 server 501:192.168.0.51:3306 is OFFLINE_SOFT Wed Nov 15 08:48:49 CET 2017 ###### SUMMARY ###### Wed Nov 15 08:48:49 CET 2017 --> Number of writers that are 'ONLINE': 0 : hostgroup: 500 Wed Nov 15 08:48:49 CET 2017 --> Number of readers that are 'ONLINE': 2 : hostgroup: 501 Wed Nov 15 08:48:49 CET 2017 No writers found, Trying to enable last available node of the cluster (in Donor/Desync state) Wed Nov 15 08:48:49 CET 2017 Check server 500:192.168.0.51:3306 for only available node in DONOR state, status OFFLINE_SOFT , wsrep_local_state 4 Wed Nov 15 08:48:49 CET 2017 Check server 500:192.168.0.51:3306 for only available node in DONOR state, status OFFLINE_SOFT , wsrep_local_state 4 Wed Nov 15 08:48:50 CET 2017 Check server 500:192.168.0.51:3306 for only available node in DONOR state, status OFFLINE_SOFT , wsrep_local_state 4 Wed Nov 15 08:48:50 CET 2017 Check server 500:192.168.0.51:3306 for only available node in DONOR state, status OFFLINE_SOFT , wsrep_local_state 4 Wed Nov 15 08:48:50 CET 2017 Check server 500:192.168.0.51:3306 for only available node in DONOR state, status OFFLINE_SOFT , wsrep_local_state 4 Wed Nov 15 08:48:50 CET 2017 Check server 500:192.168.0.52:3306 for only available node in DONOR state, status OFFLINE_SOFT , wsrep_local_state 4 Wed Nov 15 08:48:50 CET 2017 Check server 500:192.168.0.52:3306 for only available node in DONOR state, status OFFLINE_SOFT , wsrep_local_state 4 Wed Nov 15 08:48:50 CET 2017 Check server 500:192.168.0.52:3306 for only available node in DONOR state, status OFFLINE_SOFT , wsrep_local_state 4 Wed Nov 15 08:48:50 CET 2017 Check server 500:192.168.0.52:3306 for only available node in DONOR state, status OFFLINE_SOFT , wsrep_local_state 4 Wed Nov 15 08:48:50 CET 2017 Check server 500:192.168.0.52:3306 for only available node in DONOR state, status OFFLINE_SOFT , wsrep_local_state 4 Wed Nov 15 08:48:50 CET 2017 Check server 500:192.168.0.53:3306 for only available node in DONOR state, status OFFLINE_SOFT , wsrep_local_state 4 Wed Nov 15 08:48:50 CET 2017 Check server 500:192.168.0.53:3306 for only available node in DONOR state, status OFFLINE_SOFT , wsrep_local_state 4 Wed Nov 15 08:48:50 CET 2017 Check server 500:192.168.0.53:3306 for only available node in DONOR state, status OFFLINE_SOFT , wsrep_local_state 4 Wed Nov 15 08:48:50 CET 2017 Check server 500:192.168.0.53:3306 for only available node in DONOR state, status OFFLINE_SOFT , wsrep_local_state 4 Wed Nov 15 08:48:50 CET 2017 Check server 500:192.168.0.53:3306 for only available node in DONOR state, status OFFLINE_SOFT , wsrep_local_state 4 Wed Nov 15 08:48:50 CET 2017 ###### Not loading mysql_servers, no change needed ###### Wed Nov 15 08:48:59 CET 2017 ###### proxysql_galera_checker.sh SUMMARY ###### Wed Nov 15 08:48:59 CET 2017 Hostgroup writers 500 Wed Nov 15 08:48:59 CET 2017 Hostgroup readers 501 Wed Nov 15 08:48:59 CET 2017 Number of writers 1 Wed Nov 15 08:48:59 CET 2017 Writers are readers 0 Wed Nov 15 08:48:59 CET 2017 log file /var/lib/proxysql/proxysql_galera_checker.log Wed Nov 15 08:48:59 CET 2017 ###### HANDLE WRITER NODES ###### Wed Nov 15 08:48:59 CET 2017 --> Checking WRITE server 500:192.168.0.52:3306, current status OFFLINE_SOFT, wsrep_local_state 4 Wed Nov 15 08:48:59 CET 2017 Changing server 500:192.168.0.52:3306 to status ONLINE. Reason: {NUMBER_WRITERS_ONLINE} of 1 write nodes Wed Nov 15 08:48:59 CET 2017 --> Checking WRITE server 500:192.168.0.53:3306, current status OFFLINE_SOFT, wsrep_local_state 4 Wed Nov 15 08:48:59 CET 2017 server 500:192.168.0.53:3306 is already OFFLINE_SOFT, max write nodes reached (1) Wed Nov 15 08:48:59 CET 2017 ###### HANDLE READER NODES ###### Wed Nov 15 08:48:59 CET 2017 --> Checking READ server 501:192.168.0.53:3306, current status ONLINE, wsrep_local_state 4 Wed Nov 15 08:48:59 CET 2017 server 501:192.168.0.53:3306 is already ONLINE Wed Nov 15 08:48:59 CET 2017 --> Checking READ server 501:192.168.0.52:3306, current status ONLINE, wsrep_local_state 4 Wed Nov 15 08:48:59 CET 2017 Changing server 501:192.168.0.52:3306 to status OFFLINE_SOFT. Reason: making ONLINE writer node as read OFFLINE_SOFT as well because writers should not be readers Wed Nov 15 08:48:59 CET 2017 ###### SUMMARY ###### Wed Nov 15 08:48:59 CET 2017 --> Number of writers that are 'ONLINE': 1 : hostgroup: 500 Wed Nov 15 08:48:59 CET 2017 --> Number of readers that are 'ONLINE': 1 : hostgroup: 501 Wed Nov 15 08:48:59 CET 2017 ###### Loading mysql_servers config into runtime ###### Wed Nov 15 08:49:09 CET 2017 ###### proxysql_galera_checker.sh SUMMARY ###### Wed Nov 15 08:49:09 CET 2017 Hostgroup writers 500 Wed Nov 15 08:49:09 CET 2017 Hostgroup readers 501 Wed Nov 15 08:49:09 CET 2017 Number of writers 1 Wed Nov 15 08:49:09 CET 2017 Writers are readers 0 Wed Nov 15 08:49:09 CET 2017 log file /var/lib/proxysql/proxysql_galera_checker.log Wed Nov 15 08:49:09 CET 2017 ###### HANDLE WRITER NODES ###### Wed Nov 15 08:49:09 CET 2017 --> Checking WRITE server 500:192.168.0.52:3306, current status ONLINE, wsrep_local_state 4 Wed Nov 15 08:49:09 CET 2017 server 500:192.168.0.52:3306 is already ONLINE: 1 of 1 write nodes Wed Nov 15 08:49:09 CET 2017 --> Checking WRITE server 500:192.168.0.53:3306, current status OFFLINE_SOFT, wsrep_local_state 4 Wed Nov 15 08:49:09 CET 2017 server 500:192.168.0.53:3306 is already OFFLINE_SOFT, max write nodes reached (1) Wed Nov 15 08:49:09 CET 2017 ###### HANDLE READER NODES ###### Wed Nov 15 08:49:09 CET 2017 --> Checking READ server 501:192.168.0.53:3306, current status ONLINE, wsrep_local_state 4 Wed Nov 15 08:49:09 CET 2017 server 501:192.168.0.53:3306 is already ONLINE Wed Nov 15 08:49:10 CET 2017 --> Checking READ server 501:192.168.0.52:3306, current status OFFLINE_SOFT, wsrep_local_state 4 Wed Nov 15 08:49:10 CET 2017 server 501:192.168.0.52:3306 is OFFLINE_SOFT, keeping node in OFFLINE_SOFT is a writer ONLINE and it's preferred not to have writers as readers Wed Nov 15 08:49:10 CET 2017 ###### SUMMARY ###### Wed Nov 15 08:49:10 CET 2017 --> Number of writers that are 'ONLINE': 1 : hostgroup: 500 Wed Nov 15 08:49:10 CET 2017 --> Number of readers that are 'ONLINE': 1 : hostgroup: 501 Wed Nov 15 08:49:10 CET 2017 ###### Not loading mysql_servers, no change needed ###### Wed Nov 15 08:49:19 CET 2017 ###### proxysql_galera_checker.sh SUMMARY ###### Wed Nov 15 08:49:19 CET 2017 Hostgroup writers 500 Wed Nov 15 08:49:19 CET 2017 Hostgroup readers 501 Wed Nov 15 08:49:19 CET 2017 Number of writers 1 Wed Nov 15 08:49:19 CET 2017 Writers are readers 0 Wed Nov 15 08:49:19 CET 2017 log file /var/lib/proxysql/proxysql_galera_checker.log Wed Nov 15 08:49:19 CET 2017 ###### HANDLE WRITER NODES ###### Wed Nov 15 08:49:19 CET 2017 --> Checking WRITE server 500:192.168.0.52:3306, current status ONLINE, wsrep_local_state 4 Wed Nov 15 08:49:19 CET 2017 server 500:192.168.0.52:3306 is already ONLINE: 1 of 1 write nodes Wed Nov 15 08:49:19 CET 2017 --> Checking WRITE server 500:192.168.0.53:3306, current status OFFLINE_SOFT, wsrep_local_state 4 Wed Nov 15 08:49:19 CET 2017 server 500:192.168.0.53:3306 is already OFFLINE_SOFT, max write nodes reached (1) Wed Nov 15 08:49:19 CET 2017 ###### HANDLE READER NODES ###### Wed Nov 15 08:49:19 CET 2017 --> Checking READ server 501:192.168.0.51:3306, current status ONLINE, wsrep_local_state 4 Wed Nov 15 08:49:19 CET 2017 server 501:192.168.0.51:3306 is already ONLINE Wed Nov 15 08:49:20 CET 2017 --> Checking READ server 501:192.168.0.53:3306, current status ONLINE, wsrep_local_state 4 Wed Nov 15 08:49:20 CET 2017 server 501:192.168.0.53:3306 is already ONLINE Wed Nov 15 08:49:20 CET 2017 --> Checking READ server 501:192.168.0.52:3306, current status OFFLINE_SOFT, wsrep_local_state 4 Wed Nov 15 08:49:20 CET 2017 server 501:192.168.0.52:3306 is OFFLINE_SOFT, keeping node in OFFLINE_SOFT is a writer ONLINE and it's preferred not to have writers as readers Wed Nov 15 08:49:20 CET 2017 ###### SUMMARY ###### Wed Nov 15 08:49:20 CET 2017 --> Number of writers that are 'ONLINE': 1 : hostgroup: 500 Wed Nov 15 08:49:20 CET 2017 --> Number of readers that are 'ONLINE': 2 : hostgroup: 501 Wed Nov 15 08:49:20 CET 2017 ###### Not loading mysql_servers, no change needed ######