mysql集群副本数_MySQL Cluster(MySQL集群)配置

计算机数量(用于数据节点)

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

每计算机CPU数量

1

2

4

8

16

32

每计算机内存大小

1

2

4

8

16

32

64

128

256

512

1024

GB

副本数量

1

2

3

4

MySQL Cluster数据节点相关配置参数说明

MySQL Cluster英文参考文档

数据+索引最大尺寸: ~128GB, 其中 76.8GB (60%) 用于数据 , 38.4GB (30%) 用于索引

物理位置

物理位置 #1

1db1

db5

db9

db13

db17

db21

db25

db29

物理位置 #2

2db2

db6

db10

db14

db18

db22

db26

db30

物理位置 #3

3db3

db7

db11

db15

db19

db23

db27

db31

物理位置 #4

4db4

db8

db12

db16

db20

db24

db28

db32

节点配置: 8个节点组

Node

Group 1

Node

Group 2

Node

Group 3

Node

Group 4

Node

Group 5

Node

Group 6

Node

Group 7

Node

Group 8

db1

1

9

17

25db2

1

9

17

25db3

1

9

17

25db4

1

9

17

25

db5

2

10

18

26db6

2

10

18

26db7

2

10

18

26db8

2

10

18

26

db9

3

11

19

27db10

3

11

19

27db11

3

11

19

27db12

3

11

19

27

db13

4

12

20

28db14

4

12

20

28db15

4

12

20

28db16

4

12

20

28

db17

5

13

21

29db18

5

13

21

29db19

5

13

21

29db20

5

13

21

29

db21

6

14

22

30db22

6

14

22

30db23

6

14

22

30db24

6

14

22

30

db25

7

15

23

31db26

7

15

23

31db27

7

15

23

31db28

7

15

23

31

db29

8

16

24

32db30

8

16

24

32db31

8

16

24

32db32

8

16

24

32

###### 数据节点默认配置 ######

[NDBD DEFAULT]

NoOfReplicas=4

DataMemory=2576980377

IndexMemory=1288490188

DataDir=/app/ndb/data

BackupDataDir=/app/ndb/data/backup

LockPagesInMainMemory=1

TimeBetweenLocalCheckpoints=20

TimeBetweenGlobalCheckpoints=1000

TimeBetweenEpochs=100

TimeBetweenWatchdogCheckInitial=60000

StringMemory=20

MaxNoOfTables=1024

MaxNoOfOrderedIndexes=2048

MaxNoOfUniqueHashIndexes=512

MaxNoOfAttributes=20480

MaxNoOfTriggers=10240

DiskCheckpointSpeedInRestart=100M

FragmentLogFileSize=256M

NoOfFragmentLogFiles=16

RedoBuffer=64M

MaxNoOfConcurrentOperations=500000

TransactionInactiveTimeout=50000

MaxNoOfExecutionThreads=8

BatchSizePerLocalScan=512

### 磁盘存储

SharedGlobalMemory=20M

DiskPageBufferMemory=80M

###### COMPUTER DEFINITIONS ######

### Datanode Computer #1

[COMPUTER]

Id=1

HostName=datanode1.mysqlab.net

### Datanode Computer #2

[COMPUTER]

Id=2

HostName=datanode2.mysqlab.net

### Datanode Computer #3

[COMPUTER]

Id=3

HostName=datanode3.mysqlab.net

### Datanode Computer #4

[COMPUTER]

Id=4

HostName=datanode4.mysqlab.net

# Management Node Computer #1

[COMPUTER]

Id=5

HostName=mgmtnode.mysqlab.net

#### Data Nodes

# Node group #1

[NDBD]

NodeId=1

ExecuteOnComputer=1

[NDBD]

NodeId=2

ExecuteOnComputer=2

[NDBD]

NodeId=3

ExecuteOnComputer=3

[NDBD]

NodeId=4

ExecuteOnComputer=4

# Node group #2

[NDBD]

NodeId=5

ExecuteOnComputer=1

[NDBD]

NodeId=6

ExecuteOnComputer=2

[NDBD]

NodeId=7

ExecuteOnComputer=3

[NDBD]

NodeId=8

ExecuteOnComputer=4

# Node group #3

[NDBD]

NodeId=9

ExecuteOnComputer=1

[NDBD]

NodeId=10

ExecuteOnComputer=2

[NDBD]

NodeId=11

ExecuteOnComputer=3

[NDBD]

NodeId=12

ExecuteOnComputer=4

# Node group #4

[NDBD]

NodeId=13

ExecuteOnComputer=1

[NDBD]

NodeId=14

ExecuteOnComputer=2

[NDBD]

NodeId=15

ExecuteOnComputer=3

[NDBD]

NodeId=16

ExecuteOnComputer=4

# Node group #5

[NDBD]

NodeId=17

ExecuteOnComputer=1

[NDBD]

NodeId=18

ExecuteOnComputer=2

[NDBD]

NodeId=19

ExecuteOnComputer=3

[NDBD]

NodeId=20

ExecuteOnComputer=4

# Node group #6

[NDBD]

NodeId=21

ExecuteOnComputer=1

[NDBD]

NodeId=22

ExecuteOnComputer=2

[NDBD]

NodeId=23

ExecuteOnComputer=3

[NDBD]

NodeId=24

ExecuteOnComputer=4

# Node group #7

[NDBD]

NodeId=25

ExecuteOnComputer=1

[NDBD]

NodeId=26

ExecuteOnComputer=2

[NDBD]

NodeId=27

ExecuteOnComputer=3

[NDBD]

NodeId=28

ExecuteOnComputer=4

# Node group #8

[NDBD]

NodeId=29

ExecuteOnComputer=1

[NDBD]

NodeId=30

ExecuteOnComputer=2

[NDBD]

NodeId=31

ExecuteOnComputer=3

[NDBD]

NodeId=32

ExecuteOnComputer=4

### Management node

[NDB_MGMD]

Id=33

ExecuteOnComputer=5

# Anonymous API nodes

[MYSQLD]

Id=51

Hostname=mysqld01.mysqlab.net

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]