Stack Overflow
Stack Overflow

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
7
votes
0 answers

How to get better performance for local SSD disk on GKE?

I'm running a sysbench OLTP benchmark with TiDB on GKE local SSD disk. But I'm getting poor performance compared to GKE persistent SSD disk. How can I get the expected IOPS performance on GKE local SSD disk by default? I've run TiDB OLTP benchmark…
tennix
  • 331
  • 2
  • 5
4
votes
1 answer

How can I delete the data in TiKV directly?

I used tikvTxn to write the key-value data into TiKV directly and skip the TiDB. db, err := driver.Open("tikv://127.0.0.1:2379?disableGC=true") txn, _:= db.Begin() txn.set(key, value) txn.commit(context.Background()) ... I can't clean the data in…
Lyn
  • 51
  • 5
3
votes
3 answers

How do joins work in the Cloud Spanner database?

How do joins work in Google's Cloud Spanner database? Will the join query execute fast? Is there any comparison between SQL(MySql, Oracle, MSSQL) vs NewSQL(Cloud Spanner/TiDB/CockroachDB)?
Kumar Siva
  • 349
  • 2
  • 5
  • 16
2
votes
1 answer

Why the TiDB performance drop for 10 times when the updated field value is random?

I set up the TiDB, TiKV and PD cluster in order to benchmark them with YCSB tool, connected by the MySQL driver. The cluster consists of 5 instances for each of TiDB, TiKV and PD. Each node run a single TiDB, TiKV and PD instance. However, when I…
user1584887
  • 277
  • 1
  • 11
2
votes
1 answer

Why the error message "transaction too large" appears when I commit a transaction in TiDB?

When I commit a transaction that contains 100,000 rows in TiDB, the error message "transaction too large" appears. What is the limit for the transaction size in TiDB? Can I modify the limit using a certain parameter?
Lilian Lee
  • 190
  • 1
  • 12
2
votes
1 answer

How do I connect existing TiKV nodes to a new cluster of PDs in TiDB?

I had a working TiDB instance running in gcloud, deployed using the tidb-ansible scripts. I wanted to replace the PD nodes with new ones, so I destroyed and replaced those. The PD cluster comes up ok now, but when I try to start the TiKV nodes, I…
dleng
  • 71
  • 9
2
votes
2 answers

Scalable RDBMS alternative, NoSQL, NewSQL

I am looking for scalable alternative to traditional DBMS like PostgreSQL or MySQL. In traditional databases I don't have the following features: Auto sharding to ensure linear scalability. Replication with automatic failover and recovery to ensure…
Georgy Savva
  • 659
  • 7
  • 14
1
vote
3 answers

What is the proper way to find the connection ID by the requested query statement in TiDB?

Im creating an alter automation script that executes an alter on the TiDB cluster. In case of an error, I need to kill the running alter using the KILL statement - https://docs.pingcap.com/tidb/stable/sql-statement-kill. KILL requires a connection…
Andy Marrel
  • 103
  • 1
  • 6
1
vote
1 answer

What are the semantics of not using "FTWL to guarantee that the dump file is consistent with metadata"?

When migrating data from AWS RDS MySQL to TiDB using DM we got the following error: Couldn't acquire global lock, snapshots will not be consistent: Access denied for user 'root'@'%' (using password: YES) The TiDB documentation suggested the…
merlin2011
  • 71,677
  • 44
  • 195
  • 329
1
vote
1 answer

How can I set memory capacity of each TIKV?

How can I set the capacity of a TIKV instance? Lets say I have 2 TIKV instances and I want them to consume 200GB of storage (each 100GB).
Elnur
  • 119
  • 1
  • 5
1
vote
1 answer

how to optimize count(*)queries on tidb

I have a table with about 3000000 rows described as below. Field |Type |Null|Key|Default|Extra | ------------------|------------|----|---|-------|--------------| id |bigint(20) |NO |PRI| …
rshetye
  • 667
  • 1
  • 8
  • 21
1
vote
1 answer

Is PD component has any authentication method to limit databases that Spark can access?

Is PD have any authentication method to limit databases Spark can access? because if someone know my PD address, they can use TiSark to connect to TiDB and query on my databases. I have setup a TiDB cluster, then I add a new user, I connect to TiDB…
Thorn Honor
  • 11
  • 2
1
vote
1 answer

Same transaction returns different results when i ran multiply times

When i was using TiDB, I found it strange when i make two transactions run at the same time. I was expecting to get the the same value 2 like what MySQL did, but all i got is like 0, 2, 0, 2, 0, 2... For both databases, the tx_isolation is set to…
xrwqf le
  • 11
  • 3
1
vote
2 answers

ERROR 1105 (HY000): Unknown charset id 255

I have deployed TiDB in the production environment. Yesterday I found that some machines failed to connect to the database and it occurred that ERROR 1105 (HY000): Unknown charset id 255. There was no problem with the privilege. What caused this…
Caitin Chen
  • 151
  • 1
  • 10
0
votes
0 answers

[BR:Stream:ErrStreamLogTaskExist]stream task already exists

I deployed TiDB in public cloud kubernetes cluster. Everything is okay and running as expected. But when I try to do backup to S3 using BR with log method. docs. After that, I want to terminate the backup, but I forget to step by step turn off the…
Derhoer IT
  • 11
  • 1
1
2 3 4 5 6