title | summary | aliases | |||
---|---|---|---|---|---|
Upgrade TiDB Binlog |
Learn how to upgrade TiDB Binlog to the latest cluster version. |
|
This document introduces how to upgrade TiDB Binlog that is deployed with TiDB Ansible and deployed manually to the latest cluster version. There is also a section on how to upgrade TiDB Binlog from an earlier incompatible version (Kafka/Local version) to the latest version.
Follow the steps in this section if you deploy TiDB Binlog with TiDB Ansible Playbook.
First, upgrade the Pump component:
- Copy the new version of the binary
pump
file into the({ resources_dir })/bin
directory. - Execute the
ansible-playbook rolling_update.yml --tags=pump
command to perform a rolling update for Pump.
Second, upgrade the Drainer component:
- Copy the new version of the binary
drainer
file into the({ resources_dir })/bin
directory. - Execute the
ansible-playbook stop_drainer.yml --tags=drainer
command. - Execute the
ansible-playbook start_drainer.yml --tags=drainer
command.
Follow the steps in this section if you deploy TiDB Binlog manually.
First, upgrade each Pump instance in the cluster one by one. This ensures that there are always Pump instances in the cluster that can receive binlogs from TiDB. The steps are as below:
- Replace the original file with the new version of
pump
. - Restart the Pump process.
Second, upgrade the Drainer component:
- Replace the original file with the new version of
drainer
. - Restart the Drainer process.
The new TiDB versions (v2.0.8-binlog, v2.1.0-rc.5 or later) are not compatible with the Kafka version or Local version of TiDB Binlog. If TiDB is upgraded to one of the new versions, it is required to use the cluster version of TiDB Binlog. If the Kafka or local version of TiDB Binlog is used before upgrading, you need to upgrade your TiDB Binlog to the cluster version.
The corresponding relationship between TiDB Binlog versions and TiDB versions is shown in the following table:
TiDB Binlog version | TiDB version | Note |
---|---|---|
Local | TiDB 1.0 or earlier | |
Kafka | TiDB 1.0 ~ TiDB 2.1 RC5 | TiDB 1.0 supports both the local and Kafka versions of TiDB Binlog. |
Cluster | TiDB v2.0.8-binlog, TiDB 2.1 RC5 or later | TiDB v2.0.8-binlog is a special 2.0 version supporting the cluster version of TiDB Binlog. |
Note:
If importing the full data is acceptable, you can abandon the old version and deploy TiDB Binlog following TiDB Binlog Cluster Deployment.
If you want to resume replication from the original checkpoint, perform the following steps to upgrade TiDB Binlog:
-
Deploy the new version of Pump.
-
Stop the TiDB cluster service.
-
Upgrade TiDB and the configuration, and write the binlog data to the new Pump cluster.
-
Reconnect the TiDB cluster to the service.
-
Make sure that the old version of Drainer has replicated the data in the old version of Pump to the downstream completely;
Query the
status
interface of Drainer,command as below:{{< copyable "shell-regular" >}}
curl 'http://172.16.10.49:8249/status'
{"PumpPos":{"172.16.10.49:8250":{"offset":32686}},"Synced": true ,"DepositWindow":{"Upper":398907800202772481,"Lower":398907799455662081}}
If the return value of
Synced
is True, it means Drainer has replicated the data in the old version of Pump to the downstream completely. -
Start the new version of Drainer.
-
Close the Pump and Drainer of the old versions and the dependent Kafka and Zookeeper.