Does TiDB generate Binlog like MySQL?

TiDB TiCDC & Binlog
1

Note that this question was originally posted on the Chinese TiDB Forum. We copied it here to help new users solve their problems quickly.

Application environment:

Test environment

TiDB version:

TiDB v6.0.0

Problem:

Does TiDB generate Binlog like MySQL? I searched TiDB’s file directory but failed to find it.

[root@localhost tidb-data]# ls
alertmanager-9093 monitor-9100 pd-2379 prometheus-9090 tiflash-9000 tikv-20160
2

You need to deploy the TiDB Binlog component separately. Reference docs: TiDB Binlog Cluster Deployment | PingCAP Docs

3

I have deployed the cluster using the following command:

tiup cluster deploy mytidb_cluster v6.0.0 ./topology.yaml

But the file topology.yaml did not have the items pump_servers: and drainer_servers: in it. Can I add these two items to the topology.yaml and re-execute the above command to deploy and enable Binlog?

4

topology.yaml is only used during the initial deployment. Now you can add new components by scaling the TiDB cluster. Reference docs: Scale a TiDB Cluster Using TiUP | PingCAP Docs