Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

ProxySQL Switchover Fails on First LOAD MYSQL SERVERS TO RUNTIME Execution, Succeeds on Second #4750

Open
catyellow opened this issue Nov 15, 2024 · 2 comments
Open

ProxySQL Switchover Fails on First LOAD MYSQL SERVERS TO RUNTIME Execution, Succeeds on Second #4750

catyellow opened this issue Nov 15, 2024 · 2 comments

Comments

@catyellow
Copy link

Bug Description:

ProxySQL LOAD MYSQL SERVERS TO RUNTIME Requires Multiple Executions for Switchover to Take Effect

Issue

When updating the mysql_servers table to perform a switchover in ProxySQL, the expected changes do not fully take effect after executing LOAD MYSQL SERVERS TO RUNTIME a single time. The switchover works only if LOAD MYSQL SERVERS TO RUNTIME is executed twice, which is not the expected behavior.

ProxySQL Environment

  • Versions Tested: 2.5.5 and 2.7.1 (latest)
  • Docker Image Info: 
    REPOSITORY          TAG             IMAGE ID       CREATED         SIZE
proxysql/proxysql   latest          cd866337812d   7 weeks ago     601MB
proxysql/proxysql   2.5.5           37eb7e46d947   15 months ago   558MB
  • Version Details:
    • 2.5.5 
      proxysql-admin -e "SELECT version();"
+-------------------+
| version()         |
+-------------------+
| 2.5.5-10-g195bd70 |
+-------------------+
      • 2.7.1 (latest) 
        proxysql-admin -e "SELECT version();"
+-------------------+
| version()         |
+-------------------+
| 2.7.1-16-g2726c27 |
+-------------------+

Configuration

Basic configuration for mysql_servers and mysql_galera_hostgroups:

proxysql_admin -e "SELECT * FROM mysql_galera_hostgroups;"
+------------------+-------------------------+------------------+-------------------+--------+-------------+-----------------------+-------------------------+---------+
| writer_hostgroup | backup_writer_hostgroup | reader_hostgroup | offline_hostgroup | active | max_writers | writer_is_also_reader | max_transactions_behind | comment |
+------------------+-------------------------+------------------+-------------------+--------+-------------+-----------------------+-------------------------+---------+
| 10               | 11                      | 20               | 99                | 1      | 1           | 1                     | 50                      |         |
+------------------+-------------------------+------------------+-------------------+--------+-------------+-----------------------+-------------------------+---------+

proxysql_admin -e "SELECT * FROM mysql_servers;"
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | galera1  | 3306 | 0         | ONLINE | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | ONLINE | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | ONLINE | 50     | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+

Apply Basic Configuration:

proxysql-admin -e """
UPDATE mysql_servers SET weight=1, status='ONLINE';
UPDATE mysql_servers SET hostgroup_id=10, weight=50 where hostname='galera3';
LOAD MYSQL SERVERS TO RUNTIME;
LOAD MYSQL SERVERS TO RUNTIME;
SAVE MYSQL SERVERS TO DISK;
"""

Switchover:

  • Expected: Switchover should complete with a single LOAD MYSQL SERVERS TO RUNTIME.
  • Observed: Switchover does not take effect after the first LOAD MYSQL SERVERS TO RUNTIME. Only after a second LOAD MYSQL SERVERS TO RUNTIME is issued do the changes take effect.

Switchover Attempt (Single LOAD MYSQL SERVERS TO RUNTIME)

  • Check current configuration

    date; proxysql_admin -e "SELECT * FROM mysql_servers; SELECT * FROM runtime_mysql_servers;"
Fri Nov 15 01:23:56 CET 2024
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | galera1  | 3306 | 0         | ONLINE | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | ONLINE | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | ONLINE | 50     | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status  | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | galera1  | 3306 | 0         | SHUNNED | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | SHUNNED | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera2  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera2  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera3  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+

  • Run Switchover and Check Configuration

    date; proxysql_admin -e """
UPDATE mysql_servers SET weight = 50, hostgroup_id=10 WHERE hostname='galera2';
UPDATE mysql_servers SET weight = 1, hostgroup_id=11 WHERE hostname='galera3';
UPDATE mysql_servers SET status='ONLINE' WHERE hostname='galera2';
LOAD MYSQL SERVERS TO RUNTIME;
"""
SLEEP 5
date; proxysql_admin -e "SELECT * FROM mysql_servers; SELECT * FROM runtime_mysql_servers;"
    • Output: 
      Fri Nov 15 01:24:33 CET 2024
Fri Nov 15 01:24:38 CET 2024
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | galera1  | 3306 | 0         | ONLINE | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | ONLINE | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | ONLINE | 1      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status  | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | galera1  | 3306 | 0         | SHUNNED | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | SHUNNED | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera2  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera2  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera3  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+

Switchover Attempt (Double LOAD MYSQL SERVERS TO RUNTIME)

  • Check current configuration

    date; proxysql_admin -e "SELECT * FROM mysql_servers; SELECT * FROM runtime_mysql_servers;"
Fri Nov 15 01:25:58 CET 2024
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | galera1  | 3306 | 0         | ONLINE | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | ONLINE | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | ONLINE | 50     | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status  | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | galera1  | 3306 | 0         | SHUNNED | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | SHUNNED | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera2  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera2  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera3  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+

  • Run Switchover and Check Configuration

    date; proxysql_admin -e """
UPDATE mysql_servers SET weight = 50, hostgroup_id=10 WHERE hostname='galera2';
UPDATE mysql_servers SET weight = 1, hostgroup_id=11 WHERE hostname='galera3';
UPDATE mysql_servers SET status='ONLINE' WHERE hostname='galera2';
LOAD MYSQL SERVERS TO RUNTIME;
LOAD MYSQL SERVERS TO RUNTIME;
"""
SLEEP 5
date; proxysql_admin -e "SELECT * FROM mysql_servers; SELECT * FROM runtime_mysql_servers;"
    • Output: 
      Fri Nov 15 01:26:27 CET 2024
Fri Nov 15 01:26:32 CET 2024
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | galera1  | 3306 | 0         | ONLINE | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | ONLINE | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | ONLINE | 1      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status  | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | galera1  | 3306 | 0         | SHUNNED | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | SHUNNED | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera2  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera3  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+

Outcome

With two executions of LOAD MYSQL SERVERS TO RUNTIME, the switchover completes successfully, with galera2 promoted as expected.

Summary

ProxySQL requires two LOAD MYSQL SERVERS TO RUNTIME commands for a switchover to take effect, contrary to the expected behavior where one command should be sufficient. This behavior persists across both ProxySQL 2.5.5 and 2.7.1, in Docker images as well.
@renecannao
Copy link
Contributor

And according to the error log ...

@gdmrykmas
Copy link

ProxySQL Logs (re-tested, 2 cases)

Switchover Attempt (Single LOAD MYSQL SERVERS TO RUNTIME)

  • Versions Tested: 2.7.1 (latest)
  • Docker Image Info: proxysql/proxysql:latest (cd866337812d)

Command

date; proxysql_admin -e """
UPDATE mysql_servers SET weight = 50, hostgroup_id=10 WHERE hostname='galera2';
UPDATE mysql_servers SET weight = 1, hostgroup_id=11 WHERE hostname='galera3';
UPDATE mysql_servers SET status='ONLINE' WHERE hostname='galera2';
LOAD MYSQL SERVERS TO RUNTIME;
"""
SLEEP 5
date; proxysql_admin -e "SELECT * FROM mysql_servers; SELECT * FROM runtime_mysql_servers;"

Output

Fri Nov 15 03:07:34 CET 2024
Fri Nov 15 03:07:39 CET 2024
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | galera1  | 3306 | 0         | ONLINE | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | ONLINE | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | ONLINE | 1      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status  | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | galera1  | 3306 | 0         | SHUNNED | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | SHUNNED | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera2  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera2  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera3  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+

ProxySQL Log

!! There is 1h diff between parent host (CET) and docker container (UTC)

docker logs -f proxysql

2024-11-15 02:07:34 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2024-11-15 02:07:34 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-11-15 02:07:34 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:34 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072674304 |
| 11  | galera2  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072674112 |
| 20  | galera2  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072673344 |
| 20  | galera3  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072672960 |
| 20  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072673920 |
| 10  | galera3  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072673152 |
| 10  | galera2  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:34 [INFO] Dumping mysql_servers_incoming
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:07:34 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-----------------+--------------+----------+------+
| mem_pointer     | hostgroup_id | hostname | port |
+-----------------+--------------+----------+------+
| 281473072674304 | 11           | galera1  | 3306 |
| 281473072674112 | 11           | galera2  | 3306 |
| 281473072673344 | 20           | galera2  | 3306 |
| 281473072672960 | 20           | galera3  | 3306 |
| 281473072673920 | 20           | galera1  | 3306 |
| 281473072673152 | 10           | galera3  | 3306 |
+-----------------+--------------+----------+------+
2024-11-15 02:07:34 MySQL_HostGroups_Manager.cpp:1294:commit(): [WARNING] Removed server at address 281473072674304, hostgroup 11, address galera1 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-11-15 02:07:34 MySQL_HostGroups_Manager.cpp:1294:commit(): [WARNING] Removed server at address 281473072674112, hostgroup 11, address galera2 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-11-15 02:07:34 MySQL_HostGroups_Manager.cpp:1294:commit(): [WARNING] Removed server at address 281473072673344, hostgroup 20, address galera2 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-11-15 02:07:34 MySQL_HostGroups_Manager.cpp:1294:commit(): [WARNING] Removed server at address 281473072672960, hostgroup 20, address galera3 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-11-15 02:07:34 MySQL_HostGroups_Manager.cpp:1294:commit(): [WARNING] Removed server at address 281473072673920, hostgroup 20, address galera1 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-11-15 02:07:34 MySQL_HostGroups_Manager.cpp:1294:commit(): [WARNING] Removed server at address 281473072673152, hostgroup 10, address galera3 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-11-15 02:07:34 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer     | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | galera1  | 3306 | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         | 281473230968448 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         | 281473230968640 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         | 0               | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:07:34 [INFO] Changing status for server 10:galera1:3306 (galera1:3306) from 1 (1) to 0
2024-11-15 02:07:34 [INFO] Changing status for server 10:galera2:3306 (galera2:3306) from 1 (1) to 0
2024-11-15 02:07:34 [INFO] Creating new server in HG 11 : galera3:3306 , gtid_port=0, weight=1, status=0
2024-11-15 02:07:34 [INFO] New mysql_replication_hostgroups table
2024-11-15 02:07:34 [INFO] New mysql_group_replication_hostgroups table
2024-11-15 02:07:34 [INFO] New mysql_galera_hostgroups table
2024-11-15 02:07:34 [INFO] Loading Galera info for (10,11,20,99,on,1,1,50,"")
2024-11-15 02:07:34 [INFO] New mysql_aws_aurora_hostgroups table
2024-11-15 02:07:34 [INFO] New mysql_hostgroup_attributes table
2024-11-15 02:07:34 [INFO] New mysql_servers_ssl_params table
2024-11-15 02:07:34 [INFO] Checksum for table mysql_servers_v2 is 0x54C2B1D5B60DC9DE
2024-11-15 02:07:34 [INFO] Checksum for table mysql_galera_hostgroups is 0x6C1518F67FBF3B8A
2024-11-15 02:07:34 [INFO] New computed global checksum for 'mysql_servers_v2' is '0x58966075E8CC18C0'
2024-11-15 02:07:34 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:34 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
| 11  | galera1  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072674304 |
| 11  | galera2  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072674112 |
| 20  | galera2  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072673344 |
| 20  | galera3  | 3306 | 0    | 50     | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072672960 |
| 20  | galera1  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072673920 |
| 10  | galera3  | 3306 | 0    | 50     | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072673152 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:34 [INFO] Checksum for table mysql_servers is 0x54C2B1D5B60DC9DE
2024-11-15 02:07:34 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0x5BC1D012093E2B50, new: 0xB60DC9DE54C2B1D5 }, mysql_replication_hostgroups { old:0x0, new:0x0 }
2024-11-15 02:07:34 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2024-11-15 02:07:38 MySQL_HostGroups_Manager.cpp:5450:update_galera_set_writer(): [WARNING] Galera: too many writers in HG 10. Max=1, current=2
2024-11-15 02:07:38 MySQL_HostGroups_Manager.cpp:5545:update_galera_set_writer(): [WARNING] Galera: setting host galera2:3306 as writer
2024-11-15 02:07:38 [INFO] Galera: Node status changed by ProxySQL, dumping all galera nodes status:
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
| hostname | port | start_time       | check_time | primary_partition | read_only | wsrep_local_recv_queue | wsrep_local_state | wsrep_desync | wsrep_reject_queries | wsrep_sst_donor_rejects_queries | pxc_maint_mode | error |
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
| galera1  | 3306 | 1731636453596233 | 3431       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
| galera2  | 3306 | 1731636458599617 | 2963       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
| galera3  | 3306 | 1731636453597398 | 2944       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
2024-11-15 02:07:38 [INFO] Generating runtime mysql servers records only.
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:38 [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           | galera1  | 3306 | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | 1      | 3      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera3  | 3306 | 0         | 50     | 3      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | 1      | 3      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | 50     | 3      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:07:38 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-11-15 02:07:38 [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           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         | 281473230968448 | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | 1      | 3      | 0           | 20              | 0                   | 0       | 0              |         | 0               | 0         | 1      | 3      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera3  | 3306 | 0         | 50     | 3      | 0           | 20              | 0                   | 0       | 0              |         | 0               | 0         | 50     | 3      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | 1      | 3      | 0           | 20              | 0                   | 0       | 0              |         | 0               | 0         | 1      | 3      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | 50     | 3      | 0           | 20              | 0                   | 0       | 0              |         | 0               | 0         | 50     | 3      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         | 0               | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:07:38 [INFO] Changing status for server 10:galera1:3306 (galera1:3306) from 0 (0) to 1
2024-11-15 02:07:38 [INFO] Creating new server in HG 11 : galera1:3306 , gtid_port=0, weight=1, status=3
2024-11-15 02:07:38 [INFO] Creating new server in HG 20 : galera3:3306 , gtid_port=0, weight=50, status=3
2024-11-15 02:07:38 [INFO] Creating new server in HG 20 : galera1:3306 , gtid_port=0, weight=1, status=3
2024-11-15 02:07:38 [INFO] Creating new server in HG 10 : galera3:3306 , gtid_port=0, weight=50, status=3
2024-11-15 02:07:38 [INFO] Creating new server in HG 20 : galera2:3306 , gtid_port=0, weight=50, status=0
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera1  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686208 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
| 20  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686976 |
| 20  | galera1  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686592 |
| 20  | galera3  | 3306 | 0    | 50     | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686400 |
| 10  | galera3  | 3306 | 0    | 50     | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686784 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:38 [INFO] Checksum for table mysql_servers is 0xF047086F1F23826C
2024-11-15 02:07:38 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0xB60DC9DE54C2B1D5, new: 0x1F23826CF047086F }, mysql_replication_hostgroups { old:0x0, new:0x0 }
2024-11-15 02:07:38 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup 10
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: HG 10
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
| 10  | galera3  | 3306 | 0    | 50     | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686784 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup 11
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: HG 11
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 11  | galera1  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686208 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup 20
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: HG 20
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 20  | galera1  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686592 |
| 20  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686976 |
| 20  | galera3  | 3306 | 0    | 50     | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686400 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup 99
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: HG 99
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
2024-11-15 02:07:38 MySQL_HostGroups_Manager.cpp:5545:update_galera_set_writer(): [WARNING] Galera: setting host galera3:3306 as writer
2024-11-15 02:07:38 [INFO] Galera: Node status changed by ProxySQL, dumping all galera nodes status:
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
| hostname | port | start_time       | check_time | primary_partition | read_only | wsrep_local_recv_queue | wsrep_local_state | wsrep_desync | wsrep_reject_queries | wsrep_sst_donor_rejects_queries | pxc_maint_mode | error |
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
| galera1  | 3306 | 1731636453596233 | 3431       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
| galera2  | 3306 | 1731636458599617 | 2963       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
| galera3  | 3306 | 1731636458605602 | 2778       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
2024-11-15 02:07:38 [INFO] Generating runtime mysql servers records only.
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
| 20  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686976 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:38 [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           | galera1  | 3306 | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | 50     | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | 1      | 3      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | 1      | 3      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera3  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:07:38 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-----------------+--------------+----------+------+
| mem_pointer     | hostgroup_id | hostname | port |
+-----------------+--------------+----------+------+
| 281473068709376 | 11           | galera3  | 3306 |
+-----------------+--------------+----------+------+
2024-11-15 02:07:38 MySQL_HostGroups_Manager.cpp:1294:commit(): [WARNING] Removed server at address 281473068709376, hostgroup 11, address galera3 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-11-15 02:07:38 [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           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         | 281473230968640 | 0         | 50     | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         | 0               | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | 1      | 3      | 0           | 20              | 0                   | 0       | 0              |         | 0               | 0         | 1      | 3      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | 1      | 3      | 0           | 20              | 0                   | 0       | 0              |         | 0               | 0         | 1      | 3      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera3  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         | 0               | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         | 0               | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:07:38 [INFO] Changing status for server 10:galera2:3306 (galera2:3306) from 0 (0) to 1
2024-11-15 02:07:38 [INFO] Creating new server in HG 10 : galera3:3306 , gtid_port=0, weight=50, status=0
2024-11-15 02:07:38 [INFO] Creating new server in HG 11 : galera1:3306 , gtid_port=0, weight=1, status=3
2024-11-15 02:07:38 [INFO] Creating new server in HG 20 : galera1:3306 , gtid_port=0, weight=1, status=3
2024-11-15 02:07:38 [INFO] Creating new server in HG 20 : galera3:3306 , gtid_port=0, weight=50, status=0
2024-11-15 02:07:38 [INFO] Creating new server in HG 11 : galera2:3306 , gtid_port=0, weight=50, status=0
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072687168 |
| 11  | galera1  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686400 |
| 11  | galera3  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
| 20  | galera3  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686784 |
| 20  | galera1  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686592 |
| 20  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686976 |
| 10  | galera3  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686208 |
| 10  | galera2  | 3306 | 0    | 50     | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:38 [INFO] Checksum for table mysql_servers is 0x7FB80A5D8393CC6F
2024-11-15 02:07:38 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0x1F23826CF047086F, new: 0x8393CC6F7FB80A5D }, mysql_replication_hostgroups { old:0x0, new:0x0 }
2024-11-15 02:07:38 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup 10
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: HG 10
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 10  | galera2  | 3306 | 0    | 50     | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
| 10  | galera3  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686208 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup 11
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: HG 11
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 11  | galera1  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686400 |
| 11  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072687168 |
| 11  | galera3  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup 20
HID: 20 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: HG 20
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 20  | galera1  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686592 |
| 20  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686976 |
| 20  | galera3  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686784 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup 99
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: HG 99
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
2024-11-15 02:07:38 MySQL_HostGroups_Manager.cpp:5545:update_galera_set_writer(): [WARNING] Galera: setting host galera1:3306 as writer
2024-11-15 02:07:38 [INFO] Galera: Node status changed by ProxySQL, dumping all galera nodes status:
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
| hostname | port | start_time       | check_time | primary_partition | read_only | wsrep_local_recv_queue | wsrep_local_state | wsrep_desync | wsrep_reject_queries | wsrep_sst_donor_rejects_queries | pxc_maint_mode | error |
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
| galera1  | 3306 | 1731636458610451 | 3344       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
| galera2  | 3306 | 1731636458599617 | 2963       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
| galera3  | 3306 | 1731636458605602 | 2778       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
2024-11-15 02:07:38 [INFO] Generating runtime mysql servers records only.
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072687168 |
| 20  | galera3  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686784 |
| 20  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686976 |
| 10  | galera3  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686208 |
| 10  | galera2  | 3306 | 0    | 50     | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:38 [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           | galera1  | 3306 | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | 50     | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | 1      | 3      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera3  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:07:38 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-11-15 02:07:38 [INFO] Dumping mysql_servers JOIN mysql_servers_incoming
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment | mem_pointer | gtid_port | weight | status | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 11           | galera3  | 3306 | 0         | 1      | 3      | 0           | 20              | 0                   | 0       | 0              |         | 0           | 0         | 1      | 3      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         | 0           | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         | 0           | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:07:38 [INFO] Creating new server in HG 11 : galera3:3306 , gtid_port=0, weight=1, status=3
2024-11-15 02:07:38 [INFO] Creating new server in HG 20 : galera1:3306 , gtid_port=0, weight=1, status=0
2024-11-15 02:07:38 [INFO] Creating new server in HG 11 : galera1:3306 , gtid_port=0, weight=1, status=0
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686016 |
| 11  | galera3  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072685632 |
| 11  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072687168 |
| 20  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072685824 |
| 20  | galera3  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686784 |
| 20  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686976 |
| 10  | galera3  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686208 |
| 10  | galera2  | 3306 | 0    | 50     | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:38 [INFO] Checksum for table mysql_servers is 0x7865C860740A7C95
2024-11-15 02:07:38 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0x8393CC6F7FB80A5D, new: 0x740A7C957865C860 }, mysql_replication_hostgroups { old:0x0, new:0x0 }
2024-11-15 02:07:38 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup 10
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: HG 10
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 10  | galera2  | 3306 | 0    | 50     | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
| 10  | galera3  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686208 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup 11
HID: 11 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: HG 11
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 11  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686016 |
| 11  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072687168 |
| 11  | galera3  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072685632 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup 20
HID: 20 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: HG 20
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 20  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072685824 |
| 20  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686976 |
| 20  | galera3  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686784 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:07:38 [INFO] Dumping current MySQL Servers structures for hostgroup 99
2024-11-15 02:07:38 [INFO] Dumping mysql_servers: HG 99
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+

Switchover Attempt (Double LOAD MYSQL SERVERS TO RUNTIME)

  • Versions Tested: 2.7.1 (latest)
  • Docker Image Info: proxysql/proxysql:latest (cd866337812d)

Command

date; proxysql_admin -e """
UPDATE mysql_servers SET weight = 50, hostgroup_id=10 WHERE hostname='galera2';
UPDATE mysql_servers SET weight = 1, hostgroup_id=11 WHERE hostname='galera3';
UPDATE mysql_servers SET status='ONLINE' WHERE hostname='galera2';
LOAD MYSQL SERVERS TO RUNTIME;
LOAD MYSQL SERVERS TO RUNTIME;
"""
SLEEP 5
date; proxysql_admin -e "SELECT * FROM mysql_servers; SELECT * FROM runtime_mysql_servers;"

Output

Fri Nov 15 03:12:57 CET 2024
Fri Nov 15 03:13:02 CET 2024
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | galera1  | 3306 | 0         | ONLINE | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | ONLINE | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | ONLINE | 1      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname | port | gtid_port | status  | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | galera1  | 3306 | 0         | SHUNNED | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | SHUNNED | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera2  | 3306 | 0         | ONLINE  | 50     | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera3  | 3306 | 0         | ONLINE  | 1      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+

ProxySQL Log

!! There is 1h diff between parent host (CET) and docker container (UTC)

docker logs -f proxysql

2024-11-15 02:12:57 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2024-11-15 02:12:57 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-11-15 02:12:57 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:57 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686592 |
| 11  | galera2  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686400 |
| 20  | galera2  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072685440 |
| 20  | galera3  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072685248 |
| 20  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686016 |
| 10  | galera3  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072686208 |
| 10  | galera2  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:57 [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           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:12:57 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-----------------+--------------+----------+------+
| mem_pointer     | hostgroup_id | hostname | port |
+-----------------+--------------+----------+------+
| 281473072686592 | 11           | galera1  | 3306 |
| 281473072686400 | 11           | galera2  | 3306 |
| 281473072685440 | 20           | galera2  | 3306 |
| 281473072685248 | 20           | galera3  | 3306 |
| 281473072686016 | 20           | galera1  | 3306 |
| 281473072686208 | 10           | galera3  | 3306 |
+-----------------+--------------+----------+------+
2024-11-15 02:12:57 MySQL_HostGroups_Manager.cpp:1294:commit(): [WARNING] Removed server at address 281473072686592, hostgroup 11, address galera1 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-11-15 02:12:57 MySQL_HostGroups_Manager.cpp:1294:commit(): [WARNING] Removed server at address 281473072686400, hostgroup 11, address galera2 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-11-15 02:12:57 MySQL_HostGroups_Manager.cpp:1294:commit(): [WARNING] Removed server at address 281473072685440, hostgroup 20, address galera2 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-11-15 02:12:57 MySQL_HostGroups_Manager.cpp:1294:commit(): [WARNING] Removed server at address 281473072685248, hostgroup 20, address galera3 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-11-15 02:12:57 MySQL_HostGroups_Manager.cpp:1294:commit(): [WARNING] Removed server at address 281473072686016, hostgroup 20, address galera1 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-11-15 02:12:57 MySQL_HostGroups_Manager.cpp:1294:commit(): [WARNING] Removed server at address 281473072686208, hostgroup 10, address galera3 port 3306. Setting status OFFLINE HARD and immediately dropping all free connections. Used connections will be dropped when trying to use them
2024-11-15 02:12:57 [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           | galera1  | 3306 | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         | 281473230968448 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         | 281473230968640 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         | 0               | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:12:57 [INFO] Changing status for server 10:galera1:3306 (galera1:3306) from 1 (1) to 0
2024-11-15 02:12:57 [INFO] Changing status for server 10:galera2:3306 (galera2:3306) from 1 (1) to 0
2024-11-15 02:12:57 [INFO] Creating new server in HG 11 : galera3:3306 , gtid_port=0, weight=1, status=0
2024-11-15 02:12:57 [INFO] New mysql_replication_hostgroups table
2024-11-15 02:12:57 [INFO] New mysql_group_replication_hostgroups table
2024-11-15 02:12:57 [INFO] New mysql_galera_hostgroups table
2024-11-15 02:12:57 [INFO] Loading Galera info for (10,11,20,99,on,1,1,50,"")
2024-11-15 02:12:57 [INFO] New mysql_aws_aurora_hostgroups table
2024-11-15 02:12:57 [INFO] New mysql_hostgroup_attributes table
2024-11-15 02:12:57 [INFO] New mysql_servers_ssl_params table
2024-11-15 02:12:57 [INFO] Checksum for table mysql_servers_v2 is 0x54C2B1D5B60DC9DE
2024-11-15 02:12:57 [INFO] Checksum for table mysql_galera_hostgroups is 0x6C1518F67FBF3B8A
2024-11-15 02:12:57 [INFO] New computed global checksum for 'mysql_servers_v2' is '0x58966075E8CC18C0'
2024-11-15 02:12:57 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 50 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: OFFLINE_HARD , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:57 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
| 11  | galera1  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686592 |
| 11  | galera2  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686400 |
| 20  | galera2  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072685440 |
| 20  | galera3  | 3306 | 0    | 50     | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072685248 |
| 20  | galera1  | 3306 | 0    | 1      | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686016 |
| 10  | galera3  | 3306 | 0    | 50     | 3      | 0   | 20        | 0       | 0   | 0       |         | 281473072686208 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:57 [INFO] Checksum for table mysql_servers is 0x54C2B1D5B60DC9DE
2024-11-15 02:12:57 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0x5BC1D012093E2B50, new: 0xB60DC9DE54C2B1D5 }, mysql_replication_hostgroups { old:0x0, new:0x0 }
2024-11-15 02:12:57 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2024-11-15 02:12:57 [INFO] Received LOAD MYSQL SERVERS TO RUNTIME command
2024-11-15 02:12:57 [INFO] Generating runtime mysql servers and mysql servers v2 records.
2024-11-15 02:12:57 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:57 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:57 [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           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:12:57 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-11-15 02:12:57 [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-11-15 02:12:57 [INFO] New mysql_replication_hostgroups table
2024-11-15 02:12:57 [INFO] New mysql_group_replication_hostgroups table
2024-11-15 02:12:57 [INFO] New mysql_galera_hostgroups table
2024-11-15 02:12:57 [INFO] Loading Galera info for (10,11,20,99,on,1,1,50,"")
2024-11-15 02:12:57 [INFO] New mysql_aws_aurora_hostgroups table
2024-11-15 02:12:57 [INFO] New mysql_hostgroup_attributes table
2024-11-15 02:12:57 [INFO] New mysql_servers_ssl_params table
2024-11-15 02:12:57 [INFO] Checksum for table mysql_servers_v2 is 0x54C2B1D5B60DC9DE
2024-11-15 02:12:57 [INFO] Checksum for table mysql_galera_hostgroups is 0x6C1518F67FBF3B8A
2024-11-15 02:12:57 [INFO] New computed global checksum for 'mysql_servers_v2' is '0x58966075E8CC18C0'
2024-11-15 02:12:57 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:57 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:57 [INFO] Checksum for table mysql_servers is 0x54C2B1D5B60DC9DE
2024-11-15 02:12:57 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2024-11-15 02:12:58 MySQL_HostGroups_Manager.cpp:5450:update_galera_set_writer(): [WARNING] Galera: too many writers in HG 10. Max=1, current=2
2024-11-15 02:12:58 MySQL_HostGroups_Manager.cpp:5545:update_galera_set_writer(): [WARNING] Galera: setting host galera1:3306 as writer
2024-11-15 02:12:58 [INFO] Galera: Node status changed by ProxySQL, dumping all galera nodes status:
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
| hostname | port | start_time       | check_time | primary_partition | read_only | wsrep_local_recv_queue | wsrep_local_state | wsrep_desync | wsrep_reject_queries | wsrep_sst_donor_rejects_queries | pxc_maint_mode | error |
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
| galera1  | 3306 | 1731636778761531 | 2517       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
| galera2  | 3306 | 1731636773761483 | 3227       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
| galera3  | 3306 | 1731636773762492 | 2987       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
2024-11-15 02:12:58 [INFO] Generating runtime mysql servers records only.
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:58 [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           | galera1  | 3306 | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:12:58 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-11-15 02:12:58 [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           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         | 281473230968448 | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         | 0               | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         | 0               | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-----------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:12:58 [INFO] Changing status for server 10:galera1:3306 (galera1:3306) from 0 (0) to 1
2024-11-15 02:12:58 [INFO] Creating new server in HG 20 : galera1:3306 , gtid_port=0, weight=1, status=0
2024-11-15 02:12:58 [INFO] Creating new server in HG 11 : galera1:3306 , gtid_port=0, weight=1, status=0
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575232 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
| 20  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575040 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:58 [INFO] Checksum for table mysql_servers is 0xE22A9AE48C661A82
2024-11-15 02:12:58 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0xB60DC9DE54C2B1D5, new: 0x8C661A82E22A9AE4 }, mysql_replication_hostgroups { old:0x0, new:0x0 }
2024-11-15 02:12:58 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup 10
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: HG 10
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup 11
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: HG 11
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 11  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575232 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup 20
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: HG 20
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 20  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575040 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup 99
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: HG 99
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
2024-11-15 02:12:58 MySQL_HostGroups_Manager.cpp:5545:update_galera_set_writer(): [WARNING] Galera: setting host galera3:3306 as writer
2024-11-15 02:12:58 [INFO] Galera: Node status changed by ProxySQL, dumping all galera nodes status:
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
| hostname | port | start_time       | check_time | primary_partition | read_only | wsrep_local_recv_queue | wsrep_local_state | wsrep_desync | wsrep_reject_queries | wsrep_sst_donor_rejects_queries | pxc_maint_mode | error |
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
| galera1  | 3306 | 1731636778761531 | 2517       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
| galera2  | 3306 | 1731636773761483 | 3227       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
| galera3  | 3306 | 1731636778767514 | 2158       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
2024-11-15 02:12:58 [INFO] Generating runtime mysql servers records only.
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575232 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
| 20  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575040 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:58 [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           | galera1  | 3306 | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera3  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:12:58 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-11-15 02:12:58 [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           | galera3  | 3306 | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         | 0           | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera3  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         | 0           | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:12:58 [INFO] Creating new server in HG 10 : galera3:3306 , gtid_port=0, weight=1, status=1
2024-11-15 02:12:58 [INFO] Creating new server in HG 20 : galera3:3306 , gtid_port=0, weight=1, status=0
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575232 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
| 20  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575424 |
| 20  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575040 |
| 10  | galera3  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473072574848 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:58 [INFO] Checksum for table mysql_servers is 0xDC983A643D2A5416
2024-11-15 02:12:58 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0x8C661A82E22A9AE4, new: 0x3D2A5416DC983A64 }, mysql_replication_hostgroups { old:0x0, new:0x0 }
2024-11-15 02:12:58 [INFO] MySQL_HostGroups_Manager::commit() locked for 2ms
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup 10
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: HG 10
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
| 10  | galera3  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473072574848 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup 11
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: HG 11
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 11  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575232 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup 20
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: HG 20
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 20  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575040 |
| 20  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575424 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup 99
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: HG 99
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
2024-11-15 02:12:58 MySQL_HostGroups_Manager.cpp:5545:update_galera_set_writer(): [WARNING] Galera: setting host galera2:3306 as writer
2024-11-15 02:12:58 [INFO] Galera: Node status changed by ProxySQL, dumping all galera nodes status:
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
| hostname | port | start_time       | check_time | primary_partition | read_only | wsrep_local_recv_queue | wsrep_local_state | wsrep_desync | wsrep_reject_queries | wsrep_sst_donor_rejects_queries | pxc_maint_mode | error |
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
| galera1  | 3306 | 1731636778761531 | 2517       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
| galera2  | 3306 | 1731636778772159 | 2297       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
| galera3  | 3306 | 1731636778767514 | 2158       | 1                 | 0         | 0                      | 4                 | 0            | 0                    | 0                               | 0              |       |
+----------+------+------------------+------------+-------------------+-----------+------------------------+-------------------+--------------+----------------------+---------------------------------+----------------+-------+
2024-11-15 02:12:58 [INFO] Generating runtime mysql servers records only.
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575232 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
| 20  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575424 |
| 20  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575040 |
| 10  | galera3  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473072574848 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:58 [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           | galera1  | 3306 | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera3  | 3306 | 0         | 1      | 1      | 0           | 20              | 0                   | 0       | 0              |         |
| 10           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera3  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 11           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera1  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera3  | 3306 | 0         | 1      | 0      | 0           | 20              | 0                   | 0       | 0              |         |
| 20           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:12:58 [INFO] Dumping mysql_servers LEFT JOIN mysql_servers_incoming
+-------------+--------------+----------+------+
| mem_pointer | hostgroup_id | hostname | port |
+-------------+--------------+----------+------+
+-------------+--------------+----------+------+
2024-11-15 02:12:58 [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           | galera2  | 3306 | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         | 0           | 0         | 50     | 0      | 0           | 20              | 0                   | 0       | 0              |         |
+--------------+----------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+-------------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
2024-11-15 02:12:58 [INFO] Creating new server in HG 20 : galera2:3306 , gtid_port=0, weight=50, status=0
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup ALL
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: ALL
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 11  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575232 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
| 20  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072574656 |
| 20  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575424 |
| 20  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575040 |
| 10  | galera3  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473072574848 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:58 [INFO] Checksum for table mysql_servers is 0x360F1AA4A4B06B03
2024-11-15 02:12:58 [INFO] Rebuilding 'Hostgroup_Manager_Mapping' due to checksums change - mysql_servers { old: 0x3D2A5416DC983A64, new: 0xA4B06B03360F1AA4 }, mysql_replication_hostgroups { old:0x0, new:0x0 }
2024-11-15 02:12:58 [INFO] MySQL_HostGroups_Manager::commit() locked for 1ms
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup 10
HID: 10 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 10 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: SHUNNED , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: HG 10
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 10  | galera1  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473230968448 |
| 10  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473230968640 |
| 10  | galera3  | 3306 | 0    | 1      | 1      | 0   | 20        | 0       | 0   | 0       |         | 281473072574848 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup 11
HID: 11 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 11 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: HG 11
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 11  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575232 |
| 11  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473068709376 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup 20
HID: 20 , address: galera1 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera3 , port: 3306 , gtid_port: 0 , weight: 1 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
HID: 20 , address: galera2 , port: 3306 , gtid_port: 0 , weight: 50 , status: ONLINE , max_connections: 20 , max_replication_lag: 0 , use_ssl: 0 , max_latency_ms: 0 , comment: 
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: HG 20
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer     |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
| 20  | galera1  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575040 |
| 20  | galera2  | 3306 | 0    | 50     | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072574656 |
| 20  | galera3  | 3306 | 0    | 1      | 0      | 0   | 20        | 0       | 0   | 0       |         | 281473072575424 |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-----------------+
2024-11-15 02:12:58 [INFO] Dumping current MySQL Servers structures for hostgroup 99
2024-11-15 02:12:58 [INFO] Dumping mysql_servers: HG 99
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
| hid | hostname | port | gtid | weight | status | cmp | max_conns | max_lag | ssl | max_lat | comment | mem_pointer |
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+
+-----+----------+------+------+--------+--------+-----+-----------+---------+-----+---------+---------+-------------+

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@renecannao @catyellow @gdmrykmas