Stack Overflow
Stack Overflow

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

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

Is fast data access related to the availability (A) in CAP theorem?

I realize that it will be a basic concept, but it would be helpful if anyone could explain if fast data access related to the availability (A) in CAP theorem. Fast data access is an important feature expected of Big Data systems. And does the…
Nimy Alex
  • 155
  • 1
  • 3
  • 13
0
votes
2 answers

Distributed Database Design Architecture Use Case for Users & Authentication

I am now trying to design database for my micro service-oriented application in a distributed way. My application is related with management of universities. I have different universities say A, B, C. Each university have separate users for using…
Mr.DevEng
  • 2,651
  • 14
  • 57
  • 115
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
3 answers

Distributed database design style for microservice-oriented architecture

I am trying to convert one monolithic application into micro service oriented architecture style. Back end I am using spring , spring boot frameworks for development. Front-end I am using angular 2. And also using PostgreSQL as database. Here my…
Mr.DevEng
  • 2,651
  • 14
  • 57
  • 115
0
votes
2 answers

Distributed database solutions

I am doing some research into distributed databases. I have concluded that the hardest part is distributed queries, over multiple records, where the query is quite generic e.g. imagine a transaction table with a "DateTransaction" field. This query…
Someone
  • 11
  • 2
0
votes
0 answers

Distributed Transaction vs Message Queue

I am trying to implement distributed transactions in my current application which are working fine currently with MSDTC, the only problem is that MSDTC is only supported in windows. The alternative suggested at many places was to ditch the DTC and…
Vimalshah26
  • 23
  • 6
0
votes
3 answers

What would you recommend to read to a person who is going to write his own DB?

Since there are no answers to my previous question. I'm really thinking to implement a custom DB which will satisfy my requirements. Yes I know, sounds crazy. But what books, articles and etc. would you recommend to read? If it does matter the…
Insomniac
  • 3,354
  • 2
  • 23
  • 24
0
votes
0 answers

how would it be a entity relationship model example being distributed databases

I have tried looking for a entity relationship model using the schema of distributed database but I found diagrams as it: or I found entity relationship models but they are not using the schema of distributed database like this... I did next…
angel
  • 4,474
  • 12
  • 57
  • 89
0
votes
2 answers

Foreign key between two databases

I went through the previous answers to create a pseudo-foreign key to reference tables between two databases in Netbeans 8.1. This is the code I came up with, DELIMITER // CREATE OR REPLACE TRIGGER conf_track_FK AFTER INSERT OR UPDATE on…
Suraj Sachin
  • 1
0
votes
1 answer

Dynamically partitioning a table from main to remote mySQL server

I have a table in my DB which I need to partitionate based on a foreign key attribute. So the number of partitioned tables is the same as the number of different values present for the foreign key. EDIT: I have replication setp up, where a table in…
JuanV
  • 13
  • 4
0
votes
1 answer

mysql distributed primary key

I have different tables that need to share a pool of primary keys. E.g. table A has primary keys 0 to 9, table B has primary keys 10 to 19. Is there a way to tell mysql where to draw the primary key from? Like a stored procedure? It would be…
user3169506
  • 93
  • 2
  • 4
1 2 3
…
12 13