orchestrator+proxysql+mysql5.7GTID主从切换测试过程
发表于：2025-11-23 作者：千家信息网编辑
千家信息网最后更新 2025年11月23日，[root@es2 ~]# cat <>>"[root@es2 ~]# mysql -u admin -padmin -h 127.0.0.1 -P6032 mysql: [Warning] Usin
千家信息网最后更新 2025年11月23日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安全错误
数据库的锁怎样保障安全
蚌埠政府软件开发公司
iis管理器怎么进入服务器
北京通信软件开发设施标准
杭州雷龙网络技术
阿里巴巴一共多少台服务器
魔兽世界轮回服哪个服务器好点
网络安全绘画竖构图
上海本地网络技术定做价格
山西太原触摸互动软件开发公司
论网络安全的重要性作文
手机怎么设置远程服务器
和软件开发相关的工作
安全生产和网络安全宣传周
微信号服务器繁忙
长链非编码rna疾病数据库
无锡工业网络技术电话
云南软件开发咨询
珠海商城软件开发定制
计算机网络技术参加一建
上海通讯网络技术产品
中国软件开发人员多少
专项走访网络安全
河南最好的网络安全专业
新洋丰土壤数据库
浙江软件开发过程标准
软件开发定制app程序员招聘
海翔数据库
怀化软件开发培训
传奇sf服务器怎么样
小学网络安全活动方案
