orchestrator+proxysql+mysql5.7GTID主从切换测试过程
admin
2023-04-15 19:21:54
0次 
[root@es2 ~]# cat <>> INSERT INTO mysql_servers(hostgroup_id,hostname,port) VALUES (10,'192.168.56.14',3306);
Query OK, 1 row affected (0.00 sec)

admin@127.0.0.1 [(none)] 11:22:51>>>  INSERT INTO mysql_servers(hostgroup_id,hostname,port) VALUES (10,'192.168.56.15',3306);
Query OK, 1 row affected (0.00 sec)

admin@127.0.0.1 [(none)] 11:22:51>>>    INSERT INTO mysql_servers(hostgroup_id,hostname,port) VALUES (10,'192.168.56.16',3306);
Query OK, 1 row affected (0.00 sec)

admin@127.0.0.1 [(none)] 11:22:53>>>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           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 10           | 192.168.56.15 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 10           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
3 rows in set (0.00 sec)

admin@127.0.0.1 [(none)] 11:23:23>>>SET mysql-monitor_username='orchestrator';
Query OK, 1 row affected (0.00 sec)

admin@127.0.0.1 [(none)] 11:25:11>>>SET mysql-monitor_password='123456';
Query OK, 1 row affected (0.00 sec)

admin@127.0.0.1 [(none)] 11:25:12>>>LOAD MYSQL VARIABLES TO RUNTIME;
Query OK, 0 rows affected (0.00 sec)

admin@127.0.0.1 [(none)] 11:25:22>>>SAVE MYSQL VARIABLES TO DISK;
Query OK, 121 rows affected (0.01 sec)

admin@127.0.0.1 [(none)] 11:25:40>>>select * from mysql_server_connect_log;
+---------------+------+------------------+-------------------------+--------------------------------------------------------------+
| hostname      | port | time_start_us    | connect_success_time_us | connect_error                                                |
+---------------+------+------------------+-------------------------+--------------------------------------------------------------+
| 192.168.56.15 | 3306 | 1565839397686017 | 0                       | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839398441691 | 0                       | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839399196500 | 0                       | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839457686993 | 0                       | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839458185679 | 0                       | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839458685105 | 0                       | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839517686866 | 0                       | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839518451995 | 0                       | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839519217338 | 0                       | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839522987508 | 666                     | NULL                                                         |
| 192.168.56.16 | 3306 | 1565839523694983 | 4102                    | NULL                                                         |
| 192.168.56.14 | 3306 | 1565839524401835 | 1277                    | NULL                                                         |
+---------------+------+------------------+-------------------------+--------------------------------------------------------------+
12 rows in set (0.00 sec)

admin@127.0.0.1 [(none)] 11:26:01>>>select * from mysql_server_ping_log;
+---------------+------+------------------+----------------------+--------------------------------------------------------------+
| hostname      | port | time_start_us    | ping_success_time_us | ping_error                                                   |
+---------------+------+------------------+----------------------+--------------------------------------------------------------+
| 192.168.56.14 | 3306 | 1565839377692552 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839377784500 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839377876466 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839387692396 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839387796187 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839387899871 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839397701776 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839397818564 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839397935581 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839407701496 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839407774308 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839407847409 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839417701921 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839417800955 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839417899369 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839427702073 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839427792125 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839427882348 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839437702941 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839437819812 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839437937009 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839447703826 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839447820965 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839447938195 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839457704500 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839457815540 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839457926355 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839467704770 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839467824645 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839467944884 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839477705270 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839477807078 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839477909188 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839487705864 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839487836013 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839487966243 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839497706178 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839497808802 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839497911180 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839507706497 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839507808442 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839507910607 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.16 | 3306 | 1565839517707345 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.14 | 3306 | 1565839517815147 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839517922987 | 0                    | Access denied for user 'monitor'@'es2' (using password: YES) |
| 192.168.56.15 | 3306 | 1565839523039065 | 232                  | NULL                                                         |
| 192.168.56.14 | 3306 | 1565839523133408 | 1207                 | NULL                                                         |
| 192.168.56.16 | 3306 | 1565839523227794 | 1413                 | NULL                                                         |
| 192.168.56.14 | 3306 | 1565839533039563 | 1542                 | NULL                                                         |
| 192.168.56.16 | 3306 | 1565839533138738 | 1525                 | NULL                                                         |
| 192.168.56.15 | 3306 | 1565839533238017 | 411                  | NULL                                                         |
| 192.168.56.15 | 3306 | 1565839543040819 | 272                  | NULL                                                         |
| 192.168.56.14 | 3306 | 1565839543172288 | 1806                 | NULL                                                         |
| 192.168.56.16 | 3306 | 1565839543303207 | 1774                 | NULL                                                         |
| 192.168.56.16 | 3306 | 1565839553041501 | 1603                 | NULL                                                         |
| 192.168.56.15 | 3306 | 1565839553143450 | 276                  | NULL                                                         |
| 192.168.56.14 | 3306 | 1565839553244967 | 1399                 | NULL                                                         |
| 192.168.56.16 | 3306 | 1565839563042350 | 1510                 | NULL                                                         |
| 192.168.56.14 | 3306 | 1565839563120995 | 1418                 | NULL                                                         |
| 192.168.56.15 | 3306 | 1565839563199256 | 277                  | NULL                                                         |
| 192.168.56.14 | 3306 | 1565839573042777 | 1518                 | NULL                                                         |
| 192.168.56.15 | 3306 | 1565839573159144 | 374                  | NULL                                                         |
| 192.168.56.16 | 3306 | 1565839573275584 | 1672                 | NULL                                                         |
+---------------+------+------------------+----------------------+--------------------------------------------------------------+
63 rows in set (0.00 sec)

admin@127.0.0.1 [(none)] 11:26:21>>>INSERT INTO mysql_replication_hostgroups VALUES(10,20,"read_only","test replication with read and write separation");
Query OK, 1 row affected (0.00 sec)

admin@127.0.0.1 [(none)] 11:26:37>>>SELECT * FROM mysql_replication_hostgroups;
+------------------+------------------+------------+-------------------------------------------------+
| writer_hostgroup | reader_hostgroup | check_type | comment                                         |
+------------------+------------------+------------+-------------------------------------------------+
| 10               | 20               | read_only  | test replication with read and write separation |
+------------------+------------------+------------+-------------------------------------------------+
1 row in set (0.00 sec)

admin@127.0.0.1 [(none)] 11:26:51>>>LOAD MYSQL SERVERS TO RUNTIME;
Query OK, 0 rows affected (0.01 sec)

admin@127.0.0.1 [(none)] 11:27:03>>>SAVE MYSQL SERVERS TO DISK;
Query OK, 0 rows affected (0.13 sec)

admin@127.0.0.1 [(none)] 11:27:14>>>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           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.15 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
3 rows in set (0.00 sec)

admin@127.0.0.1 [(none)] 11:27:27>>> INSERT INTO mysql_users(username,password,default_hostgroup) VALUES ('orchestrator','123456',10);
Query OK, 1 row affected (0.00 sec)

admin@127.0.0.1 [(none)] 11:28:13>>>SELECT * FROM mysql_users;
+--------------+----------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+---------+
| username     | password | active | use_ssl | default_hostgroup | default_schema | schema_locked | transaction_persistent | fast_forward | backend | frontend | max_connections | comment |
+--------------+----------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+---------+
| orchestrator | 123456   | 1      | 0       | 10                | NULL           | 0             | 1                      | 0            | 1       | 1        | 10000           |         |
+--------------+----------+--------+---------+-------------------+----------------+---------------+------------------------+--------------+---------+----------+-----------------+---------+
1 row in set (0.00 sec)

admin@127.0.0.1 [(none)] 11:28:31>>>LOAD MYSQL USERS  TO RUNTIME;   
Query OK, 0 rows affected (0.00 sec)

admin@127.0.0.1 [(none)] 11:28:44>>>SAVE MYSQL USERS TO DISK; 
Query OK, 0 rows affected (0.04 sec)

admin@127.0.0.1 [(none)] 11:28:54>>>exit
Bye
[root@es2 ~]#  mysql -uorchestrator -p123456 -h292.168.56.15  -P6033 -e "SELECT @@server_id;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+-------------+
| @@server_id |
+-------------+
|           1 |
+-------------+
[root@es2 ~]# mysql -u admin -padmin -h 127.0.0.1 -P6032                                     
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3
Server version: 5.5.30 (ProxySQL Admin Module)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

admin@127.0.0.1 [(none)] 11:30:53>>> INSERT INTO mysql_query_rules(rule_id,active,match_digest,destination_hostgroup,apply) VALUES (1,1,'^SELECT.*FOR UPDATE$',10,1),(2,1,'^SELECT',20,1);
Query OK, 2 rows affected (0.00 sec)

admin@127.0.0.1 [(none)] 11:30:56>>>LOAD MYSQL QUERY RULES TO RUNTIME;
Query OK, 0 rows affected (0.00 sec)

admin@127.0.0.1 [(none)] 11:31:09>>>>SAVE MYSQL QUERY RULES TO DISK;
ERROR 1045 (28000): ProxySQL Admin Error: near ">": syntax error
admin@127.0.0.1 [(none)] 11:31:19>>>SAVE MYSQL QUERY RULES TO DISK; 
Query OK, 0 rows affected (0.03 sec)

admin@127.0.0.1 [(none)] 11:31:31>>>exit
Bye
[root@es2 ~]#  mysql -uorchestrator -p123456 -h292.168.56.15  -P6033 -e "SELECT @@server_id;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+-------------+
| @@server_id |
+-------------+
|           3 |
+-------------+
[root@es2 ~]#  mysql -uorchestrator -p123456 -h292.168.56.15  -P6033 -e "SELECT @@server_id;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+-------------+
| @@server_id |
+-------------+
|           3 |
+-------------+
[root@es2 ~]#  mysql -uorchestrator -p123456 -h292.168.56.15  -P6033 -e "SELECT @@server_id;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+-------------+
| @@server_id |
+-------------+
|           3 |
+-------------+
[root@es2 ~]#  mysql -uorchestrator -p123456 -h292.168.56.15  -P6033 -e "SELECT @@server_id;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+-------------+
| @@server_id |
+-------------+
|           2 |
+-------------+
[root@es2 ~]#  mysql -uorchestrator -p123456 -h292.168.56.15  -P6033 -e "SELECT @@server_id;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+-------------+
| @@server_id |
+-------------+
|           3 |
+-------------+
[root@es2 ~]#  mysql -uorchestrator -p123456 -h292.168.56.15  -P6033 -e  "BEGIN;SELECT @@server_id;commit;"   
mysql: [Warning] Using a password on the command line interface can be insecure.
+-------------+
| @@server_id |
+-------------+
|           1 |
+-------------+
[root@es2 ~]#  mysql -uorchestrator -p123456 -h292.168.56.15  -P6033 -e  "BEGIN;SELECT @@server_id;commit;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+-------------+
| @@server_id |
+-------------+
|           1 |
+-------------+
[root@es2 ~]#  mysql -uorchestrator -p123456 -h292.168.56.15  -P6033 -e  "BEGIN;SELECT @@server_id;commit;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+-------------+
| @@server_id |
+-------------+
|           1 |
+-------------+
[root@es2 ~]#  mysql -uorchestrator -p123456 -h292.168.56.15  -P6033 -e  "BEGIN;SELECT @@server_id;commit;"
mysql: [Warning] Using a password on the command line interface can be insecure.
+-------------+
| @@server_id |
+-------------+
|           1 |
+-------------+
[root@es2 ~]# mysql -u admin -padmin -h 127.0.0.1 -P6032                                                   
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 13
Server version: 5.5.30 (ProxySQL Admin Module)

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

admin@127.0.0.1 [(none)] 11:34:25>>>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           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.15 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
4 rows in set (0.00 sec)

admin@127.0.0.1 [(none)] 11:34:31>>>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           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.15 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
4 rows in set (0.00 sec)

admin@127.0.0.1 [(none)] 11:34:35>>>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           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.15 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
4 rows in set (0.00 sec)

admin@127.0.0.1 [(none)] 11:34:36>>>show tables;
+--------------------------------------------+
| tables                                     |
+--------------------------------------------+
| global_variables                           |
| mysql_aws_aurora_hostgroups                |
| mysql_collations                           |
| mysql_galera_hostgroups                    |
| mysql_group_replication_hostgroups         |
| mysql_query_rules                          |
| mysql_query_rules_fast_routing             |
| mysql_replication_hostgroups               |
| mysql_servers                              |
| mysql_users                                |
| proxysql_servers                           |
| runtime_checksums_values                   |
| runtime_global_variables                   |
| runtime_mysql_aws_aurora_hostgroups        |
| runtime_mysql_galera_hostgroups            |
| runtime_mysql_group_replication_hostgroups |
| runtime_mysql_query_rules                  |
| runtime_mysql_query_rules_fast_routing     |
| runtime_mysql_replication_hostgroups       |
| runtime_mysql_servers                      |
| runtime_mysql_users                        |
| runtime_proxysql_servers                   |
| runtime_scheduler                          |
| scheduler                                  |
+--------------------------------------------+
24 rows in set (0.00 sec)

admin@127.0.0.1 [(none)] 11:34:47>>>SELECT * FROM runtime_mysql_servers;
+--------------+---------------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname      | port | gtid_port | status  | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | 192.168.56.16 | 3306 | 0         | ONLINE  | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.14 | 3306 | 0         | SHUNNED | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.15 | 3306 | 0         | ONLINE  | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.16 | 3306 | 0         | ONLINE  | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
+--------------+---------------+------+-----------+---------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
4 rows in set (0.01 sec)

admin@127.0.0.1 [(none)] 11:35:09>>>SELECT * FROM runtime_mysql_servers;
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname      | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.15 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 10           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
5 rows in set (0.00 sec)

admin@127.0.0.1 [(none)] 11:36:50>>>SELECT * FROM runtime_mysql_servers;
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname      | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.15 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 10           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
5 rows in set (0.01 sec)

admin@127.0.0.1 [(none)] 11:36:55>>>SELECT * FROM runtime_mysql_servers;
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname      | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.15 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 10           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
5 rows in set (0.01 sec)

admin@127.0.0.1 [(none)] 11:36:56>>>SELECT * FROM runtime_mysql_servers;
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname      | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.15 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
4 rows in set (0.01 sec)

admin@127.0.0.1 [(none)] 11:37:17>>>SELECT * FROM runtime_mysql_servers;
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname      | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.15 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
4 rows in set (0.00 sec)

admin@127.0.0.1 [(none)] 11:37:18>>>SELECT * FROM runtime_mysql_servers;
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname      | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.15 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
4 rows in set (0.01 sec)

admin@127.0.0.1 [(none)] 11:37:20>>>SELECT * FROM runtime_mysql_servers;
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname      | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.15 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
4 rows in set (0.01 sec)

admin@127.0.0.1 [(none)] 11:37:21>>>SELECT * FROM runtime_mysql_servers;
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname      | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.15 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
4 rows in set (0.00 sec)

admin@127.0.0.1 [(none)] 11:38:22>>>SELECT * FROM runtime_mysql_servers;
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| hostgroup_id | hostname      | port | gtid_port | status | weight | compression | max_connections | max_replication_lag | use_ssl | max_latency_ms | comment |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
| 10           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.14 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.15 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
| 20           | 192.168.56.16 | 3306 | 0         | ONLINE | 1      | 0           | 1000            | 0                   | 0       | 0              |         |
+--------------+---------------+------+-----------+--------+--------+-------------+-----------------+---------------------+---------+----------------+---------+
4 rows in set (0.01 sec)


上一篇：Mysql数据库操作命令

下一篇：orchestrator+maxscale+mysql5.7GTID主从切换测试过程

相关内容

热门资讯

科学家预测：“哥斯拉级”厄尔尼... 科学家近日发出警告，太平洋上空正在形成一种被称为“哥斯拉”级的罕见厄尔尼诺气候模式。有科学家预测，这...
200亿美金估值的可灵，值母公... 文 | 影子备忘录 要说今年科技圈最火的赛道，AI短剧绝对排得上号。一部AI仿真人短剧，3人团队、...
多名中国公民在越南乘机遗失财物... 近日，多名中国公民反映在越乘机过程中财物遗失，中国驻胡志明市总领馆提醒中国公民注意：一、强化防范意识...
电视机尺寸一览表70寸长宽 电视机尺寸一览表70寸长宽：一般液晶电视显示屏都是16比9，70寸就是说客它对角线长70寸是106....
东莞一社区推出生育奖励方案，二... 极目新闻记者 柳之萌近日，广东东莞万江街道谷涌社区出台生育奖励方案，对符合条件的二孩家庭一次性奖励1...
80寸液晶电视尺寸长宽多少厘米 80寸液晶电视尺寸长宽多少厘米：80寸的液晶电视大概为181x111厘米，即长度大概在181厘米，宽...
石膏线一般用多久会掉 大家在装修客厅吊顶的时候，一般都会用石膏线来装。石膏线的施工非常方便，而且装修价格也比较便宜，所以很...
10公分石膏线下挂尺寸 10公分石膏线下挂，大概在8公分左右，这样排出来的石膏线才会比较好看，而且边缘也会比较整齐一些，如果...
地漏怎么防臭呢，有专门的防臭地... 地漏下方的排水管要装S型储水湾，也有专门的防臭地漏 非常芯地漏就是防臭地漏，非常芯地漏原理：重...
12名农民工遭遇“车位抵薪”：... 极目新闻记者 舒隆焕陕西西安12名农民工遭遇“车位抵薪”一事有了最新进展。5月12日，极目新闻记者从...