http://172.16.59.20:8989/#/dashboard/services/Read-Write-Service
用户操作:https://www.cnblogs.com/rimmy/p/7679076.html
Replication 说明:https://www.cnblogs.com/zhoujinyi/p/5704567.html
GITD: https://www.cnblogs.com/kevingrace/p/5569753.html
➜ ~ mysql -h 172.16.59.20 -P 4006 -u jake -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.7.36-log MySQL Community Server (GPL)
Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| test01 |
+--------------------+
2 rows in set (0.01 sec)
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| MYSQL02 |
+------------+
1 row in set (0.01 sec)
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| MYSQL03 |
+------------+
1 row in set (0.00 sec)
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| MYSQL02 |
+------------+
1 row in set (0.00 sec)
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| MYSQL03 |
+------------+
1 row in set (0.00 sec)
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| MYSQL02 |
+------------+
1 row in set (0.00 sec)
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| MYSQL03 |
+------------+
1 row in set (0.00 sec)
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| MYSQL02 |
+------------+
1 row in set (0.00 sec)
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| MYSQL03 |
+------------+
1 row in set (0.00 sec)
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| MYSQL02 |
+------------+
1 row in set (0.00 sec)
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| MYSQL03 |
+------------+
1 row in set (0.01 sec)
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| MYSQL02 |
+------------+
1 row in set (0.00 sec)
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| MYSQL03 |
+------------+
1 row in set (0.00 sec)
mysql> select @@hostname;
+------------+
| @@hostname |
+------------+
| MYSQL02 |
+------------+
1 row in set (0.00 sec)
mysql> begin; select @@hostname; rollback;
Query OK, 0 rows affected (0.00 sec)
+------------+
| @@hostname |
+------------+
| MYSQL01 |
+------------+
1 row in set (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> begin; select @@hostname; rollback;
Query OK, 0 rows affected (0.00 sec)
+------------+
| @@hostname |
+------------+
| MYSQL01 |
+------------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> begin; select @@hostname; rollback;
Query OK, 0 rows affected (0.00 sec)
+------------+
| @@hostname |
+------------+
| MYSQL01 |
+------------+
1 row in set (0.01 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> begin; select @@hostname; rollback;
Query OK, 0 rows affected (0.00 sec)
+------------+
| @@hostname |
+------------+
| MYSQL01 |
+------------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> begin; select @@hostname; rollback;
Query OK, 0 rows affected (0.00 sec)
+------------+
| @@hostname |
+------------+
| MYSQL01 |
+------------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> begin; select @@hostname; rollback;
Query OK, 0 rows affected (0.01 sec)
+------------+
| @@hostname |
+------------+
| MYSQL01 |
+------------+
1 row in set (0.00 sec)
Query OK, 0 rows affected (0.00 sec)
mysql> begin; select @@hostname; rollback;
Query OK, 0 rows affected (0.00 sec)
+------------+
| @@hostname |
+------------+
| MYSQL01 |
+------------+
1 row in set (0.01 sec)
Query OK, 0 rows affected (0.00 sec)