8/14/2019 sigaev cluster

1/13

:

,

8/14/2019 sigaev cluster

2/13

- 1.1

1 2

WR RD HA-JDBC,

8/14/2019 sigaev cluster

3/13

- 1.2

1 2

WR RD HA-JDBC

8/14/2019 sigaev cluster

4/13

- 2.1

1 2

WR RD

Sequoia, PgPool

(PgPool)

8/14/2019 sigaev cluster

5/13

- 2.2

1 2

WR RD

Sequoia

8/14/2019 sigaev cluster

6/13

- 3

Slave 1 Slave 2

Slony, PgCluster

Master

RDWR

RDONL:Y

8/14/2019 sigaev cluster

7/13

8/14/2019 sigaev cluster

8/13

Sharding horizontal partitioning

Shard 1

Shard 2

Sequoia, GridSQL, plProxy

8/14/2019 sigaev cluster

9/13

1 5

1 8 1 6 24 7 ,

.

8/14/2019 sigaev cluster

10/13

MetaDatalogin, id, school_id cluster

School DC 1 (~50)

School DC N

User DC 1

User DC N

Application server 1

Application server N

8/14/2019 sigaev cluster

11/13

8/14/2019 sigaev cluster

12/13

8/14/2019 sigaev cluster

13/13

, 5 -

-

-

Hot

scheme

update

-

-

1 2-

S1 1 1 2 5 5 2 1) 5 100% -

S2.1 2 1 1 5 4 2 1) 4 100% 100%

S2.2 2 4 3 4 3 4 3 2) 0% 100% 3)

S2.3 3 1 1 4 4 2 1) 4 100% 100%

S3 4 3 4 4 4 2 1) 4 33% 100%

S4.1 5 3 3 4 4 2 1) 4 50% 100%

S4.2 4 5 5 4 4 4 4 0% 50% 4)

1) 2)

3) 4) N/2-1