Excuse me, how does the distributed architecture database come from?

recently, I have been learning distributed architecture. I have basically figured it out. What about the database?
the mysql, I"ve been using take mysql as an example

for example, I now have two databases of server B. According to the load balancer, server may write to An or B
the question is mainly how the database is Synchronize. I know that mysql has a master-slave database Synchronize function, but what about that timeliness? For example, a client inserts a piece of data into database A, and then the client is disconnected and reconnected, and then he redoes the operation, just this time he inserts it into database B. at this time, Amai B and the two databases haven"t had time for Synchronize, isn"t there two pieces of duplicate data?

I would like to ask the experienced warrior to tell me how the usual situation in this area is going on. Or is the architecture I"m talking about wrong, usually using other methods rather than multiple databases to share the load?

Mysql database

Mar.12,2021

what you say is not master-slave in MySQL, but two-master (because to write An and B), master-slave means to write master forever, and then asynchronously Synchronize to slave.

dual masters are generally not used in practical projects (reliability and maintainability are not as good as master-slave), but master-slave is widely used, and master-slave is enough, because master-slave mode has well shared the read operation, and most applications are write less and read more. From my personal experience, it is not recommended to use MySQL multi-master.

formal distributed databases will not randomly select partitions to store data, but will store data in the corresponding database according to the hash algorithm. For example, there are four databases with 0-3, and the data will be stored in the corresponding database partition according to uid% 4 when storing the data. If something goes wrong, it will not change when retried.

Previous: The realization idea of exporting excel table with the separation of front and rear ends

Next: How to implement the CodeSplitting of react-router in react-loadable?

Why does it take so long for django to perform a simple database operation through queryset?
as shown in the figure, a simple add and query operation takes up to 1 second [environment: windows + python3 + django2]. (the amount of data in PS: is not much, and todo_list has only 2 rows of data, which is still so slow.) def get(request): -...

Python django mysql database backend

Feb.28,2021
Ask for help: mysql restarts automatically when it is running. What does it mean to take a look at this print?
2018-04-10T08:26:03.830775Z 0 [Note] usr sbin mysqld (mysqld 5.7.20) starting as process 9836 ... 2018-04-10T08:26:03.923709Z 0 [Note] InnoDB: PUNCH HOLE support available 2018-04-10T08:26:03.923741Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic b...

Mysql database

Mar.02,2021
MySQL writes queries and asks for help?
Table T_USER T_ROLE : the following is the table creation and data script drop table if exists T_USER; CREATE TABLE T_USER( USER_ID INT, USER_NAME VARCHAR(25) ); INSERT INTO T_USER VALUES(1, USER_A ); INSERT INTO T_USER VALUES(2, USER_B )...

Sql mysql database

Mar.02,2021
Questions about golang and database connections, clients and drivers?
for example, go connection mysql, https: github.com jmoiron sqlx is a client that implements official database sql, and an additional driver: https: github.com go-sql-dri. is required to use it. but this is not the case when I connect to mongodb. ...

Mongodb golang mysql database

Mar.07,2021
Schema understanding in MySQL
after reading this article (introducing schema in the database) https: www.biaodianfu.com da., it is mentioned that the schema in MySQL is the same as the library. Is this correct? Thank you ....

Db db-mysql database schema mysql

Mar.10,2021
What does the sub-database and sub-table partition of the database mean?
what do you mean by sub-database and sub-table partitioning of the database? ...

Sub-library-and-sub-table mysql database

Mar.10,2021
Take MySQL as an example, what is the difference (principle and efficiency) between in and exists and between not in and not exists? What about using indexes?
take MySQL as an example, what is the difference (principle and efficiency) between in and exists and between not in and not exists? What about using indexes? Say that not in and < > will not use indexes, won t you? ...

Mysql-Index mysql Database sql

Mar.12,2021
The database schema is decomposed into BCNF? that maintains lossless decomposition
1. How to decompose (A, B)-> E, (C, D)-> E, A-> C, C-> An into BCNF,? 2, U = (Agraine Brecinct C pyrrhene E) F = {B-> Greco ce-> Breco C-> Areco B-> Dle le C-> D}. Decompose into BCNF? 3. The BCNF decomposition that I understand at present is to fin...

Php oracle mysql database-design database

Mar.13,2021
How to get the accumulated data that satisfies a certain value from the database
for example: < table > < thead > < tr > < th > id < th > < th > num < th > < tr > < thead > < tbody > < tr > < td > 1 < td > < td > 1 < td > < tr > < tr > < td > 2 < td > < td > 20 < td > < tr > < tr > < td > 3 < td > < td > 30 < ...

Postgresql mysql database

Mar.20,2021
How to store the "time period" in the database is more reasonable?
in development, there are some scenarios where we need to store information for a time period in the database. For example, an event has a start time and an end time, and we can store it in the database with two fields such as startDate and endDate. But...

Mysql database-design database

Mar.21,2021
Oracle stored procedure, after adding a variable, why did you report this error?
CREATE OR REPLACE PROCEDURE QD_MYDTJ (BEGINDATE VARCHAR2, ENDDATE VARCHAR2, xz_name VARCHAR2, xz_number VARCHAR2, --BEGININTEVAL VARCHAR2, --ENDINTEVAL VARCHAR2, start1 IN NUMBER, limit1 IN NUMBER, AN_O_RET_CODE ...

Php java mysql database oracle

Mar.22,2021
Is there a book to improve abstraction in designing database tables according to requirements?
is there a book to improve abstraction in designing database tables according to requirements? ...

Mysql database database-design

Mar.29,2021
How to express the success of the query?
Please see here expression of successful query if ($conn->query($sql) === TRUE) { echo ""; } else { echo "Error: " . $sql . "<br>" . $conn->error; } Please see my code: <form action=""...

Mysql database php

Apr.09,2021
What tools or ways do mysql and sql server have to check the number of times sql executes?
or answer my question directly: when a sql of select has a primary key and an index, what is the order of its execution? is there a big god to find it first from the primary key or from the index? ...

Index primary-key sqlserver mysql database

May.22,2021
Ask a question about the inventory of Synchronize in a mall.
topic description at present, there is a product that the user places an order to reduce inventory, the order is cancelled to increase inventory, and the backend modifies the inventory quantity. There are three different ways to do this. How about S...

Mysql database java

Jun.26,2021
Why should the time be required to be a time period when the database queries the time date field?
question: select * from table where created_at > where is the problem? How to solve? answer: time writes dead, closes, time opens, there must be closing time. The question is, why should it be a closed interval when querying this time field? It ...

Oracle mysql database database-performance-optimization mysql-optimization

Nov.09,2021
MySQL has .idb files but no .frm files.
there is data in every table, but it is 112KB and there is no .frm file. What is this all about? ...

Mysql database

Jan.08,2022
How to deal with fields with uniqueness constraints in the case of sub-tables?
how to deal with fields with unique indexes in the case of sub-tables? there is no guarantee of constraints when adding new ones ...

Mysql database java

May.16,2022

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1ea5dce-1d8c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1ea5dce-1d8c.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?