You cannot directly set hot replica nodes when you create a cluster. You can only enable the failover with hot replica feature for existing read-only nodes in your cluster.
Prerequisites
Your cluster is a PolarDB for MySQL Cluster Edition cluster. It meets one of the following cluster version requirements:
The PolarDB cluster runs MySQL 5.6 and the revision version is 5.6.1.0.35 or later.
The PolarDB cluster runs MySQL 5.7 and the revision version is 5.7.1.0.24 or later.
The PolarDB cluster runs MySQL 8.0.1 and the revision version is 8.0.1.1.29 or later.
The PolarDB cluster runs MySQL 8.0.2 and the revision version is 8.0.2.2.12 or later.
PolarDB for MySQL PolarProxy is 2.8.1 or later. For more information about how to view and update the PolarProxy version, see Upgrade the cluster version.
Precautions
If the failover with hot replica feature is not enabled for read-only nodes, your services may be interrupted for about 20 to 30 seconds when failover occurs. Therefore, make sure that your applications can be automatically reconnected to the cluster. If the hot replica feature is enabled for read-only nodes, failover can be completed within 3 to 10 seconds.
The specifications of hot replica nodes must be the same as those of the primary node.
The failover with hot replica feature cannot be enabled along with the in-memory column index feature. If a cluster contains a read-only column store node, you cannot enable the failover with hot replica feature on any read-only nodes in the cluster.
The transaction status preservation feature must be separately enabled. To enable this feature, you must set the
loose_innodb_trx_resume parameter
to ON on the Parameters page in the PolarDB console. For more information, see Specify cluster and node parameters.
Procedure
- Log on to the PolarDB console.
- In the upper-left corner of the console, select the region in which the cluster that you want to manage is deployed.
- Find the cluster and click the cluster ID.
In the Database Nodes section of the Basic Information page, click the
icon in the upper-right corner of the section to switch views.
In the Database Nodes section, find the read-only node for which you want to enable hot replica and click Enable Hot Replica in the Actions column.
NoteWhen the failover with hot replica feature is enabled for the first time, all nodes in the cluster are restarted one by one. When the failover with hot replica feature is enabled or disabled in the future, the nodes will not be restarted.