MySQL的高可用架構無論是社區還是官方，一直在技術上進行探索，這么多年提出了多種解決方案，比如MMM, MHA, NDB Cluster, Galera Cluster, InnoDB Cluster, 騰訊的PhxSQL, MySQL Fabric. 本文主要介紹MySQL的高可用架構InnoDB Cluster。 MySQL InnoDB Cluster解決方案其實是由MySQL的幾個不同產品和技術組成的，比如MySQL Shell, MySQL Router, Group Replication.

安裝mysql, mysql shell, mysql router
略

部署多個實例?

mysqlsh
mysql-js> dba.deployLocalInstance(3310)
mysql-js> dba.deployLocalInstance(3320)
mysql-js> dba.deployLocalInstance(3330)

3310作為master, 3320和3330作為slave

創建集群
mysql-js> \c root@localhost:3310
mysql-js> cluster = dba.createCluster('mycluster')
向集群添加實例?
mysql-js> cluster.addInstance("root@localhost:3320")
mysql-js> cluster.addInstance("root@localhost:3330")
查看集群狀態
mysql-js> cluster.status()
{
? ? "clusterName": "mycluster",
? ? "defaultReplicaSet": {
? ? ? ? "status": "Cluster tolerant to up to ONE failure.",
? ? ? ? "topology": {
? ? ? ? ? ? "localhost:3310": {
? ? ? ? ? ? ? ? "address": "localhost:3310",
? ? ? ? ? ? ? ? "status": "ONLINE",
? ? ? ? ? ? ? ? "role": "HA",
? ? ? ? ? ? ? ? "mode": "R/W",
? ? ? ? ? ? ? ? "leaves": {
? ? ? ? ? ? ? ? ? ? "localhost:3330": {
? ? ? ? ? ? ? ? ? ? ? ? "address": "localhost:3330",
? ? ? ? ? ? ? ? ? ? ? ? "status": "ONLINE",
? ? ? ? ? ? ? ? ? ? ? ? "role": "HA",
? ? ? ? ? ? ? ? ? ? ? ? "mode": "R/O",
? ? ? ? ? ? ? ? ? ? ? ? "leaves": {}
? ? ? ? ? ? ? ? ? ? },
? ? ? ? ? ? ? ? ? ? "localhost:3320": {
? ? ? ? ? ? ? ? ? ? ? ? "address": "localhost:3320",
? ? ? ? ? ? ? ? ? ? ? ? "status": "ONLINE",
? ? ? ? ? ? ? ? ? ? ? ? "role": "HA",
? ? ? ? ? ? ? ? ? ? ? ? "mode": "R/O",
? ? ? ? ? ? ? ? ? ? ? ? "leaves": {}
? ? ? ? ? ? ? ? ? ? }
? ? ? ? ? ? ? ? }
? ? ? ? ? ? }
? ? ? ? }
? ? }
}

部署MySQL Router
mysqlrouter --bootstrap localhost:3310
返回信息
...
Please enter the administrative MASTER key for the MySQL InnoDB cluster:
MySQL Router has now been configured for the InnoDB cluster 'mycluster'.


The following connection information can be used to connect to the cluster.


Classic MySQL protocol connections to cluster 'mycluster':
- Read/Write Connections: localhost:6446
- Read/Only Connections: localhost:6447

啟動Mysql Router

mysqlrouter&

客戶端連接Router
mysqlsh --uri root@localhost:6446
mysql-js> \sql
Switching to SQL mode... Commands end with ;


mysql-sql> select @@port;
+--------+
| @@port |
+--------+
| ? 3310 |
+--------+
1 row in set (0.00 sec)


故障模擬
mysql-js> dba.killLocalInstance(3310)
切換到sql模式，執行sql語句Select @@port
mysql-js> \sql
Switching to SQL mode... Commands end with ;


mysql-sql> SELECT @@port;
ERROR: 2013 (HY000): Lost connection to MySQL server during query
The global session got disconnected.
Attempting to reconnect to 'root@localhost:6446'...
The global session was successfully reconnected.


mysql-sql> SELECT @@port;
+--------+
| @@port |
+--------+
| ? 3330 |
+--------+
1 row in set (0.00 sec)
可以看到，故障被檢查到了，并自動重連，轉到了 3330 實例


參考資料
https://dev.mysql.com/doc/refman/5.7/en/mysql-innodb-cluster-userguide.html
http://mysqlserverteam.com/mysql-innodb-cluster-setting-up-a-real-world-cluster/

總結

以上是生活随笔為你收集整理的MySQL高可用架构InnoDB Cluster (和NDB Cluster是两码事)的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。