下載本手冊

MySQL Shell 8.4  /  MySQL InnoDB 叢集  /  MySQL InnoDB 叢集讀取複本

7.11 MySQL InnoDB 叢集讀取複本

MySQL Shell 讀取複本是叢集成員的唯讀副本。非同步複寫使複本保持最新,讓您能夠擴展工作負載、將讀取請求從叢集卸載至一或多個專用的唯讀執行個體,並為您的資料集提供額外的備援。在來源發生失敗時,讀取複本會自動連線至另一個叢集成員並繼續複寫。

圖 7.3 InnoDB 叢集讀取複本概觀

Three MySQL servers are grouped together as a high availability Cluster. One of the servers is the read/write primary instance, and the other two are read-only secondary instances. Group Replication is used to replicate data from the primary instance to the secondary instances. A group of Read Replicas replicates from the Cluster's primary by asynchronous replication. MySQL Router connects client applications (in this example, a MySQL Connector) to the primary instance with a read-write connection and to the Read Replicas with a read-only connection.

讀取複本可以設定為從叢集的任何成員進行複寫。依預設,它們會從主要成員進行複寫。您也可以將讀取複本升級為次要叢集成員,並將次要叢集成員降級為讀取複本。