Questions tagged [tidb]

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

TiDB (/’taɪdiːbi:/, "Ti" stands for Titanium) is an open-source distributed SQL database that supports Hybrid Transactional and Analytical Processing (HTAP) workloads. It's MySQL compatible and features horizontal scalability, strong consistency, and high availability.

TiDB provides users with a one-stop database solution that covers Online Transactional Processing (OLTP), Online Analytical Processing (OLAP), and HTAP services. It's suitable for various use cases that require high availability and strong consistency with large-scale data.

Key features

  • Horizontally scaling out or scaling in easily
  • Financial-grade high availability
  • Real-time HTAP
  • Cloud-native distributed database
  • Compatible with the MySQL 5.7 protocol and MySQL ecosystem

Deployment

Use cases

TiDB applies to the following use cases:

  • Financial industry scenarios with high requirements for data consistency, reliability, availability, scalability, and disaster tolerance
  • Massive data and high concurrency scenarios with high requirements for storage capacity, scalability, and concurrency
  • Real-time HTAP scenarios
  • Data aggregation and secondary processing scenarios

See also the case studies on the official website.

Learning resources

Check out TiDB courses

Related tags

  • - Distributed key-value database based on the design of Google Spanner and HBase. It is TiDB's storage engine.
  • - The metadata managing component of the entire TiDB cluster

Useful links

89 questions
-1
votes
2 answers

Does TiDB plan to support window functions?

TiDB is an hybrid transactional and analytical database. For analytical queries, I find that I often need window functions. I know that TiDB is MySQL-compatible, and that MySQL does not have window functions. But TiDB SQL can have extra features…
-1
votes
1 answer

Does TiDB recommend reading and writing separation? And why

Not found in https://pingcap.com/ about this, but our DBA suggested that I do this, reading and writing separation
Idroton
  • 11
-1
votes
1 answer

Error in TiDB: `java.sql.BatchUpdateExecption:statement count 5001 exceeds the transaction limitation`

When I was using Sqoop to write data into TiDB in batches, I ran into the following error: java.sql.BatchUpdateExecption:statement count 5001 exceeds the transaction limitation I configured the --batch option already, but this error still occurred.…
Lilian Lee
  • 190
  • 1
  • 12
-1
votes
1 answer

Couldn't connect to the PD Server using `127.0.0.1` in TiDB

I have deployed a TiDB cluster for testing. When I was using PD Control, I found that I could only connect to the PD server using the local IP address, but couldn't connect to it using 127.0.0.1. I'm wondering why.
Lilian Lee
  • 190
  • 1
  • 12
-1
votes
1 answer

How to modify `sql_mode` using the configuration file in TiDB?

I want to modify the sql_mode of TiDB. Is it the same as the configuration approaches in MySQL? Besides using the set command, how to configure it using the configuration file?
Lilian Lee
  • 190
  • 1
  • 12
-1
votes
3 answers

How to migrate from DB2 or Oracle to TiDB?

I want to try TiDB and I am working on data migration. Is there any way of migrating data from DB2 or Oracle to TiDB?
Lilian Lee
  • 190
  • 1
  • 12
-1
votes
1 answer

Why the modified `toml` configuration for TiKV/PD does not take effect?

During TiDB deployment, why the modified toml configuration for TiKV/PD does not take effect?
Caitin Chen
  • 151
  • 1
  • 10
-1
votes
1 answer

About the number of machines in rolling update of TiDB

I have a TiDB cluster of 4 machines and I want to add a PD server. But it seems that the number of machines does not meet the rolling update requirement. In TiDB documentation, at least 2 TiDB servers, 3 PD servers and 3 TiKV servers are needed in…
Caitin Chen
  • 151
  • 1
  • 10
-2
votes
1 answer

what dose lockkeys in tikv api use for?

Recently, I was looking at tikv's api document. There is a LockKey api in transaction. When I call it for operation, I directly panic. i have serval question? i want to know why it panic what does the lockKeys api use for? can any help me …
-2
votes
1 answer

Are there any ways to set specified default username and password in TiDB docker-compose file?

Based on TiDB official docker compose article, it sets default username/password to root/"" https://docs.pingcap.com/zh/tidb/v3.0/deploy-test-cluster-using-docker-compose Does anyone know how to set default username/password in the following…
-2
votes
1 answer

The performance test of MySQL and TiDB by our DBA shows that a standalone TiDB is not as good in performance as MySQL

Our DBA deployed a standalone TiDB and a standalone MySQL to respectively handle about one million tables but it seemed that TiDB could not perform as good as MySQL, why? If it's because the data size is too small, how much data should I put in the…
Coco
  • 29
  • 4
-3
votes
2 answers

How to implement Session Timeout in TiDB?

As far as I know, TiDB does not support session timeout on the database level. But can I use the session ID to implement session timeout in TiDB on the application level? What should I do?
Coco
  • 29
  • 4
-5
votes
1 answer

What happens if a TiDB leader goes down? How does TiDB use Raft to ensure data security and consistency?

If one leader node in TiDB is down, will my data get lost or the service be affected? How long will it be until the service recovers (i.e. a new leader is re-elected)?
Coco
  • 29
  • 4
-5
votes
2 answers

How to view the DDL jobs in TiDB?

When I was trying TiDB, I ran into the condition that it was slow to add indexes. I want to view the progress, but how to view the DDL jobs in TiDB?
Lilian Lee
  • 190
  • 1
  • 12
1 2 3 4 5
6