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
0
votes
1 answer

How to determine the right TiDB and TiDB-Ansible version?

TiDB provides so many different versions and the documentation also mentions different versions for users to install. How to avoid choosing the wrong TiDB version and TiDB-Ansible version? What's the difference between various TiDB master versions?
Lilian Lee
  • 190
  • 1
  • 12
0
votes
1 answer

`ERROR 9001 (HY000): PD server timeoutstart timestamp may fall behind safepoint` in TiDB

When I was testing TiDB, I bumped into the 9001 error. I didn't figure out the cause. How to deal with it?
Lilian Lee
  • 190
  • 1
  • 12
0
votes
1 answer

How to check the health status of the whole TiDB cluster?

I've deployed the TiDB cluster for a test. I want to check whether the instances have all been started successfully, but I do not have a command line cluster management tool. In this case, how to check the health status of the TiDB cluster?
Lilian Lee
  • 190
  • 1
  • 12
0
votes
1 answer

Does frequently executing DDL affect the data synchronization speed in Syncer?

I am trying to import data incrementally into TiDB using the Syncer tool. I am wondering if I frequently execute DDL statements, will it affect the data synchronizing speed?
Lilian Lee
  • 190
  • 1
  • 12
0
votes
1 answer

Why the `etcd cluster ID mismatch` message is displayed when starting PD?

When I was starting PD (Placement Driver), the etcd cluster ID mismatch message displayed for some reason. How to handle this issue?
Lilian Lee
  • 190
  • 1
  • 12
0
votes
1 answer

Is the number of replicas in each Region configurable? If yes, how to configure it?

I have deployed the TiDB cluster on my machine. Is the number of replicas in each Region configurable? If yes, how to configure it?
Caitin Chen
  • 151
  • 1
  • 10
0
votes
1 answer

Can the codec of TiDB guarantee that the UTF-8 string is memcomparable?

Is there any coding suggestion if our key needs to support UTF-8?
Sharewin
  • 1
  • 5
0
votes
1 answer

How to delete the monitoring data of a cluster node that is offline?

I have deployed TiDB in our production environment. I want to know how to delete the monitoring data of a cluster node that is offline.
Caitin Chen
  • 151
  • 1
  • 10
0
votes
1 answer

Accidentally import the MySQL user table into TiDB, or forget the password

If I accidentally import the MySQL user table into TiDB, or forget the password and cannot log in, how to deal with it?
Lilian Lee
  • 190
  • 1
  • 12
0
votes
1 answer

Should I consider the short-term inconsistency when designing business models?

When a schema element is deleted, the schema change process is: public -> write only -> delete only -> reorganization -> absent. If the element to be deleted is table, this process only operates on the schema information of the table, and does not…
Lilian Lee
  • 190
  • 1
  • 12
0
votes
1 answer

Sql insert into Tidb int field with '' Got Error Data Truncated

I create a table in TiDB, with a int field, while inserting use value '' to this field, I got an error 'Data Truncated'. My code like this: CREATE TABLE test( i1 INT(11), s1 VARCHAR(16) ) INSERT INTO test(i1,s1) VALUES ('11','aa'); //ok INSERT…
chris
  • 80
  • 7
0
votes
1 answer

How to configure the slow query log in TiDB?

I have already set the slow_query_log to OFF, but why the tidb_slow_query.log still log the queries with execution time of several hundred milliseconds? slow query log
Lilian Lee
  • 190
  • 1
  • 12
0
votes
2 answers

Sum a float field with 2 digits in TiDB, got float with 8 digits

I transfered some data from infobright to TiDB. My php code like: $sql='delete from xxx where xxx'; doQuery($sql); $sql='insert into xxx (...)'; doQuery($sql); I inserted 48595 records, but sum of them is float with 8 digits. While, the field is…
chris
  • 80
  • 7
0
votes
1 answer

java.sql.BatchUpdateException: transaction too large, len:300200

got this error when writing into tidb use jdbc drive in spark2.2: java.sql.BatchUpdateException: transaction too large, len:300200 got the error under condition: select whole table not getting error under condition : select with limit 10000000;…
no123ff
  • 307
  • 5
  • 16
-1
votes
2 answers

How to convert SQL query to key-value command

Is it possible to use some opensource project to help parse the sql query and convert it into the custom key-value db command (CRUD on the key). I saw the architecture of the tidb, and it seems like they have an abstracted layer. I would appreciated…
harpy
  • 1
  • 1
1 2 3 4
5
6