Skip to content

Instantly share code, notes, and snippets.

@altmannmarcelo

altmannmarcelo/Issue 2711 proxysql.log

Created May 20, 2020 16:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save altmannmarcelo/7779d18b930cd6a67c1bde7f405a55bf to your computer and use it in GitHub Desktop.
Save altmannmarcelo/7779d18b930cd6a67c1bde7f405a55bf to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Issue 2711 proxysql.log
2020-05-20 15:55:34 [INFO] ProxySQL version 2.0.12-38-g58a909a
2020-05-20 15:55:34 [INFO] Detected OS: Linux marcelo-2711-proxysql-1 5.4.0-28-generic #32-Ubuntu SMP Wed Apr 22 17:40:10 UTC 2020 x86_64
2020-05-20 15:55:34 [INFO] ProxySQL SHA1 checksum: 46f8b8fb1e79484931cdaedb6c200dea3e5c0dea
2020-05-20 15:55:34 [INFO] Starting ProxySQL
2020-05-20 15:55:34 [INFO] Sucessfully started
2020-05-20 15:55:34 [INFO] Angel process started ProxySQL process 734330
Standard ProxySQL MySQL Logger rev. 2.0.0714 -- MySQL_Logger.cpp -- Sun May 17 20:24:24 2020
Standard ProxySQL Cluster rev. 0.4.0906 -- ProxySQL_Cluster.cpp -- Sun May 17 20:24:24 2020
Standard ProxySQL Statistics rev. 1.4.1027 -- ProxySQL_Statistics.cpp -- Sun May 17 20:24:24 2020
Standard ProxySQL HTTP Server Handler rev. 1.4.1031 -- ProxySQL_HTTP_Server.cpp -- Sun May 17 20:24:24 2020
2020-05-20 15:55:34 ProxySQL_Admin.cpp:5458:flush_mysql_variables___database_to_runtime(): [WARNING] The default_character_set_results set to invalid value in the configuration file. Changing to default utf8
2020-05-20 15:55:34 ProxySQL_Admin.cpp:5458:flush_mysql_variables___database_to_runtime(): [WARNING] The default_CHARSET set to invalid value in the configuration file. Changing to default utf8
2020-05-20 15:55:34 ProxySQL_Admin.cpp:5458:flush_mysql_variables___database_to_runtime(): [WARNING] The default_character_set_connection set to invalid value in the configuration file. Changing to default utf8
2020-05-20 15:55:34 ProxySQL_Admin.cpp:5458:flush_mysql_variables___database_to_runtime(): [WARNING] The default_character_set_client set to invalid value in the configuration file. Changing to default utf8
2020-05-20 15:55:34 ProxySQL_Admin.cpp:5458:flush_mysql_variables___database_to_runtime(): [WARNING] The default_character_set_database set to invalid value in the configuration file. Changing to default utf8
Standard ProxySQL Admin rev. 2.0.6.0805 -- ProxySQL_Admin.cpp -- Sun May 17 20:24:24 2020
2020-05-20 15:55:34 [INFO] ProxySQL SHA1 checksum: 46f8b8fb1e79484931cdaedb6c200dea3e5c0dea
Standard MySQL Threads Handler rev. 0.2.0902 -- MySQL_Thread.cpp -- Sun May 17 20:24:24 2020
Standard MySQL Authentication rev. 0.2.0902 -- MySQL_Authentication.cpp -- Sun May 17 20:24:24 2020
2020-05-20 15:55:34 [INFO] Dumping mysql_servers_incoming
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 21 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2020-05-20 15:55:34 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2020-05-20 15:55:34 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 21 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2020-05-20 15:55:34 [INFO] Creating new server in HG 21 : 10.15.241.229:3306 , gtid_port=0, weight=1, status=0
2020-05-20 15:55:34 [INFO] Creating new server in HG 21 : 10.15.241.9:3306 , gtid_port=0, weight=1, status=0
2020-05-20 15:55:34 [INFO] Creating new server in HG 21 : 10.15.241.103:3306 , gtid_port=0, weight=1, status=0
2020-05-20 15:55:34 [INFO] New mysql_group_replication_hostgroups table
2020-05-20 15:55:34 [INFO] New mysql_galera_hostgroups table
2020-05-20 15:55:34 [INFO] Loading Galera info for (10,21,11,22,on,1,2,150,"PXC Prod Cluster")
2020-05-20 15:55:34 [INFO] New mysql_aws_aurora_hostgroups table
2020-05-20 15:55:34 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms
Standard Query Processor rev. 2.0.6.0805 -- Query_Processor.cpp -- Sun May 17 20:24:24 2020
In memory Standard Query Cache (SQC) rev. 1.2.0905 -- Query_Cache.cpp -- Sun May 17 20:24:24 2020
Standard MySQL Monitor (StdMyMon) rev. 2.0.1226 -- MySQL_Monitor.cpp -- Sun May 17 20:24:24 2020
2020-05-20 15:55:34 MySQL_HostGroups_Manager.cpp:4721:update_galera_set_writer(): [WARNING] Galera: setting host 10.15.241.103:3306 as writer
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 21 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: ALL
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839680 |
| 21 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839200 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:34 [INFO] Dumping mysql_servers_incoming
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 21 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 11 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 11 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2020-05-20 15:55:34 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-----------------+--------------+---------------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-----------------+--------------+---------------+------+
| 139988603839680 | 21 | 10.15.241.103 | 3306 |
+-----------------+--------------+---------------+------+
2020-05-20 15:55:34 MySQL_HostGroups_Manager.cpp:1268:commit(): [WARNING] Removed server at address 139988603839680, hostgroup 21, address 10.15.241.103 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2020-05-20 15:55:34 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 11 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 11 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2020-05-20 15:55:34 [INFO] Creating new server in HG 10 : 10.15.241.103:3306 , gtid_port=0, weight=1, status=0
2020-05-20 15:55:34 [INFO] Creating new server in HG 11 : 10.15.241.229:3306 , gtid_port=0, weight=1, status=0
2020-05-20 15:55:34 [INFO] Creating new server in HG 11 : 10.15.241.9:3306 , gtid_port=0, weight=1, status=0
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 21 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: ALL
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
| 11 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434104800 |
| 11 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434104640 |
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434104480 |
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988603839680 |
| 21 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839200 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:34 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup 10
HID: 10 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: HG 10
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434104480 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup 21
HID: 21 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: HG 21
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988603839680 |
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
| 21 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839200 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup 11
HID: 11 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: HG 11
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 11 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434104640 |
| 11 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434104800 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup 22
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: HG 22
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
2020-05-20 15:55:34 MySQL_HostGroups_Manager.cpp:4721:update_galera_set_writer(): [WARNING] Galera: setting host 10.15.241.229:3306 as writer
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 21 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: ALL
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
| 11 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434104800 |
| 11 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434104640 |
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434104480 |
| 21 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839200 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:34 [INFO] Dumping mysql_servers_incoming
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 21 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 11 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2020-05-20 15:55:34 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-----------------+--------------+---------------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-----------------+--------------+---------------+------+
| 139988603839520 | 21 | 10.15.241.229 | 3306 |
| 139988434104640 | 11 | 10.15.241.229 | 3306 |
| 139988434104480 | 10 | 10.15.241.103 | 3306 |
+-----------------+--------------+---------------+------+
2020-05-20 15:55:34 MySQL_HostGroups_Manager.cpp:1268:commit(): [WARNING] Removed server at address 139988603839520, hostgroup 21, address 10.15.241.229 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2020-05-20 15:55:34 MySQL_HostGroups_Manager.cpp:1268:commit(): [WARNING] Removed server at address 139988434104640, hostgroup 11, address 10.15.241.229 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2020-05-20 15:55:34 MySQL_HostGroups_Manager.cpp:1268:commit(): [WARNING] Removed server at address 139988434104480, hostgroup 10, address 10.15.241.103 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2020-05-20 15:55:34 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2020-05-20 15:55:34 [INFO] Creating new server in HG 21 : 10.15.241.103:3306 , gtid_port=0, weight=1, status=0
2020-05-20 15:55:34 [INFO] Creating new server in HG 10 : 10.15.241.229:3306 , gtid_port=0, weight=1, status=0
2020-05-20 15:55:34 [INFO] Creating new server in HG 11 : 10.15.241.103:3306 , gtid_port=0, weight=1, status=0
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 21 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: ALL
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910496 |
| 11 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434104800 |
| 11 | 10.15.241.229 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988434104640 |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910336 |
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988434104480 |
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839680 |
| 21 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839200 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:34 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup 10
HID: 10 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: HG 10
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988434104480 |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910336 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup 21
HID: 21 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: HG 21
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839680 |
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
| 21 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839200 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup 11
HID: 11 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: HG 11
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910496 |
| 11 | 10.15.241.229 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988434104640 |
| 11 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434104800 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup 22
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: HG 22
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
2020-05-20 15:55:34 MySQL_HostGroups_Manager.cpp:4721:update_galera_set_writer(): [WARNING] Galera: setting host 10.15.241.9:3306 as writer
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 21 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: ALL
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839680 |
| 11 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434104800 |
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910496 |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910336 |
| 21 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839200 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:34 [INFO] Dumping mysql_servers_incoming
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | |
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 11 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2020-05-20 15:55:34 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-----------------+--------------+---------------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-----------------+--------------+---------------+------+
| 139988434104800 | 11 | 10.15.241.9 | 3306 |
| 139988429910336 | 10 | 10.15.241.229 | 3306 |
| 139988603839200 | 21 | 10.15.241.9 | 3306 |
+-----------------+--------------+---------------+------+
2020-05-20 15:55:34 MySQL_HostGroups_Manager.cpp:1268:commit(): [WARNING] Removed server at address 139988434104800, hostgroup 11, address 10.15.241.9 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2020-05-20 15:55:34 MySQL_HostGroups_Manager.cpp:1268:commit(): [WARNING] Removed server at address 139988429910336, hostgroup 10, address 10.15.241.229 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2020-05-20 15:55:34 MySQL_HostGroups_Manager.cpp:1268:commit(): [WARNING] Removed server at address 139988603839200, hostgroup 21, address 10.15.241.9 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2020-05-20 15:55:34 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | |
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 11 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2020-05-20 15:55:34 [INFO] Creating new server in HG 10 : 10.15.241.103:3306 , gtid_port=0, weight=1, status=3
2020-05-20 15:55:34 [INFO] Creating new server in HG 21 : 10.15.241.229:3306 , gtid_port=0, weight=1, status=0
2020-05-20 15:55:34 [INFO] Creating new server in HG 10 : 10.15.241.9:3306 , gtid_port=0, weight=1, status=0
2020-05-20 15:55:34 [INFO] Creating new server in HG 11 : 10.15.241.229:3306 , gtid_port=0, weight=1, status=0
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 21 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: ALL
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839680 |
| 11 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434105120 |
| 11 | 10.15.241.9 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988434104800 |
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910496 |
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988434104640 |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988429910336 |
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434104480 |
| 21 | 10.15.241.9 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988603839200 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:34 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup 10
HID: 10 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: HG 10
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988434104640 |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988429910336 |
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup 21
HID: 21 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: HG 21
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839680 |
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434104480 |
| 21 | 10.15.241.9 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988603839200 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup 11
HID: 11 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: HG 11
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910496 |
| 11 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434105120 |
| 11 | 10.15.241.9 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988434104800 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:34 [INFO] Dumping current MySQL Servers structures for hostgroup 22
2020-05-20 15:55:34 [INFO] Dumping mysql_servers: HG 22
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
2020-05-20 15:55:35 [INFO] Latest ProxySQL version available: 2.0.12-38-g58a909ae
2020-05-20 15:55:54 [INFO] Galera: max_writers=1 , moving 1 nodes from backup HG 21 to writer HG 10
2020-05-20 15:55:54 MySQL_HostGroups_Manager.cpp:4425:update_galera_set_offline(): [WARNING] Galera: setting host 10.15.241.9:3306 offline because: pxc_maint_mode=YES
2020-05-20 15:55:54 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 21 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:54 [INFO] Dumping mysql_servers: ALL
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839680 |
| 11 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434105120 |
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910496 |
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434104480 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:54 [INFO] Dumping mysql_servers_incoming
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2020-05-20 15:55:54 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-----------------+--------------+---------------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-----------------+--------------+---------------+------+
| 139988434105120 | 11 | 10.15.241.229 | 3306 |
| 139988434104480 | 21 | 10.15.241.229 | 3306 |
+-----------------+--------------+---------------+------+
2020-05-20 15:55:54 MySQL_HostGroups_Manager.cpp:1268:commit(): [WARNING] Removed server at address 139988434105120, hostgroup 11, address 10.15.241.229 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2020-05-20 15:55:54 MySQL_HostGroups_Manager.cpp:1268:commit(): [WARNING] Removed server at address 139988434104480, hostgroup 21, address 10.15.241.229 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2020-05-20 15:55:54 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2020-05-20 15:55:54 [INFO] Changing status for server 10:10.15.241.9:3306 (10.15.241.9:3306) from 0 (0) to 1
2020-05-20 15:55:54 [INFO] Creating new server in HG 10 : 10.15.241.229:3306 , gtid_port=0, weight=1, status=0
2020-05-20 15:55:54 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 21 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:54 [INFO] Dumping mysql_servers: ALL
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839680 |
| 11 | 10.15.241.229 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988434105120 |
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910496 |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434105280 |
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988434104480 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:54 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2020-05-20 15:55:54 [INFO] Dumping current MySQL Servers structures for hostgroup 10
HID: 10 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:54 [INFO] Dumping mysql_servers: HG 10
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434105280 |
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:54 [INFO] Dumping current MySQL Servers structures for hostgroup 21
HID: 21 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 21 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:54 [INFO] Dumping mysql_servers: HG 21
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839680 |
| 21 | 10.15.241.229 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988434104480 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:54 [INFO] Dumping current MySQL Servers structures for hostgroup 11
HID: 11 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:55:54 [INFO] Dumping mysql_servers: HG 11
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910496 |
| 11 | 10.15.241.229 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988434105120 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:55:54 [INFO] Dumping current MySQL Servers structures for hostgroup 22
2020-05-20 15:55:54 [INFO] Dumping mysql_servers: HG 22
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
2020-05-20 15:55:59 MySQL_HostGroups_Manager.cpp:4455:update_galera_set_offline(): [WARNING] Galera: skipping setting offline node 10.15.241.9:3306 from hostgroup 10 because won't change the list of ONLINE nodes
2020-05-20 15:56:04 MySQL_HostGroups_Manager.cpp:4455:update_galera_set_offline(): [WARNING] Galera: skipping setting offline node 10.15.241.9:3306 from hostgroup 10 because won't change the list of ONLINE nodes
2020-05-20 15:56:09 MySQL_HostGroups_Manager.cpp:4455:update_galera_set_offline(): [WARNING] Galera: skipping setting offline node 10.15.241.9:3306 from hostgroup 10 because won't change the list of ONLINE nodes
2020-05-20 15:56:14 MySQL_HostGroups_Manager.cpp:4455:update_galera_set_offline(): [WARNING] Galera: skipping setting offline node 10.15.241.9:3306 from hostgroup 10 because won't change the list of ONLINE nodes
2020-05-20 15:56:44 [INFO] Galera: max_writers=1 , moving 1 nodes from backup HG 21 to writer HG 10
2020-05-20 15:56:44 MySQL_HostGroups_Manager.cpp:4425:update_galera_set_offline(): [WARNING] Galera: setting host 10.15.241.229:3306 offline because: pxc_maint_mode=YES
2020-05-20 15:56:44 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 21 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:56:44 [INFO] Dumping mysql_servers: ALL
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988603839680 |
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910496 |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434105280 |
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:56:44 [INFO] Dumping mysql_servers_incoming
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2020-05-20 15:56:44 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-----------------+--------------+---------------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-----------------+--------------+---------------+------+
| 139988603839680 | 21 | 10.15.241.103 | 3306 |
+-----------------+--------------+---------------+------+
2020-05-20 15:56:44 MySQL_HostGroups_Manager.cpp:1268:commit(): [WARNING] Removed server at address 139988603839680, hostgroup 21, address 10.15.241.103 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2020-05-20 15:56:44 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988434105280 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 0 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2020-05-20 15:56:44 [INFO] Changing status for server 10:10.15.241.229:3306 (10.15.241.229:3306) from 0 (0) to 1
2020-05-20 15:56:44 [INFO] Creating new server in HG 10 : 10.15.241.103:3306 , gtid_port=0, weight=1, status=0
2020-05-20 15:56:44 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 21 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:56:44 [INFO] Dumping mysql_servers: ALL
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988603839680 |
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910496 |
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910656 |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988434105280 |
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:56:44 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms
2020-05-20 15:56:44 [INFO] Dumping current MySQL Servers structures for hostgroup 10
HID: 10 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:56:44 [INFO] Dumping mysql_servers: HG 10
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910656 |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988434105280 |
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:56:44 [INFO] Dumping current MySQL Servers structures for hostgroup 21
HID: 21 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:56:44 [INFO] Dumping mysql_servers: HG 21
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 21 | 10.15.241.103 | 3306 | 0 | 1 | 3 | 0 | 1000 | 0 | 0 | 0 | | 139988603839680 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:56:44 [INFO] Dumping current MySQL Servers structures for hostgroup 11
HID: 11 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:56:44 [INFO] Dumping mysql_servers: HG 11
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910496 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:56:44 [INFO] Dumping current MySQL Servers structures for hostgroup 22
2020-05-20 15:56:44 [INFO] Dumping mysql_servers: HG 22
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
2020-05-20 15:56:49 MySQL_HostGroups_Manager.cpp:4455:update_galera_set_offline(): [WARNING] Galera: skipping setting offline node 10.15.241.229:3306 from hostgroup 10 because won't change the list of ONLINE nodes
2020-05-20 15:56:54 MySQL_HostGroups_Manager.cpp:4455:update_galera_set_offline(): [WARNING] Galera: skipping setting offline node 10.15.241.229:3306 from hostgroup 10 because won't change the list of ONLINE nodes
2020-05-20 15:56:59 MySQL_HostGroups_Manager.cpp:4455:update_galera_set_offline(): [WARNING] Galera: skipping setting offline node 10.15.241.229:3306 from hostgroup 10 because won't change the list of ONLINE nodes
2020-05-20 15:57:04 MySQL_HostGroups_Manager.cpp:4455:update_galera_set_offline(): [WARNING] Galera: skipping setting offline node 10.15.241.229:3306 from hostgroup 10 because won't change the list of ONLINE nodes
2020-05-20 15:57:29 MySQL_HostGroups_Manager.cpp:4425:update_galera_set_offline(): [WARNING] Galera: setting host 10.15.241.103:3306 offline because: pxc_maint_mode=YES
2020-05-20 15:57:29 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:57:29 [INFO] Dumping mysql_servers: ALL
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910496 |
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910656 |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988434105280 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:57:29 [INFO] Dumping mysql_servers_incoming
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | |
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2020-05-20 15:57:29 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2020-05-20 15:57:29 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910496 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | |
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 0 | 0 | 1000 | 0 | 0 | 0 | | 139988429910656 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2020-05-20 15:57:29 [INFO] Changing status for server 11:10.15.241.103:3306 (10.15.241.103:3306) from 0 (0) to 1
2020-05-20 15:57:29 [INFO] Changing status for server 10:10.15.241.103:3306 (10.15.241.103:3306) from 0 (0) to 1
2020-05-20 15:57:29 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 11 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:57:29 [INFO] Dumping mysql_servers: ALL
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988429910496 |
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988429910656 |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988434105280 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:57:29 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms
2020-05-20 15:57:29 [INFO] Dumping current MySQL Servers structures for hostgroup 10
HID: 10 , address: 10.15.241.9 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.229 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 10 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:57:29 [INFO] Dumping mysql_servers: HG 10
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10 | 10.15.241.103 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988429910656 |
| 10 | 10.15.241.229 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988434105280 |
| 10 | 10.15.241.9 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988603839520 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:57:29 [INFO] Dumping current MySQL Servers structures for hostgroup 21
2020-05-20 15:57:29 [INFO] Dumping mysql_servers: HG 21
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
2020-05-20 15:57:29 [INFO] Dumping current MySQL Servers structures for hostgroup 11
HID: 11 , address: 10.15.241.103 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 1000 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2020-05-20 15:57:29 [INFO] Dumping mysql_servers: HG 11
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 11 | 10.15.241.103 | 3306 | 0 | 1 | 1 | 0 | 1000 | 0 | 0 | 0 | | 139988429910496 |
+-----+---------------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2020-05-20 15:57:29 [INFO] Dumping current MySQL Servers structures for hostgroup 22
2020-05-20 15:57:29 [INFO] Dumping mysql_servers: HG 22
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
2020-05-20 15:57:34 MySQL_HostGroups_Manager.cpp:4455:update_galera_set_offline(): [WARNING] Galera: skipping setting offline node 10.15.241.103:3306 from hostgroup 10 because won't change the list of ONLINE nodes
2020-05-20 15:57:39 MySQL_HostGroups_Manager.cpp:4455:update_galera_set_offline(): [WARNING] Galera: skipping setting offline node 10.15.241.103:3306 from hostgroup 10 because won't change the list of ONLINE nodes
2020-05-20 15:57:44 MySQL_HostGroups_Manager.cpp:4455:update_galera_set_offline(): [WARNING] Galera: skipping setting offline node 10.15.241.103:3306 from hostgroup 10 because won't change the list of ONLINE nodes
2020-05-20 15:57:49 MySQL_HostGroups_Manager.cpp:4455:update_galera_set_offline(): [WARNING] Galera: skipping setting offline node 10.15.241.103:3306 from hostgroup 10 because won't change the list of ONLINE nodes
2020-05-20 16:00:56 ProxySQL_GloVars.cpp:9:term_handler(): [WARNING] Received TERM signal: shutdown in progress...
2020-05-20 16:00:56 [INFO] Starting shutdown...
2020-05-20 16:00:56 [INFO] Shutdown completed!
2020-05-20 16:00:56 [INFO] Exiting...
2020-05-20 16:00:56 [INFO] Shutdown angel process
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment