Questions tagged [distributed-database]

Anything related to distributed databases and the techniques and the tools used to manage them. A distributed database is a database whose information is not stored in a single physical location, but it is spread over various devices, often placed far apart.

Anything related to distributed databases and the techniques and the tools used to manage them. A distributed database is a database whose information is not stored in a single physical location, but it is spread over various devices, often placed far apart.

188 questions
-1
votes
1 answer

Compile error at omCommand.cpp:3765 in SequoiaDB

Describe the bug: Compile error at SequoiaDB/engine/omsvc/omCommand.cpp:3765 To Reproduce Steps to reproduce the behavior: git clone https://github.com/SequoiaDB/SequoiaDB.git scons --engine see error…
-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

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

Discuss the main issues governing concurrency control in a large distributed database environment

I'm revising for uni using mock questions and I'm wondering where I could find materials or information to answer this question or if someone could walk me through it? Thanks
teezee
  • 1
-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
1 2 3
12
13