orchestrator+proxysql+mysql5.7GTID主从切换测试过程
发表于：2026-11-01 作者：千家信息网编辑
千家信息网最后更新 2026年11月01日，[root@es2 ~]# cat <>>"[root@es2 ~]# mysql -u admin -padmin -h 127.0.0.1 -P6032 mysql: [Warning] Usin
千家信息网最后更新 2026年11月01日orchestrator+proxysql+mysql5.7GTID主从切换测试过程
[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>>>exitBye[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 3Server 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 itsaffiliates. Other names may be trademarks of their respectiveowners.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 erroradmin@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>>>exitBye[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 13Server 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 itsaffiliates. Other names may be trademarks of their respectiveowners.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)
主从
过程
切换
测试
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
华服互联网科技靠谱吗
腾讯阿里互联网科技
中资互联网科技
互联网 的科技创新
紫鲸互联网科技
深圳天众互联网科技公司
苏州大垚互联网科技
玖二柒互联网科技公司待遇
深圳前海聚择互联网科技有限公司
阿里巴巴算科技企业还是互联网
互联网科技实习生岗位职责
湖南诚度互联网科技有限公司
江阴互联网智能科技产品进口
如何创新互联网科技
晋城互联网科技
云南省自由互联网科技有限公司
上海乐五互联网科技有限公司
保山互联网科技靠谱吗
科技互联网经济论坛
小牛互联网科技有限公司地址
重庆互联网络科技
广州宏创互联网科技
联恩商钥互联网科技有限公司
昊天互联网科技有限公司
互联网5g黑科技有哪些
未来五年的互联网科技
亳州好赞互联网科技有限公司
保山互联网科技靠谱吗
现代科技的标志之一的互联网
颐高云石互联网科技
