(), , , .
, .

, , . , 10 .
, , , , , . , . : , , , 5 .
. , . . 10 . 20, 30 .
, : API , , , . , . ?
1
, : ( , , ..). API, ( , , ..).
, , ( WHERE
JOIN ON
). , .
. . . .
, . . .
API 20-50% ( ). .
. 80-100 . . API, . . , , 80% , .
2
, , . 2 , 3. . , devops () .
?
. , , , (replica), , (primary), (primary replica). primary . , / .
. , .
, 3 . 5 . , 300 . : , , . , . ?
3 (CQRS):
, /. (write), (read). read. , . , . /.
2 . primary . ( Q CQRS, - Query) . . , .
primary-replica , , .
2 , , primary- . . , primary replica . , , , , , primary, , . , 30, , . ?
4
primary-replica , . , . ?
(multi-primary) , . - : A->B->C->D->A
. B A, C », D C, A D. ; , . , , .. , id , id.
, ID UUID GUID. : - , . , , / .
. 5 . . 50 . . ?
5
, location /. , 7:3. . location : (longitude), (latitude), (timestamp), ID (driver id), ID (trip id) ..
, .. , location ? , primary-replica multi-primary?
. , , ( ) . /. , .
, 20 . . . , / . ?
6
, , , , . , , 50 . .
, , ( ). ; . . . , . ; / .
. , . , .
, , . , . . API. , . ? ?
7
, . , . ! .
, . , ? , . , .
, , . , ( , ..), .
: , .
. , . , .