The Change Data Capture (CDC) log engine of PolarDB-X provides the binary logging feature. Use the Log Engine page in the PolarDB-X console to view instance details, upgrade instances, change instance configurations, release instances, and enable binary logging in multi-stream mode.
Prerequisites
Before you begin, ensure that you have:
-
A PolarDB-X 2.0 instance with the binary logging feature enabled
-
Access to the PolarDB-X console
Navigate to the Log Engine page
-
Log on to the PolarDB-X console.
-
In the top navigation bar, select the region where your instance is deployed.
-
On the Instance List page, click the PolarDB-X 2.0 tab.
-
Find the instance and click its instance ID.
-
In the left-side navigation pane, click Log Engine.
The Log Engine page has two sections:
-
Configuration Information: displays key information about the binary logging feature.
-
Instances: lists all instances for which the feature is enabled. Each instance can contain multiple nodes. You can enable the feature for all nodes in each instance in single-stream or multi-stream mode.
View instance details
The Configuration Information section shows the feature configuration. The Instances section lists all enabled instances. To check the CDC node version for an instance, look in the Version column in the node list below the instance name.
Upgrade an instance
An upgrade may interrupt the subscription to binary logs.
-
On the Log Engine page, find the instance you want to upgrade and click Upgrade.
-
In the dialog box that appears, select the target version. Select the latest version, which is displayed by default.
-
Click OK.
Change instance configurations
This operation may interrupt the subscription to binary logs.
-
On the Log Engine page, find the instance you want to modify and click Variable matching.
-
In the message that appears, click OK.
-
Wait for the specification change task to complete.
Release an instance
Instances that store a single stream of binary logs cannot be released.
-
On the Log Engine page, find the instance you want to release and click Release.
-
In the message that appears, click OK.
-
Wait for the release task to complete.
Enable binary logging in multi-stream mode
Multi-stream mode splits binary logs into multiple parallel streams for large-scale instances and high-concurrency workloads. For background information, see Binary logs.
Multi-stream mode requires whitelist access. Before you can click Enable Multi-stream, submit a ticket to request access. After your request is approved, your Alibaba Cloud account is added to the whitelist and the Enable Multi-stream button becomes available.
-
On the Log Engine page, click Enable Multi-stream.
-
In the dialog box that appears, configure the following parameters:
Parameter Description Description A description of the instance. Use this field to document the purpose of the instance for easier 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 The granularity at which binary logs are split into streams using a hash function. Options: Recording Level, Database Level, or Table Level. -
Click OK.
What's next
-
Binary logs — Learn about binary log concepts and multi-stream mode in detail.