PolarDB:Manage the binary logging feature in the PolarDB-X console

Procedure

1. Log on to the PolarDB-X console.

2. In the top navigation bar, select the region where the instance is deployed.

3. On the Instance List page, click the PolarDB-X 2.0 tab.

4. Find the instance and click the instance ID.

5. In the left-side navigation pane, click Log Engine.

   On the page that appears, you can perform the following operations:

   • View the details of an instance with the feature enabled

     The Configuration Information section displays some key information about the logging feature, and the Instances section displays all instances for which the logging feature is enabled. Each instance can contain multiple nodes. You can enable the feature for all nodes in each instance in the single- or multi-stream mode.

   • Upgrade an instance

     Find the instance that you want to upgrade and click Upgrade. In the dialog box that appears, select the version to which you want to update and click OK.

     Important

     • In the list below the instance name, you can view the version of a Change Data Capture (CDC) node in the Version column. An upgrade may interrupt the subscription to binary logs.

     • When you select a destination version, we recommend that you select the latest version, which is also the version displayed by default.

   • Release an instance

     Find the instance that you want to release and click Release. In the message that appears, click OK. Wait for the release task to complete.

     Important

     Instances that store a single stream of binary logs cannot be released.

   • Change instance configurations

     Find the instance that you want to modify and click Variable matching. In the message that appears, click OK. Wait for the specification change task to complete.

     Important

     This operation may interrupt the subscription to binary logs.

   • Enable binary logging in multi-stream mode

     PolarDB-X allows you to enable binary logging in multi-stream mode in scenarios of large-scale instances and high concurrency. You can enable this feature in the PolarDB-X console. For more information, see Binary logs.

     Important

     Before you can enable this feature, submit a ticket. If your request is approved, your Alibaba Cloud account is added to the corresponding whitelist. Then, you can enable this feature in the PolarDB-X console.

     Click Enable Multi-stream. In the dialog box that appears, configure the parameters and click OK. The following table describes the parameters that you can configure.

     Parameter	Example
     Description	The description of the instance. This clarifies the usage of the instance and facilitates subsequent management.
     Stream Group Name	The name of the group to which the multiple log streams belong.
     Splitting Quantity	The number of log streams to split into. Valid values: 2 to twice the number of data nodes. We recommend that you set this parameter to the number of data nodes.
     Splitting Level	You can select Recording Level, Database Level, or Table Level to split binary logs into multiple streams based on a hash function.