Database Scaling Patterns

11

(), , , .

, .

DevOps

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

, . , . ! .

, . , ? , . , .

, , . , ( , ..), .

: , .


. , . , .


50% Merion Academy