MySQL Cluster Replication With MySQL Cluster and non-NDB
環境介紹 因為筆電的空間和RAM有限，僅能在３台VM上來建置所有的場景 VM配置: (3台環境資源配置均相同就不分開寫了) hostname-> IP Address ol65-> 192.168.56.101 ol65-cluster1-> 192.168.56.103 ol65-cluster2-> 192.168.56.104 : OS: Oracle Linux 6.5 RAM: 4G mysql-5.6.19-ndb-7.3.6-cluster-commercial-advanced mysql-5.6.21-enterprise-commercial-advanced (這只有在192.168.56.101） 第一座MySQL cluster: mgm_node: 192.168.56.101:1186 data_node_1: 192.168.56.103:50501 data_node_2: 192.168.56.104:50502 sql_node_1: 192.168.56.103:3306 sql_node_2: 192.168.56.104:3306 第二座MySQL cluster: slave_mgm: 192.168.56.101:1188 slave_data_1: 192.168.56.103:50503 slave_data_2: 192.168.56.104:50504 slave_sql_1: 192.168.56.103:3306 slave_sql_2: 192.168.56.104:3306 MySQL Server slave: 192.168.56.101:3306 架構 MySQL Cluster Replication with MySQL Cluster MySQL Cluster Replication with non-NDB 前置設定 Table schema: 在Slave的mysql資料庫中新建此表，這個表是用來記錄已經從