TiDB

About

TiDB is an open-source distributed SQL database that supports Hybrid Transactional and Analytical Processing (HTAP) workloads. It is MySQL-compatible and features horizontal scalability, strong consistency, and high availability.

Requirements

Database User

This source uses standard MySQL protocol authentication. You will need to create a TiDB user to login to the database with.

For TiDB Cloud users, you can create database users through the TiDB Cloud console.

SSL Configuration

• TiDB Cloud

  For TiDB Cloud instances, SSL is automatically enabled when the hostname matches the TiDB Cloud pattern (gateway*.*.*.tidbcloud.com). You don’t need to explicitly set ssl: true for TiDB Cloud connections.

• Self-Hosted TiDB

  For self-hosted TiDB instances, you can optionally enable SSL by setting ssl: true in your configuration.

Example

• TiDB Cloud

  sources:
      my-tidb-cloud-source:
          kind: tidb
          host: gateway01.us-west-2.prod.aws.tidbcloud.com
          port: 4000
          database: my_db
          user: ${TIDB_USERNAME}
          password: ${TIDB_PASSWORD}
          # SSL is automatically enabled for TiDB Cloud
  

• Self-Hosted TiDB

  sources:
      my-tidb-source:
          kind: tidb
          host: 127.0.0.1
          port: 4000
          database: my_db
          user: ${TIDB_USERNAME}
          password: ${TIDB_PASSWORD}
          # ssl: true  # Optional: enable SSL for secure connections
  

Reference