search

sysown / proxysql

High-performance MySQL proxy with a GPL license.
http://www.proxysql.com
GNU General Public License v3.0
6.06k stars 983 forks source link

Strange Behavior - Master / Slaves #4607

Closed MichalisDBA closed 3 months ago

MichalisDBA commented 3 months ago

Hello. We have a simple MySQL Master / Slave scenario. 1 Master and 2 Slaves. On freash install of ProxySQL latest version, i make the following steps.

Insert to mysql_servers on ProxySQL.

INSERT INTO mysql_servers (hostgroup_id, hostname, port, max_connections) VALUES (10, '10.1.0.10', 3306, 100);
INSERT INTO mysql_servers (hostgroup_id, hostname, port, max_connections) VALUES (20, '10.1.0.20', 3306, 100);
INSERT INTO mysql_servers (hostgroup_id, hostname, port, max_connections) VALUES (20, '10.1.0.40', 3306, 100);

INSERT INTO mysql_replication_hostgroups (writer_hostgroup, reader_hostgroup, check_type) VALUES (10, 20, 'read_only');

LOAD MYSQL SERVERS TO RUNTIME;
SAVE MYSQL SERVERS TO DISK;
UPDATE global_variables SET variable_value='monitor' WHERE variable_name='mysql-monitor_username';
UPDATE global_variables SET variable_value='monitor' WHERE variable_name='mysql-monitor_password';

LOAD MYSQL VARIABLES TO RUNTIME;
SAVE MYSQL VARIABLES TO DISK;

Check ProxySQL runtime_mysql_servers.

SELECT * FROM runtime_mysql_servers;
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname  | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | 10.1.0.10 | 3306 | 0         | ONLINE | 1      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | ONLINE | 1      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | ONLINE | 1      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+

If i change read_only on Master. The IP 10.1.0.10 goes to hostgroup 20 as expected. set global read_only=1;

SELECT * FROM runtime_mysql_servers;
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname  | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 20           | 10.1.0.10 | 3306 | 0         | ONLINE | 1      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | ONLINE | 1      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | ONLINE | 1      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+

Change read_only on Master back. set global read_only=0;

SELECT * FROM runtime_mysql_servers;
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname  | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | 10.1.0.10 | 3306 | 0         | ONLINE | 1      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.10 | 3306 | 0         | ONLINE | 1      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | ONLINE | 1      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | ONLINE | 1      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+

The first thing i want to ask is why not in the first place the runtime_mysql_servers does not output the above table with the 4 rows? Why 10.1.0.10 is not also on hostgroup 20 for read only without changing read_only on Master DB server and switch it back again?

The second thing i want to ask is that if i change the weights afterwards like:

UPDATE mysql_servers SET weight = 10 WHERE hostname = '10.1.0.20';
UPDATE mysql_servers SET weight = 10 WHERE hostname = '10.1.0.40';

LOAD MYSQL SERVERS TO RUNTIME;
SAVE MYSQL SERVERS TO DISK;

On stats_mysql_connection_pool the 10.1.0.10 on hostgroup 20 is OFFLINE_HARD. Why is this happening when changing the weight? Is this normal?

SELECT * FROM stats_mysql_connection_pool;
+-----------+-----------+----------+--------------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+
| hostgroup | srv_host  | srv_port | status       | ConnUsed | ConnFree | ConnOK | ConnERR | MaxConnUsed | Queries | Queries_GTID_sync | Bytes_data_sent | Bytes_data_recv | Latency_us |
+-----------+-----------+----------+--------------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+
| 10        | 10.1.0.10 | 3306     | ONLINE       | 0        | 0        | 0      | 0       | 0           | 0       | 0                 | 0               | 0               | 481        |
| 20        | 10.1.0.20 | 3306     | ONLINE       | 0        | 0        | 0      | 0       | 0           | 0       | 0                 | 0               | 0               | 459        |
| 20        | 10.1.0.40 | 3306     | ONLINE       | 0        | 0        | 0      | 0       | 0           | 0       | 0                 | 0               | 0               | 505        |
| 20        | 10.1.0.10 | 3306     | OFFLINE_HARD | 0        | 0        | 0      | 0       | 0           | 0       | 0                 | 0               | 0               | 481        |
+-----------+-----------+----------+--------------+----------+----------+--------+---------+-------------+---------+-------------------+-----------------+-----------------+------------+

Is this the best practice workflow to setup a 1 Master with 2 Slaves config?

Thank you.

renecannao commented 3 months ago

Please, read the log. Read the error log...

MichalisDBA commented 3 months ago

Sorry. I attach it

2024-08-13 17:52:03 [INFO] ProxySQL version 2.6.3-107-gcdfcfdc
2024-08-13 17:52:03 [INFO] Detected OS: Linux DB3 5.14.0-427.28.1.el9_4.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Aug 2 03:44:10 EDT 2024 x86_64
2024-08-13 17:52:03 [INFO] ProxySQL SHA1 checksum: b1bee1e8e3dd23c2083245d6ea8083ce7eda39e3
2024-08-13 17:52:03 [INFO] Starting ProxySQL
2024-08-13 17:52:03 [INFO] Successfully started
2024-08-13 17:52:03 [INFO] Angel process started ProxySQL process 40863
2024-08-13 17:52:03 [INFO] SSL keys/certificates found in datadir (/var/lib/proxysql): loading them.
2024-08-13 17:52:03 [INFO] Loaded built-in SQLite3
Standard ProxySQL MySQL Logger rev. 2.5.0421 -- MySQL_Logger.cpp -- Mon May 20 08:43:02 2024
Standard ProxySQL Cluster rev. 0.4.0906 -- ProxySQL_Cluster.cpp -- Mon May 20 08:43:02 2024
Standard ProxySQL Statistics rev. 1.4.1027 -- ProxySQL_Statistics.cpp -- Mon May 20 08:43:02 2024
2024-08-13 17:52:03 [INFO] Using UUID: ef135fc5-b45d-4583-ae2d-486f8e9fd9b3 , randomly generated. Writing it to database
2024-08-13 17:52:03 [INFO] Computed checksum for 'LOAD ADMIN VARIABLES TO RUNTIME' was '0xC932B2DAA28AE2CD', with epoch '1723560723'
2024-08-13 17:52:03 [INFO] Computed checksum for 'LOAD MYSQL VARIABLES TO RUNTIME' was '0xD40D0CDEC6B10FB9', with epoch '1723560723'
Standard ProxySQL Admin rev. 2.0.6.0805 -- ProxySQL_Admin.cpp -- Mon May 20 08:43:02 2024
2024-08-13 17:52:03 [INFO] ProxySQL SHA1 checksum: b1bee1e8e3dd23c2083245d6ea8083ce7eda39e3
Standard MySQL Threads Handler rev. 0.2.0902 -- MySQL_Thread.cpp -- Mon May 20 08:43:02 2024
Standard MySQL Authentication rev. 0.2.0902 -- MySQL_Authentication.cpp -- Mon May 20 08:43:02 2024
2024-08-13 17:52:03 [INFO] Computed checksum for 'LOAD MYSQL USERS TO RUNTIME' was '0x0000000000000000', with epoch '1723560723'
2024-08-13 17:52:03 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-08-13 17:52:03 [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 |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-13 17:52:03 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-08-13 17:52:03 [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 |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-13 17:52:03 [INFO] New mysql_group_replication_hostgroups table
2024-08-13 17:52:03 [INFO] New mysql_galera_hostgroups table
2024-08-13 17:52:03 [INFO] New mysql_aws_aurora_hostgroups table
2024-08-13 17:52:03 [INFO] New mysql_hostgroup_attributes table
2024-08-13 17:52:03 [INFO] New mysql_servers_ssl_params table
2024-08-13 17:52:03 [INFO] Checksum for table mysql_servers_v2 is 0x0000000000000000
2024-08-13 17:52:03 [INFO] New computed global checksum for 'mysql_servers_v2' is '0x0000000000000000'
2024-08-13 17:52:03 [INFO] Checksum for table mysql_servers is 0x0000000000000000
2024-08-13 17:52:03 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms
2024-08-13 17:52:03 [INFO] Computed checksum for 'LOAD PROXYSQL SERVERS TO RUNTIME' was '0x0000000000000000', with epoch '1723560723'
Standard Query Processor rev. 2.0.6.0805 -- Query_Processor.cpp -- Mon May 20 08:43:02 2024
2024-08-13 17:52:03 [INFO] Computed checksum for 'LOAD MYSQL QUERY RULES TO RUNTIME' was '0x0000000000000000', with epoch '1723560723'
In memory Standard Query Cache (SQC) rev. 1.2.0905 -- Query_Cache.cpp -- Mon May 20 08:43:02 2024
Standard MySQL Monitor (StdMyMon) rev. 2.0.1226 -- MySQL_Monitor.cpp -- Mon May 20 08:43:02 2024
Standard ProxySQL HTTP Server Handler rev. 1.4.1031 -- ProxySQL_HTTP_Server.cpp -- Mon May 20 08:43:02 2024
2024-08-13 17:52:03 [INFO] For information about products and services visit: https://proxysql.com/
2024-08-13 17:52:03 [INFO] For online documentation visit: https://proxysql.com/documentation/
2024-08-13 17:52:03 [INFO] For support visit: https://proxysql.com/services/support/
2024-08-13 17:52:03 [INFO] For consultancy visit: https://proxysql.com/services/consulting/
2024-08-13 17:52:03 [INFO] Latest ProxySQL version available: 2.6.3-107-gcdfcfdc
2024-08-13 17:52:31 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2024-08-13 17:52:31 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-08-13 17:52:31 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
2024-08-13 17:52:31 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
2024-08-13 17:52:31 [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.1.0.10 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-13 17:52:31 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-08-13 17:52:31 [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.1.0.10 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         | 0           | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         | 0           | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         | 0           | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-13 17:52:31 [INFO] Creating new server in HG 10 : 10.1.0.10:3306 , gtid_port=0, weight=1, status=0
2024-08-13 17:52:31 [INFO] Creating new server in HG 20 : 10.1.0.20:3306 , gtid_port=0, weight=1, status=0
2024-08-13 17:52:31 [INFO] Creating new server in HG 20 : 10.1.0.40:3306 , gtid_port=0, weight=1, status=0
2024-08-13 17:52:31 [INFO] New mysql_replication_hostgroups table
writer_hostgroup: 10 , reader_hostgroup: 20, check_type read_only, comment:
2024-08-13 17:52:31 [INFO] New mysql_group_replication_hostgroups table
2024-08-13 17:52:31 [INFO] New mysql_galera_hostgroups table
2024-08-13 17:52:31 [INFO] New mysql_aws_aurora_hostgroups table
2024-08-13 17:52:31 [INFO] New mysql_hostgroup_attributes table
2024-08-13 17:52:31 [INFO] New mysql_servers_ssl_params table
2024-08-13 17:52:31 [INFO] Checksum for table mysql_servers_v2 is 0xEB07253C712EDC04
2024-08-13 17:52:31 [INFO] Checksum for table mysql_replication_hostgroups is 0x578B81540491ED50
2024-08-13 17:52:31 [INFO] New computed global checksum for 'mysql_servers_v2' is '0x9DC2954BC4F45CBB'
2024-08-13 17:52:31 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-13 17:52:31 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578112 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578496 |
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578304 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-13 17:52:31 [INFO] Checksum for table mysql_servers is 0xEB07253C712EDC04
2024-08-13 17:52:31 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0x0, new: 0x712EDC04EB07253C }, mysql_replication_hostgroups { old:0x0, new:0x578B81540491ED50 }
2024-08-13 17:52:31 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2024-08-13 17:52:31 [INFO] Received SAVE MYSQL SERVERS TO DISK command
2024-08-13 17:52:31 [INFO] read_only_action_v2() detected RO=0 on server 10.1.0.10:3306 for the first time after commit(), but no need to reconfigure
2024-08-13 17:52:36 [INFO] Received command SET mysql-monitor_username='monitor'
2024-08-13 17:52:36 [INFO] Received SET command for mysql-monitor_password
2024-08-13 17:52:39 [INFO] Received LOAD MYSQL VARIABLES TO RUNTIME command
2024-08-13 17:52:39 [INFO] Computed checksum for 'LOAD MYSQL VARIABLES TO RUNTIME' was '0xD40D0CDEC6B10FB9', with epoch '1723560759'
2024-08-13 17:52:39 [INFO] Received SAVE MYSQL VARIABLES TO DISK command
2024-08-13 17:53:07 [INFO] Server '10.1.0.10:3306' found with 'read_only=1', but not found as reader
2024-08-13 17:53:07 [INFO] Creating new server in HG 20 : 10.1.0.10:3306 , gtid_port=0, weight=1, status=0
2024-08-13 17:53:07 MySQL_HostGroups_Manager.cpp:7316:remove_HGM(): [WARNING] Removed server at address 0x7fae118e5700, hostgroup 10, address 10.1.0.10 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-08-13 17:53:07 [INFO] Regenerating table 'mysql_servers' due to actions on server '10.1.0.10:3306'
2024-08-13 17:53:07 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-13 17:53:07 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578304 |
| 20  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711070592 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578496 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-13 17:53:07 [INFO] Checksum for table mysql_servers is 0xD161CA706EDA3EDA
2024-08-13 17:53:29 [INFO] Server '10.1.0.10:3306' found with 'read_only=0', but not found as writer
2024-08-13 17:53:29 [INFO] Creating new server in HG 10 : 10.1.0.10:3306 , gtid_port=0, weight=1, status=0
2024-08-13 17:53:29 [INFO] Regenerating table 'mysql_servers' due to actions on server '10.1.0.10:3306'
2024-08-13 17:53:29 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-13 17:53: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.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711070784 |
| 20  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711070592 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578496 |
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578304 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-13 17:53:29 [INFO] Checksum for table mysql_servers is 0x1FC7920757F197D0
2024-08-13 17:54:31 [INFO] Received LOAD MYSQL USERS TO RUNTIME command
2024-08-13 17:54:31 [INFO] Computed checksum for 'LOAD MYSQL USERS TO RUNTIME' was '0xD346AB4299F9CAAB', with epoch '1723560871'
2024-08-13 17:54:31 [INFO] Received SAVE MYSQL USERS TO DISK command
2024-08-13 17:59:49 [INFO] Received LOAD MYSQL QUERY RULES TO RUNTIME command
2024-08-13 17:59:49 [INFO] Computed checksum for 'LOAD MYSQL QUERY RULES TO RUNTIME' was '0x35CB16A754943F6A', with epoch '1723561189'
2024-08-13 17:59:49 [INFO] Received SAVE MYSQL QUERY RULES TO DISK command
2024-08-13 18:00:00 [INFO] Received SAVE MYSQL QUERY RULES TO DISK command
2024-08-13 18:01:20 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2024-08-13 18:01:20 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-08-13 18:01:20 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-13 18:01:20 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711070784 |
| 20  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711070592 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578496 |
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578304 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-13 18:01:20 [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.1.0.10 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 100    | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | 100    | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-13 18:01:20 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-----------------+--------------+-----------+------+
| mem_pointer     | hostgroup_id | hostname  | port |
+-----------------+--------------+-----------+------+
| 140385711070592 | 20           | 10.1.0.10 | 3306 |
+-----------------+--------------+-----------+------+
2024-08-13 18:01:20 MySQL_HostGroups_Manager.cpp:1293:commit(): [WARNING] Removed server at address 140385711070592, hostgroup 20, address 10.1.0.10 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-08-13 18:01:20 [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 |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 20           | 10.1.0.40 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         | 140385595578496 | 0         | 100    | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         | 140385595578304 | 0         | 100    | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-13 18:01:20 [INFO] New mysql_replication_hostgroups table
writer_hostgroup: 10 , reader_hostgroup: 20, check_type read_only, comment:
2024-08-13 18:01:20 [INFO] New mysql_group_replication_hostgroups table
2024-08-13 18:01:20 [INFO] New mysql_galera_hostgroups table
2024-08-13 18:01:20 [INFO] New mysql_aws_aurora_hostgroups table
2024-08-13 18:01:20 [INFO] New mysql_hostgroup_attributes table
2024-08-13 18:01:20 [INFO] New mysql_servers_ssl_params table
2024-08-13 18:01:20 [INFO] Checksum for table mysql_servers_v2 is 0xBD6B7E381807B293
2024-08-13 18:01:20 [INFO] Checksum for table mysql_replication_hostgroups is 0x578B81540491ED50
2024-08-13 18:01:20 [INFO] New computed global checksum for 'mysql_servers_v2' is '0x64852C9DE9663696'
2024-08-13 18:01:20 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 100 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 100 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-13 18:01:20 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711070784 |
| 20  | 10.1.0.10 | 3306 | 0    | 1      | 3      | 0   | 100       | 0       | 0   | 0       |         | 140385711070592 |
| 20  | 10.1.0.40 | 3306 | 0    | 100    | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578496 |
| 20  | 10.1.0.20 | 3306 | 0    | 100    | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578304 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-13 18:01:20 [INFO] Checksum for table mysql_servers is 0xBD6B7E381807B293
2024-08-13 18:01:20 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0x57F197D01FC79207, new: 0x1807B293BD6B7E38 }, mysql_replication_hostgroups { old:0x578B81540491ED50, new:0x578B81540491ED50 }
2024-08-13 18:01:20 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2024-08-13 18:01:20 [INFO] Received SAVE MYSQL SERVERS TO DISK command
2024-08-13 18:01:20 [INFO] read_only_action_v2() detected RO=0 on server 10.1.0.10:3306 for the first time after commit(), but no need to reconfigure
2024-08-13 18:07:24 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2024-08-13 18:07:24 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-08-13 18:07:24 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 100 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 100 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-13 18:07:24 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711070784 |
| 20  | 10.1.0.40 | 3306 | 0    | 100    | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578496 |
| 20  | 10.1.0.20 | 3306 | 0    | 100    | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578304 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-13 18:07:24 [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.1.0.10 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-13 18:07:24 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-08-13 18:07:24 [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 |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 20           | 10.1.0.40 | 3306 | 0         | 100    | 0      | 0           | 100             | 0                   | 0       | 0              |         | 140385595578496 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 100    | 0      | 0           | 100             | 0                   | 0       | 0              |         | 140385595578304 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-13 18:07:24 [INFO] New mysql_replication_hostgroups table
writer_hostgroup: 10 , reader_hostgroup: 20, check_type read_only, comment:
2024-08-13 18:07:24 [INFO] New mysql_group_replication_hostgroups table
2024-08-13 18:07:24 [INFO] New mysql_galera_hostgroups table
2024-08-13 18:07:24 [INFO] New mysql_aws_aurora_hostgroups table
2024-08-13 18:07:24 [INFO] New mysql_hostgroup_attributes table
2024-08-13 18:07:24 [INFO] New mysql_servers_ssl_params table
2024-08-13 18:07:24 [INFO] Checksum for table mysql_servers_v2 is 0xEB07253C712EDC04
2024-08-13 18:07:24 [INFO] Checksum for table mysql_replication_hostgroups is 0x578B81540491ED50
2024-08-13 18:07:24 [INFO] New computed global checksum for 'mysql_servers_v2' is '0x9DC2954BC4F45CBB'
2024-08-13 18:07:24 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-13 18:07:24 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711070784 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578496 |
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578304 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-13 18:07:24 [INFO] Checksum for table mysql_servers is 0xEB07253C712EDC04
2024-08-13 18:07:24 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0x1807B293BD6B7E38, new: 0x712EDC04EB07253C }, mysql_replication_hostgroups { old:0x578B81540491ED50, new:0x578B81540491ED50 }
2024-08-13 18:07:24 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms
2024-08-13 18:07:24 [INFO] Received SAVE MYSQL SERVERS TO DISK command
2024-08-13 18:07:25 [INFO] read_only_action_v2() detected RO=0 on server 10.1.0.10:3306 for the first time after commit(), but no need to reconfigure
2024-08-13 18:11:29 [INFO] Server '10.1.0.10:3306' found with 'read_only=1', but not found as reader
2024-08-13 18:11:29 [INFO] Creating new server in HG 20 : 10.1.0.10:3306 , gtid_port=0, weight=1, status=0
2024-08-13 18:11:29 MySQL_HostGroups_Manager.cpp:7316:remove_HGM(): [WARNING] Removed server at address 0x7fae18709e40, hostgroup 10, address 10.1.0.10 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-08-13 18:11:29 [INFO] Regenerating table 'mysql_servers' due to actions on server '10.1.0.10:3306'
2024-08-13 18:11:29 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-13 18:11:29 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578304 |
| 20  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711043904 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578496 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-13 18:11:29 [INFO] Checksum for table mysql_servers is 0xD161CA706EDA3EDA
2024-08-13 18:11:44 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:11:46 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:11:48 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:11:50 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:11:52 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:11:54 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:11:54 MySQL_Session.cpp:3209:handler_again___status_CONNECTING_SERVER(): [ERROR] Max connect timeout reached while reaching hostgroup 10 after 10001ms . HG status: []
2024-08-13 18:11:56 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:11:58 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:00 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:02 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:04 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:04 MySQL_Session.cpp:3209:handler_again___status_CONNECTING_SERVER(): [ERROR] Max connect timeout reached while reaching hostgroup 10 after 10000ms . HG status: []
2024-08-13 18:12:06 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:08 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:10 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:12 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:14 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:14 MySQL_Session.cpp:3209:handler_again___status_CONNECTING_SERVER(): [ERROR] Max connect timeout reached while reaching hostgroup 10 after 10001ms . HG status: []
2024-08-13 18:12:16 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:18 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:20 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:22 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:24 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:24 MySQL_Session.cpp:3209:handler_again___status_CONNECTING_SERVER(): [ERROR] Max connect timeout reached while reaching hostgroup 10 after 10000ms . HG status: []
2024-08-13 18:12:26 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:28 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:30 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:32 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:34 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:34 MySQL_Session.cpp:3209:handler_again___status_CONNECTING_SERVER(): [ERROR] Max connect timeout reached while reaching hostgroup 10 after 10000ms . HG status: []
2024-08-13 18:12:36 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:38 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:40 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:42 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:44 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:44 MySQL_Session.cpp:3209:handler_again___status_CONNECTING_SERVER(): [ERROR] Max connect timeout reached while reaching hostgroup 10 after 10000ms . HG status: []
2024-08-13 18:12:46 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:48 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:50 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:52 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:54 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:54 MySQL_Session.cpp:3209:handler_again___status_CONNECTING_SERVER(): [ERROR] Max connect timeout reached while reaching hostgroup 10 after 10000ms . HG status: []
2024-08-13 18:12:56 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:12:58 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:13:00 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:13:02 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:13:04 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:13:04 MySQL_Session.cpp:3209:handler_again___status_CONNECTING_SERVER(): [ERROR] Max connect timeout reached while reaching hostgroup 10 after 10000ms . HG status: []
2024-08-13 18:13:06 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:13:08 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:13:10 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:13:12 MyHGC.cpp:384:get_random_MySrvC(): [ERROR] Hostgroup 10 has no servers available!
2024-08-13 18:13:13 [INFO] Killing query 9021
2024-08-13 18:13:15 MySQL_Session.cpp:3209:handler_again___status_CONNECTING_SERVER(): [ERROR] Max connect timeout reached while reaching hostgroup 10 after 10484ms . HG status: []
2024-08-13 18:13:40 [INFO] Killing query 9021
2024-08-13 18:13:53 [INFO] Server '10.1.0.10:3306' found with 'read_only=0', but not found as writer
2024-08-13 18:13:53 [INFO] Creating new server in HG 10 : 10.1.0.10:3306 , gtid_port=0, weight=1, status=0
2024-08-13 18:13:53 [INFO] Regenerating table 'mysql_servers' due to actions on server '10.1.0.10:3306'
2024-08-13 18:13:53 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-13 18:13:53 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711039680 |
| 20  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711043904 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578496 |
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578304 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-13 18:13:53 [INFO] Checksum for table mysql_servers is 0x1FC7920757F197D0
2024-08-13 18:15:47 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2024-08-13 18:15:47 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-08-13 18:15:47 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-13 18:15:47 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711039680 |
| 20  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711043904 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578496 |
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578304 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-13 18:15:47 [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.1.0.10 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 10     | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | 10     | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-13 18:15:47 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-----------------+--------------+-----------+------+
| mem_pointer     | hostgroup_id | hostname  | port |
+-----------------+--------------+-----------+------+
| 140385711043904 | 20           | 10.1.0.10 | 3306 |
+-----------------+--------------+-----------+------+
2024-08-13 18:15:47 MySQL_HostGroups_Manager.cpp:1293:commit(): [WARNING] Removed server at address 140385711043904, hostgroup 20, address 10.1.0.10 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-08-13 18:15:47 [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 |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 20           | 10.1.0.40 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         | 140385595578496 | 0         | 10     | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         | 140385595578304 | 0         | 10     | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-13 18:15:47 [INFO] New mysql_replication_hostgroups table
writer_hostgroup: 10 , reader_hostgroup: 20, check_type read_only, comment:
2024-08-13 18:15:47 [INFO] New mysql_group_replication_hostgroups table
2024-08-13 18:15:47 [INFO] New mysql_galera_hostgroups table
2024-08-13 18:15:47 [INFO] New mysql_aws_aurora_hostgroups table
2024-08-13 18:15:47 [INFO] New mysql_hostgroup_attributes table
2024-08-13 18:15:47 [INFO] New mysql_servers_ssl_params table
2024-08-13 18:15:47 [INFO] Checksum for table mysql_servers_v2 is 0x2EC8569191C566C0
2024-08-13 18:15:47 [INFO] Checksum for table mysql_replication_hostgroups is 0x578B81540491ED50
2024-08-13 18:15:47 [INFO] New computed global checksum for 'mysql_servers_v2' is '0xDAAB1EE0BF9A3F80'
2024-08-13 18:15:47 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 10 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 10 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-13 18:15:47 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711039680 |
| 20  | 10.1.0.10 | 3306 | 0    | 1      | 3      | 0   | 100       | 0       | 0   | 0       |         | 140385711043904 |
| 20  | 10.1.0.40 | 3306 | 0    | 10     | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578496 |
| 20  | 10.1.0.20 | 3306 | 0    | 10     | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578304 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-13 18:15:47 [INFO] Checksum for table mysql_servers is 0x2EC8569191C566C0
2024-08-13 18:15:47 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0x57F197D01FC79207, new: 0x91C566C02EC85691 }, mysql_replication_hostgroups { old:0x578B81540491ED50, new:0x578B81540491ED50 }
2024-08-13 18:15:47 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2024-08-13 18:15:47 [INFO] Received SAVE MYSQL SERVERS TO DISK command
2024-08-13 18:15:47 [INFO] read_only_action_v2() detected RO=0 on server 10.1.0.10:3306 for the first time after commit(), but no need to reconfigure
2024-08-13 18:20:40 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2024-08-13 18:20:40 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-08-13 18:20:40 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 10 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 10 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-13 18:20:40 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711039680 |
| 20  | 10.1.0.40 | 3306 | 0    | 10     | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578496 |
| 20  | 10.1.0.20 | 3306 | 0    | 10     | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578304 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-13 18:20:40 [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.1.0.10 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 10     | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | 10     | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-13 18:20:40 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-08-13 18:20:40 [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 |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-13 18:20:40 [INFO] New mysql_replication_hostgroups table
writer_hostgroup: 10 , reader_hostgroup: 20, check_type read_only, comment:
2024-08-13 18:20:40 [INFO] New mysql_group_replication_hostgroups table
2024-08-13 18:20:40 [INFO] New mysql_galera_hostgroups table
2024-08-13 18:20:40 [INFO] New mysql_aws_aurora_hostgroups table
2024-08-13 18:20:40 [INFO] New mysql_hostgroup_attributes table
2024-08-13 18:20:40 [INFO] New mysql_servers_ssl_params table
2024-08-13 18:20:40 [INFO] Checksum for table mysql_servers_v2 is 0x2EC8569191C566C0
2024-08-13 18:20:40 [INFO] Checksum for table mysql_replication_hostgroups is 0x578B81540491ED50
2024-08-13 18:20:40 [INFO] New computed global checksum for 'mysql_servers_v2' is '0xDAAB1EE0BF9A3F80'
2024-08-13 18:20:40 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 10 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 10 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-13 18:20:40 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711039680 |
| 20  | 10.1.0.40 | 3306 | 0    | 10     | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578496 |
| 20  | 10.1.0.20 | 3306 | 0    | 10     | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578304 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-13 18:20:40 [INFO] Checksum for table mysql_servers is 0x2EC8569191C566C0
2024-08-13 18:20:40 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2024-08-13 18:21:37 [INFO] Received LOAD MYSQL QUERY RULES TO RUNTIME command
2024-08-13 18:21:37 [INFO] Computed checksum for 'LOAD MYSQL QUERY RULES TO RUNTIME' was '0x0000000000000000', with epoch '1723562497'
2024-08-13 18:21:37 [INFO] Received SAVE MYSQL QUERY RULES TO DISK command
2024-08-13 18:30:01 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2024-08-13 18:30:01 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-08-13 18:30:01 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 10 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 10 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-13 18:30:01 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711039680 |
| 20  | 10.1.0.40 | 3306 | 0    | 10     | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578496 |
| 20  | 10.1.0.20 | 3306 | 0    | 10     | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578304 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-13 18:30:01 [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.1.0.10 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-13 18:30:01 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-08-13 18:30:01 [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 |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 20           | 10.1.0.40 | 3306 | 0         | 10     | 0      | 0           | 100             | 0                   | 0       | 0              |         | 140385595578496 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 10     | 0      | 0           | 100             | 0                   | 0       | 0              |         | 140385595578304 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-13 18:30:01 [INFO] New mysql_replication_hostgroups table
writer_hostgroup: 10 , reader_hostgroup: 20, check_type read_only, comment:
2024-08-13 18:30:01 [INFO] New mysql_group_replication_hostgroups table
2024-08-13 18:30:01 [INFO] New mysql_galera_hostgroups table
2024-08-13 18:30:01 [INFO] New mysql_aws_aurora_hostgroups table
2024-08-13 18:30:01 [INFO] New mysql_hostgroup_attributes table
2024-08-13 18:30:01 [INFO] New mysql_servers_ssl_params table
2024-08-13 18:30:01 [INFO] Checksum for table mysql_servers_v2 is 0xEB07253C712EDC04
2024-08-13 18:30:01 [INFO] Checksum for table mysql_replication_hostgroups is 0x578B81540491ED50
2024-08-13 18:30:01 [INFO] New computed global checksum for 'mysql_servers_v2' is '0x9DC2954BC4F45CBB'
2024-08-13 18:30:01 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-13 18:30:01 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385711039680 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578496 |
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140385595578304 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-13 18:30:01 [INFO] Checksum for table mysql_servers is 0xEB07253C712EDC04
2024-08-13 18:30:01 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0x91C566C02EC85691, new: 0x712EDC04EB07253C }, mysql_replication_hostgroups { old:0x578B81540491ED50, new:0x578B81540491ED50 }
2024-08-13 18:30:01 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2024-08-13 18:30:01 [INFO] Received SAVE MYSQL SERVERS TO DISK command
2024-08-13 18:30:01 [INFO] read_only_action_v2() detected RO=0 on server 10.1.0.10:3306 for the first time after commit(), but no need to reconfigure
2024-08-13 18:30:31 MySQL_Monitor.cpp:7310:monitor_read_only_process_ready_tasks(): [ERROR] Got error: mmsd 0x7fae1889e400 , MYSQL 0x7fae18417700 , FD 42 : Server shutdown in progress
2024-08-13 18:30:33 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 0ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (115).
2024-08-13 18:30:34 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 0ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (115).
2024-08-13 18:30:37 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1000ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:37 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:30:38 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1014ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:38 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:30:40 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1001ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:40 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:30:41 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1008ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:41 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:30:43 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1001ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:43 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:30:44 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1001ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:44 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:30:46 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1001ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:46 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:30:47 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1001ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:47 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:30:49 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1002ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:49 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:30:50 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1001ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:50 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:30:52 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1000ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:52 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:30:53 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1002ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:53 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:30:55 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1001ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:55 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:30:56 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1001ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:56 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:30:58 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1000ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:58 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:30:59 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1001ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:30:59 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:31:01 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1001ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:31:01 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:31:02 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1001ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (110).
2024-08-13 18:31:02 MySQL_Monitor.cpp:1795:monitor_read_only_thread(): [ERROR] Server 10.1.0.40:3306 missed 3 read_only checks. Assuming read_only=1
2024-08-13 18:31:10 MySQL_Monitor.cpp:3158:monitor_ping(): [ERROR] Server 10.1.0.40:3306 missed 3 heartbeats, shunning it and killing all the connections. Disabling other checks until the node comes back online.
2024-08-13 18:32:02 [INFO] Received LOAD MYSQL QUERY RULES TO RUNTIME command
2024-08-13 18:32:02 [INFO] Computed checksum for 'LOAD MYSQL QUERY RULES TO RUNTIME' was '0x35CB16A754943F6A', with epoch '1723563122'
2024-08-13 18:32:02 [INFO] Received SAVE MYSQL QUERY RULES TO DISK command
2024-08-13 18:32:10 MySQL_Monitor.cpp:3158:monitor_ping(): [ERROR] Server 10.1.0.40:3306 missed 3 heartbeats, shunning it and killing all the connections. Disabling other checks until the node comes back online.
2024-08-13 18:32:12 mysql_connection.cpp:1203:handler(): [ERROR] Failed to mysql_real_connect() on 20:10.1.0.40:3306 , FD (Conn:0 , MyDS:43) , 2002: Can't connect to server on '10.1.0.40' (113).
2024-08-13 18:32:30 MySQL_Monitor.cpp:3158:monitor_ping(): [ERROR] Server 10.1.0.40:3306 missed 3 heartbeats, shunning it and killing all the connections. Disabling other checks until the node comes back online.
2024-08-13 18:32:31 mysql_connection.cpp:1203:handler(): [ERROR] Failed to mysql_real_connect() on 20:10.1.0.40:3306 , FD (Conn:0 , MyDS:43) , 2002: Can't connect to server on '10.1.0.40' (113).
2024-08-13 18:32:50 MySQL_Monitor.cpp:3158:monitor_ping(): [ERROR] Server 10.1.0.40:3306 missed 3 heartbeats, shunning it and killing all the connections. Disabling other checks until the node comes back online.
2024-08-13 18:32:51 mysql_connection.cpp:1203:handler(): [ERROR] Failed to mysql_real_connect() on 20:10.1.0.40:3306 , FD (Conn:0 , MyDS:43) , 2002: Can't connect to server on '10.1.0.40' (113).
2024-08-13 18:33:10 MySQL_Monitor.cpp:3158:monitor_ping(): [ERROR] Server 10.1.0.40:3306 missed 3 heartbeats, shunning it and killing all the connections. Disabling other checks until the node comes back online.
2024-08-13 18:33:13 mysql_connection.cpp:1279:handler(): [ERROR] Connect timeout on 10.1.0.40:3306 : exceeded by 26us
2024-08-13 18:33:30 MySQL_Monitor.cpp:3158:monitor_ping(): [ERROR] Server 10.1.0.40:3306 missed 3 heartbeats, shunning it and killing all the connections. Disabling other checks until the node comes back online.
2024-08-13 18:33:33 mysql_connection.cpp:1279:handler(): [ERROR] Connect timeout on 10.1.0.40:3306 : exceeded by 2561us
2024-08-13 18:33:50 MySQL_Monitor.cpp:3158:monitor_ping(): [ERROR] Server 10.1.0.40:3306 missed 3 heartbeats, shunning it and killing all the connections. Disabling other checks until the node comes back online.
2024-08-13 18:33:53 mysql_connection.cpp:1279:handler(): [ERROR] Connect timeout on 10.1.0.40:3306 : exceeded by 1553us
2024-08-14 11:09:22 [INFO] ProxySQL version 2.6.3-107-gcdfcfdc
2024-08-14 11:09:22 [INFO] Detected OS: Linux DB3 5.14.0-427.28.1.el9_4.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Aug 2 03:44:10 EDT 2024 x86_64
2024-08-14 11:09:22 [INFO] ProxySQL SHA1 checksum: b1bee1e8e3dd23c2083245d6ea8083ce7eda39e3
2024-08-14 11:09:22 [INFO] Starting ProxySQL
2024-08-14 11:09:22 [INFO] Successfully started
2024-08-14 11:09:22 [INFO] Angel process started ProxySQL process 1162
2024-08-14 11:09:22 [INFO] SSL keys/certificates found in datadir (/var/lib/proxysql): loading them.
2024-08-14 11:09:22 [INFO] Loaded built-in SQLite3
Standard ProxySQL MySQL Logger rev. 2.5.0421 -- MySQL_Logger.cpp -- Mon May 20 08:43:02 2024
Standard ProxySQL Cluster rev. 0.4.0906 -- ProxySQL_Cluster.cpp -- Mon May 20 08:43:02 2024
Standard ProxySQL Statistics rev. 1.4.1027 -- ProxySQL_Statistics.cpp -- Mon May 20 08:43:02 2024
2024-08-14 11:09:22 [INFO] Using UUID from database: ef135fc5-b45d-4583-ae2d-486f8e9fd9b3
2024-08-14 11:09:22 [INFO] Computed checksum for 'LOAD ADMIN VARIABLES TO RUNTIME' was '0xC932B2DAA28AE2CD', with epoch '1723622962'
2024-08-14 11:09:22 [INFO] Computed checksum for 'LOAD MYSQL VARIABLES TO RUNTIME' was '0xD40D0CDEC6B10FB9', with epoch '1723622962'
Standard ProxySQL Admin rev. 2.0.6.0805 -- ProxySQL_Admin.cpp -- Mon May 20 08:43:02 2024
2024-08-14 11:09:22 [INFO] ProxySQL SHA1 checksum: b1bee1e8e3dd23c2083245d6ea8083ce7eda39e3
Standard MySQL Threads Handler rev. 0.2.0902 -- MySQL_Thread.cpp -- Mon May 20 08:43:02 2024
Standard MySQL Authentication rev. 0.2.0902 -- MySQL_Authentication.cpp -- Mon May 20 08:43:02 2024
2024-08-14 11:09:22 [INFO] Computed checksum for 'LOAD MYSQL USERS TO RUNTIME' was '0xD346AB4299F9CAAB', with epoch '1723622962'
2024-08-14 11:09:22 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-08-14 11:09:22 [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.1.0.10 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-14 11:09:22 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-08-14 11:09:22 [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.1.0.10 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         | 0           | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         | 0           | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         | 0           | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-14 11:09:22 [INFO] Creating new server in HG 10 : 10.1.0.10:3306 , gtid_port=0, weight=1, status=0
2024-08-14 11:09:22 [INFO] Creating new server in HG 20 : 10.1.0.20:3306 , gtid_port=0, weight=1, status=0
2024-08-14 11:09:22 [INFO] Creating new server in HG 20 : 10.1.0.40:3306 , gtid_port=0, weight=1, status=0
2024-08-14 11:09:22 [INFO] New mysql_group_replication_hostgroups table
2024-08-14 11:09:22 [INFO] New mysql_galera_hostgroups table
2024-08-14 11:09:22 [INFO] New mysql_aws_aurora_hostgroups table
2024-08-14 11:09:22 [INFO] New mysql_hostgroup_attributes table
2024-08-14 11:09:22 [INFO] New mysql_servers_ssl_params table
2024-08-14 11:09:22 [INFO] Checksum for table mysql_servers_v2 is 0xEB07253C712EDC04
2024-08-14 11:09:22 [INFO] Checksum for table mysql_replication_hostgroups is 0x578B81540491ED50
2024-08-14 11:09:22 [INFO] New computed global checksum for 'mysql_servers_v2' is '0x9DC2954BC4F45CBB'
2024-08-14 11:09:22 [INFO] Checksum for table mysql_servers is 0xEB07253C712EDC04
2024-08-14 11:09:22 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0x0, new: 0x712EDC04EB07253C }, mysql_replication_hostgroups { old:0x0, new:0x578B81540491ED50 }
2024-08-14 11:09:22 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms
2024-08-14 11:09:22 [INFO] Computed checksum for 'LOAD PROXYSQL SERVERS TO RUNTIME' was '0x0000000000000000', with epoch '1723622962'
Standard Query Processor rev. 2.0.6.0805 -- Query_Processor.cpp -- Mon May 20 08:43:02 2024
2024-08-14 11:09:22 [INFO] Computed checksum for 'LOAD MYSQL QUERY RULES TO RUNTIME' was '0x35CB16A754943F6A', with epoch '1723622962'
In memory Standard Query Cache (SQC) rev. 1.2.0905 -- Query_Cache.cpp -- Mon May 20 08:43:02 2024
Standard MySQL Monitor (StdMyMon) rev. 2.0.1226 -- MySQL_Monitor.cpp -- Mon May 20 08:43:02 2024
Standard ProxySQL HTTP Server Handler rev. 1.4.1031 -- ProxySQL_HTTP_Server.cpp -- Mon May 20 08:43:02 2024
2024-08-14 11:09:22 [INFO] For information about products and services visit: https://proxysql.com/
2024-08-14 11:09:22 [INFO] For online documentation visit: https://proxysql.com/documentation/
2024-08-14 11:09:22 [INFO] For support visit: https://proxysql.com/services/support/
2024-08-14 11:09:22 [INFO] For consultancy visit: https://proxysql.com/services/consulting/
2024-08-14 11:09:22 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.40:3306 after 1ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.40' (115).
2024-08-14 11:09:22 [INFO] Latest ProxySQL version available: 2.6.3-107-gcdfcfdc
2024-08-14 11:09:23 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.10:3306 after 389ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.10' (115).
2024-08-14 11:09:24 MySQL_Monitor.cpp:1613:monitor_read_only_thread(): [ERROR] Timeout on read_only check for 10.1.0.10:3306 after 0ms. Unable to create a connection. If the server is overload, increase mysql-monitor_connect_timeout. Error: timeout on creating new connection: Can't connect to server on '10.1.0.10' (115).
2024-08-14 11:09:25 [INFO] Server '10.1.0.10:3306' found with 'read_only=1', but not found as reader
2024-08-14 11:09:25 [INFO] Creating new server in HG 20 : 10.1.0.10:3306 , gtid_port=0, weight=1, status=0
2024-08-14 11:09:25 MySQL_HostGroups_Manager.cpp:7316:remove_HGM(): [WARNING] Removed server at address 0x7f54d0904680, hostgroup 10, address 10.1.0.10 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-08-14 11:09:25 [INFO] Regenerating table 'mysql_servers' due to actions on server '10.1.0.10:3306'
2024-08-14 11:09:25 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-14 11:09:25 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140002253096768 |
| 20  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140002144963328 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140002253096960 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-14 11:09:25 [INFO] Checksum for table mysql_servers is 0xD161CA706EDA3EDA
2024-08-14 11:31:26 ProxySQL_GloVars.cpp:20:term_handler(): [WARNING] Received TERM signal: shutdown in progress...
2024-08-14 11:31:41 [INFO] ProxySQL version 2.6.3-107-gcdfcfdc
2024-08-14 11:31:41 [INFO] Detected OS: Linux DB3 5.14.0-427.28.1.el9_4.x86_64 #1 SMP PREEMPT_DYNAMIC Fri Aug 2 03:44:10 EDT 2024 x86_64
2024-08-14 11:31:41 [INFO] ProxySQL SHA1 checksum: b1bee1e8e3dd23c2083245d6ea8083ce7eda39e3
2024-08-14 11:31:41 [INFO] Starting ProxySQL
2024-08-14 11:31:41 [INFO] Successfully started
2024-08-14 11:31:41 [INFO] Angel process started ProxySQL process 1352
2024-08-14 11:31:41 [INFO] SSL keys/certificates found in datadir (/var/lib/proxysql): loading them.
2024-08-14 11:31:41 [INFO] Loaded built-in SQLite3
Standard ProxySQL MySQL Logger rev. 2.5.0421 -- MySQL_Logger.cpp -- Mon May 20 08:43:02 2024
Standard ProxySQL Cluster rev. 0.4.0906 -- ProxySQL_Cluster.cpp -- Mon May 20 08:43:02 2024
Standard ProxySQL Statistics rev. 1.4.1027 -- ProxySQL_Statistics.cpp -- Mon May 20 08:43:02 2024
2024-08-14 11:31:41 [INFO] Using UUID: c45f7a61-869c-4131-ae45-815db3273a23 , randomly generated. Writing it to database
2024-08-14 11:31:41 [INFO] Computed checksum for 'LOAD ADMIN VARIABLES TO RUNTIME' was '0xC932B2DAA28AE2CD', with epoch '1723624301'
2024-08-14 11:31:41 [INFO] Computed checksum for 'LOAD MYSQL VARIABLES TO RUNTIME' was '0xD40D0CDEC6B10FB9', with epoch '1723624301'
Standard ProxySQL Admin rev. 2.0.6.0805 -- ProxySQL_Admin.cpp -- Mon May 20 08:43:02 2024
2024-08-14 11:31:41 [INFO] ProxySQL SHA1 checksum: b1bee1e8e3dd23c2083245d6ea8083ce7eda39e3
Standard MySQL Threads Handler rev. 0.2.0902 -- MySQL_Thread.cpp -- Mon May 20 08:43:02 2024
Standard MySQL Authentication rev. 0.2.0902 -- MySQL_Authentication.cpp -- Mon May 20 08:43:02 2024
2024-08-14 11:31:41 [INFO] Computed checksum for 'LOAD MYSQL USERS TO RUNTIME' was '0x0000000000000000', with epoch '1723624301'
2024-08-14 11:31:41 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-08-14 11:31:41 [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 |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-14 11:31:41 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-08-14 11:31:41 [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 |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-14 11:31:41 [INFO] New mysql_group_replication_hostgroups table
2024-08-14 11:31:41 [INFO] New mysql_galera_hostgroups table
2024-08-14 11:31:41 [INFO] New mysql_aws_aurora_hostgroups table
2024-08-14 11:31:41 [INFO] New mysql_hostgroup_attributes table
2024-08-14 11:31:41 [INFO] New mysql_servers_ssl_params table
2024-08-14 11:31:41 [INFO] Checksum for table mysql_servers_v2 is 0x0000000000000000
2024-08-14 11:31:41 [INFO] New computed global checksum for 'mysql_servers_v2' is '0x0000000000000000'
2024-08-14 11:31:41 [INFO] Checksum for table mysql_servers is 0x0000000000000000
2024-08-14 11:31:41 [INFO] MySQL_HostGroups_Manager::commit() locked for 0ms
2024-08-14 11:31:41 [INFO] Computed checksum for 'LOAD PROXYSQL SERVERS TO RUNTIME' was '0x0000000000000000', with epoch '1723624301'
Standard Query Processor rev. 2.0.6.0805 -- Query_Processor.cpp -- Mon May 20 08:43:02 2024
2024-08-14 11:31:41 [INFO] Computed checksum for 'LOAD MYSQL QUERY RULES TO RUNTIME' was '0x0000000000000000', with epoch '1723624301'
In memory Standard Query Cache (SQC) rev. 1.2.0905 -- Query_Cache.cpp -- Mon May 20 08:43:02 2024
Standard MySQL Monitor (StdMyMon) rev. 2.0.1226 -- MySQL_Monitor.cpp -- Mon May 20 08:43:02 2024
Standard ProxySQL HTTP Server Handler rev. 1.4.1031 -- ProxySQL_HTTP_Server.cpp -- Mon May 20 08:43:02 2024
2024-08-14 11:31:41 [INFO] For information about products and services visit: https://proxysql.com/
2024-08-14 11:31:41 [INFO] For online documentation visit: https://proxysql.com/documentation/
2024-08-14 11:31:41 [INFO] For support visit: https://proxysql.com/services/support/
2024-08-14 11:31:41 [INFO] For consultancy visit: https://proxysql.com/services/consulting/
2024-08-14 11:31:41 [INFO] Latest ProxySQL version available: 2.6.3-107-gcdfcfdc
2024-08-14 11:56:42 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2024-08-14 11:56:42 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-08-14 11:56:42 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
2024-08-14 11:56:42 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
2024-08-14 11:56:42 [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.1.0.10 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-14 11:56:42 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-08-14 11:56:42 [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.1.0.10 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         | 0           | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         | 0           | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         | 0           | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-14 11:56:42 [INFO] Creating new server in HG 10 : 10.1.0.10:3306 , gtid_port=0, weight=1, status=0
2024-08-14 11:56:42 [INFO] Creating new server in HG 20 : 10.1.0.20:3306 , gtid_port=0, weight=1, status=0
2024-08-14 11:56:42 [INFO] Creating new server in HG 20 : 10.1.0.40:3306 , gtid_port=0, weight=1, status=0
2024-08-14 11:56:42 [INFO] New mysql_replication_hostgroups table
writer_hostgroup: 10 , reader_hostgroup: 20, check_type read_only, comment:
2024-08-14 11:56:42 [INFO] New mysql_group_replication_hostgroups table
2024-08-14 11:56:42 [INFO] New mysql_galera_hostgroups table
2024-08-14 11:56:42 [INFO] New mysql_aws_aurora_hostgroups table
2024-08-14 11:56:42 [INFO] New mysql_hostgroup_attributes table
2024-08-14 11:56:42 [INFO] New mysql_servers_ssl_params table
2024-08-14 11:56:42 [INFO] Checksum for table mysql_servers_v2 is 0xEB07253C712EDC04
2024-08-14 11:56:42 [INFO] Checksum for table mysql_replication_hostgroups is 0x578B81540491ED50
2024-08-14 11:56:42 [INFO] New computed global checksum for 'mysql_servers_v2' is '0x9DC2954BC4F45CBB'
2024-08-14 11:56:42 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-14 11:56:42 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324352 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324736 |
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324544 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-14 11:56:42 [INFO] Checksum for table mysql_servers is 0xEB07253C712EDC04
2024-08-14 11:56:42 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0x0, new: 0x712EDC04EB07253C }, mysql_replication_hostgroups { old:0x0, new:0x578B81540491ED50 }
2024-08-14 11:56:42 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms
2024-08-14 11:56:42 [INFO] Received SAVE MYSQL SERVERS TO DISK command
2024-08-14 11:56:42 [INFO] read_only_action_v2() detected RO=0 on server 10.1.0.10:3306 for the first time after commit(), but no need to reconfigure
2024-08-14 12:03:00 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2024-08-14 12:03:00 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-08-14 12:03:00 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-14 12:03:00 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324352 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324736 |
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324544 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-14 12:03:00 [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.1.0.10 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-14 12:03:00 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-08-14 12:03:00 [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 |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-14 12:03:00 [INFO] New mysql_replication_hostgroups table
writer_hostgroup: 10 , reader_hostgroup: 20, check_type read_only, comment:
2024-08-14 12:03:00 [INFO] New mysql_group_replication_hostgroups table
2024-08-14 12:03:00 [INFO] New mysql_galera_hostgroups table
2024-08-14 12:03:00 [INFO] New mysql_aws_aurora_hostgroups table
2024-08-14 12:03:00 [INFO] New mysql_hostgroup_attributes table
2024-08-14 12:03:00 [INFO] New mysql_servers_ssl_params table
2024-08-14 12:03:00 [INFO] Checksum for table mysql_servers_v2 is 0xEB07253C712EDC04
2024-08-14 12:03:00 [INFO] Checksum for table mysql_replication_hostgroups is 0x578B81540491ED50
2024-08-14 12:03:00 [INFO] New computed global checksum for 'mysql_servers_v2' is '0x9DC2954BC4F45CBB'
2024-08-14 12:03:00 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-14 12:03:00 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324352 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324736 |
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324544 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-14 12:03:00 [INFO] Checksum for table mysql_servers is 0xEB07253C712EDC04
2024-08-14 12:03:00 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms
2024-08-14 12:03:00 [INFO] Received SAVE MYSQL SERVERS TO DISK command
2024-08-14 12:05:11 [INFO] Received LOAD MYSQL VARIABLES TO RUNTIME command
2024-08-14 12:05:11 [INFO] Computed checksum for 'LOAD MYSQL VARIABLES TO RUNTIME' was '0xD40D0CDEC6B10FB9', with epoch '1723626311'
2024-08-14 12:05:12 [INFO] Received SAVE MYSQL VARIABLES TO DISK command
2024-08-14 12:10:07 [INFO] Server '10.1.0.10:3306' found with 'read_only=1', but not found as reader
2024-08-14 12:10:07 [INFO] Creating new server in HG 20 : 10.1.0.10:3306 , gtid_port=0, weight=1, status=0
2024-08-14 12:10:07 MySQL_HostGroups_Manager.cpp:7316:remove_HGM(): [WARNING] Removed server at address 0x7fb96c665a00, hostgroup 10, address 10.1.0.10 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-08-14 12:10:07 [INFO] Regenerating table 'mysql_servers' due to actions on server '10.1.0.10:3306'
2024-08-14 12:10:07 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-14 12:10:07 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324544 |
| 20  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434490826112 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324736 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-14 12:10:07 [INFO] Checksum for table mysql_servers is 0xD161CA706EDA3EDA
2024-08-14 12:37:32 [INFO] Server '10.1.0.10:3306' found with 'read_only=0', but not found as writer
2024-08-14 12:37:32 [INFO] Creating new server in HG 10 : 10.1.0.10:3306 , gtid_port=0, weight=1, status=0
2024-08-14 12:37:32 [INFO] Regenerating table 'mysql_servers' due to actions on server '10.1.0.10:3306'
2024-08-14 12:37:32 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-14 12:37:32 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434490826304 |
| 20  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434490826112 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324736 |
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324544 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-14 12:37:32 [INFO] Checksum for table mysql_servers is 0x1FC7920757F197D0
2024-08-14 13:57:04 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2024-08-14 13:57:04 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-08-14 13:57:04 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-14 13:57:04 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434490826304 |
| 20  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434490826112 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324736 |
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324544 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-14 13:57:04 [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.1.0.10 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 10     | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | 10     | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-14 13:57:04 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-----------------+--------------+-----------+------+
| mem_pointer     | hostgroup_id | hostname  | port |
+-----------------+--------------+-----------+------+
| 140434490826112 | 20           | 10.1.0.10 | 3306 |
+-----------------+--------------+-----------+------+
2024-08-14 13:57:04 MySQL_HostGroups_Manager.cpp:1293:commit(): [WARNING] Removed server at address 140434490826112, hostgroup 20, address 10.1.0.10 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-08-14 13:57:04 [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 |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 20           | 10.1.0.40 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         | 140434364324736 | 0         | 10     | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         | 140434364324544 | 0         | 10     | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-14 13:57:04 [INFO] New mysql_replication_hostgroups table
writer_hostgroup: 10 , reader_hostgroup: 20, check_type read_only, comment:
2024-08-14 13:57:04 [INFO] New mysql_group_replication_hostgroups table
2024-08-14 13:57:04 [INFO] New mysql_galera_hostgroups table
2024-08-14 13:57:04 [INFO] New mysql_aws_aurora_hostgroups table
2024-08-14 13:57:04 [INFO] New mysql_hostgroup_attributes table
2024-08-14 13:57:04 [INFO] New mysql_servers_ssl_params table
2024-08-14 13:57:04 [INFO] Checksum for table mysql_servers_v2 is 0x2EC8569191C566C0
2024-08-14 13:57:04 [INFO] Checksum for table mysql_replication_hostgroups is 0x578B81540491ED50
2024-08-14 13:57:04 [INFO] New computed global checksum for 'mysql_servers_v2' is '0xDAAB1EE0BF9A3F80'
2024-08-14 13:57:04 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 10 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 10 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-14 13:57:04 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434490826304 |
| 20  | 10.1.0.10 | 3306 | 0    | 1      | 3      | 0   | 100       | 0       | 0   | 0       |         | 140434490826112 |
| 20  | 10.1.0.40 | 3306 | 0    | 10     | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324736 |
| 20  | 10.1.0.20 | 3306 | 0    | 10     | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324544 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-14 13:57:04 [INFO] Checksum for table mysql_servers is 0x2EC8569191C566C0
2024-08-14 13:57:04 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0x57F197D01FC79207, new: 0x91C566C02EC85691 }, mysql_replication_hostgroups { old:0x578B81540491ED50, new:0x578B81540491ED50 }
2024-08-14 13:57:04 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2024-08-14 13:57:05 [INFO] Received SAVE MYSQL SERVERS TO DISK command
2024-08-14 13:57:05 [INFO] read_only_action_v2() detected RO=0 on server 10.1.0.10:3306 for the first time after commit(), but no need to reconfigure
2024-08-14 13:58:14 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2024-08-14 13:58:14 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-08-14 13:58:14 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 10 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 10 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-14 13:58:14 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434490826304 |
| 20  | 10.1.0.40 | 3306 | 0    | 10     | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324736 |
| 20  | 10.1.0.20 | 3306 | 0    | 10     | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324544 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-14 13:58:14 [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.1.0.10 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.40 | 3306 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-14 13:58:14 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-08-14 13:58:14 [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 |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 20           | 10.1.0.40 | 3306 | 0         | 10     | 0      | 0           | 100             | 0                   | 0       | 0              |         | 140434364324736 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
| 20           | 10.1.0.20 | 3306 | 0         | 10     | 0      | 0           | 100             | 0                   | 0       | 0              |         | 140434364324544 | 0         | 1      | 0      | 0           | 100             | 0                   | 0       | 0              |         |
+--------------+-----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-08-14 13:58:14 [INFO] New mysql_replication_hostgroups table
writer_hostgroup: 10 , reader_hostgroup: 20, check_type read_only, comment:
2024-08-14 13:58:14 [INFO] New mysql_group_replication_hostgroups table
2024-08-14 13:58:14 [INFO] New mysql_galera_hostgroups table
2024-08-14 13:58:14 [INFO] New mysql_aws_aurora_hostgroups table
2024-08-14 13:58:14 [INFO] New mysql_hostgroup_attributes table
2024-08-14 13:58:14 [INFO] New mysql_servers_ssl_params table
2024-08-14 13:58:14 [INFO] Checksum for table mysql_servers_v2 is 0xEB07253C712EDC04
2024-08-14 13:58:14 [INFO] Checksum for table mysql_replication_hostgroups is 0x578B81540491ED50
2024-08-14 13:58:14 [INFO] New computed global checksum for 'mysql_servers_v2' is '0x9DC2954BC4F45CBB'
2024-08-14 13:58:14 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: 10.1.0.10 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.20 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
HID: 20 , address: 10.1.0.40 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 100 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment:
2024-08-14 13:58:14 [INFO] Dumping mysql_servers: ALL
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname  | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | 10.1.0.10 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434490826304 |
| 20  | 10.1.0.40 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324736 |
| 20  | 10.1.0.20 | 3306 | 0    | 1      | 0      | 0   | 100       | 0       | 0   | 0       |         | 140434364324544 |
+-----+-----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-08-14 13:58:14 [INFO] Checksum for table mysql_servers is 0xEB07253C712EDC04
2024-08-14 13:58:14 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0x91C566C02EC85691, new: 0x712EDC04EB07253C }, mysql_replication_hostgroups { old:0x578B81540491ED50, new:0x578B81540491ED50 }
2024-08-14 13:58:14 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms
2024-08-14 13:58:14 [INFO] Received SAVE MYSQL SERVERS TO DISK command
2024-08-14 13:58:16 [INFO] read_only_action_v2() detected RO=0 on server 10.1.0.10:3306 for the first time after commit(), but no need to reconfigure