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

TiDB load balancing not working via MYSQL connector c# .net core

I have setup TiDB for my .net core app. I'm connecting TiDB with the MYSQL connector in the .net core app. Below is my connection string server=server1,server2,server3;Port=4000;UID=test_user;PWD=****;database=Test_database;ConnectionReset=false; As…
suresh rajput
  • 169
  • 2
  • 9
0
votes
1 answer

What are the effects of rolling updates TiDB?

What are the effects of rolling updates TiDB? If it will impact production env? When do the TiKV leader's transfer to other TiKV, how much time it will take? I have tried to find from PingCAP documents, I can't find the result.
yi888long
  • 11
  • 1
0
votes
1 answer

Flink: binlog transformation to multiple DTO and transformation method in flink

A newer to Kafka, Flink and Tidb. Assume I have three source MySql tables s_a, s_b, and s_c, and want to collect records to target TiDb table t_a and t_b in a realtime. The mapping rules are `s_a` --> `t_a` `s_b` union `s_c` …
shijie xu
  • 1,975
  • 21
  • 52
0
votes
1 answer

Why does query become very slow with multiple indexes even I don't use it

I am using TiDB to do some testing. I created a table as below CREATE TABLE users( id BIGINT PRIMARY KEY NOT NULL, updated BIGINT NOT NULL ) I loaded around 100,000,000 rows into this table with 2 indexes CREATE INDEX hash_index USING HASH ON…
0
votes
1 answer

How to set tidb global system variables in filesystem

Can global system variables (eg: https://docs.pingcap.com/tidb/stable/system-variables) be set on the filesystem (eg: tidb.toml) before startup or can they only be set via a client? eg: set @@global.tidb_distsql_scan_concurrency = 10
0
votes
2 answers

How to modify tidb default GLOBAL variables like "tidb_replica_read" value in TiDB

Concept: https://pingcap.com/docs/dev/follower-read/ For detailing, i have also asked the question in here: https://github.com/pingcap/tidb/issues/17650 While getting value of tidb_replica_read config param, it shows "leader" by DEFAULT. Document of…
rachitmanit
  • 324
  • 3
  • 12
0
votes
2 answers

PySpark JDBC Write to MySQL (TiDB)

I am trying to write a pyspark dataframe (Millions of row) to TIDB, (Spark 2.3) df.write.format('jdbc').options( url='jdbc:mysql://:/', driver='com.mysql.jdbc.Driver', dbtable='', user='', …
Hardik Gupta
  • 4,700
  • 9
  • 41
  • 83
0
votes
1 answer

tidb-ansible error in ansible-playbook bootstrap.yml command

I am trying to install TiDB through TiDB ansible. I am referring to documentation in https://pingcap.com/docs/v1.0/op-guide/ansible-deployment/ and in the process I am facing the following error for command ansible-playbook bootstrap.yml . Though…
0
votes
1 answer

TiDB-ansible installation - ansible-playbook local_prepare.yml command failure

I am trying to install tidb on a single node using tidb ansible. I have set up the right IP address for PD, TiDB and TiKV server in inventory.ini file. I am following the instructions in https://pingcap.com/docs/v1.0/op-guide/ansible-deployment/.…
0
votes
1 answer

java.io.InvalidClassException: com.pingcap.tikv.region.TiRegion - Local class incompatible

I want to connect my Spark cluster to TIDB by TiSpark but I got a problem when I run my Spark application, an error occur: java.io.InvalidClassException: com.pingcap.tikv.region.TiRegion; local class incompatible: stream classdesc serialVersionUID…
0
votes
0 answers

Why declare the same variables in Golang?

I found this code in the pingcap/parser: var ( _ DDLNode = &AlterTableStmt{} _ DDLNode = &CreateDatabaseStmt{} _ DDLNode = &CreateIndexStmt{} _ DDLNode = &CreateTableStmt{} _ DDLNode = &CreateViewStmt{} _ DDLNode =…
anhnq
  • 296
  • 4
  • 15
0
votes
1 answer

Dropped rows in Spark when modifying database in MySQL

I've been following the 5 min how to for setting up an htap databse with tidb_tispark and everything works until I get to the section Launch TiSpark. My first issue occurs when executing the line: docker-compose exec tispark-master …
Bash
  • 628
  • 6
  • 19
0
votes
1 answer

what's the difference and affect of set[sync-log=false]for tidb

In tidb ,when open sync-log ,disk io util can be over 90%,after set sync-log=false,it goes down to 1%,what's the bad effect of this config?
0
votes
2 answers

What is "mult-raft" in TiKV?

I came across this intersting database the other day, and have read some doc on its offical site, I have some questions regarding Raft Group in TiKV (here), Suppose that we have a cluster which has like 100 nodes, and the replication factor is 3,…
gfytd
  • 1,747
  • 2
  • 24
  • 47
0
votes
1 answer

Can we run multiple TiDB instances connected to the same cluster to PD and (hence TiKV)?

I want to set up a local cluster of TiDB for the benchmark. Here are some my doubts: Can multiple TiDB instances connect to the same PD and TiKV cluster? (We only notice a single TiDB instance in this official production deployment doc.) If…
user1584887
  • 277
  • 1
  • 11