orchestrator+proxysql+mysql5.7GTID主从切换测试过程
发表于：2025-01-22 作者：千家信息网编辑
千家信息网最后更新 2025年01月22日，[root@es2 ~]# cat <>>"[root@es2 ~]# mysql -u admin -padmin -h 127.0.0.1 -P6032 mysql: [Warning] Usin
千家信息网最后更新 2025年01月22日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安全错误
数据库的锁怎样保障安全
网络安全防控广播稿
尖峰实验室 网络安全
维护网络安全会
cookies数据库登录
telnet 服务器下载
软件开发比赛作品
斯塔克网络技术
下沉式数据库
网络安全与管理书籍
一期网络安全小贴士
游戏软件开发的产品
特斯拉软件开发流程
计算机网络技术企业的用人标准
服务器 三层
摆渡互联网科技有限公司
温州大学计算机网络技术期末
什么是数据库结构
博兴陶瓷管理软件开发公司
低网络安全
惠普服务器 初始密码
网络安全认识是错误的
如何保障国家网络安全
数据库批量挂接
游戏软件开发SWOT分析
马钢软件开发工资
为什么需要数据库的技术
香港白鲨云服务器
神经网络技术路线
共享自动浴室软件开发
广东奥维信息科技工业互联网
