mysql cluster 内存_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英文参考文档

数据+索引最大尺寸: ~32GB, 其中 19.2GB (60%) 用于数据 , 9.6GB (30%) 用于索引

物理位置

物理位置 #1

1db1

db3

物理位置 #2

2db2

db4

节点配置: 2个节点组

Node

Group 1

Node

Group 2

db1

1

3db2

1

3

db3

2

4db4

2

4

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

[NDBD DEFAULT]

NoOfReplicas=2

DataMemory=5153960755

IndexMemory=2576980377

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

# Management Node Computer #1

[COMPUTER]

Id=3

HostName=mgmtnode.mysqlab.net

#### Data Nodes

# Node group #1

[NDBD]

NodeId=1

ExecuteOnComputer=1

[NDBD]

NodeId=2

ExecuteOnComputer=2

# Node group #2

[NDBD]

NodeId=3

ExecuteOnComputer=1

[NDBD]

NodeId=4

ExecuteOnComputer=2

### Management node

[NDB_MGMD]

Id=5

ExecuteOnComputer=3

# Anonymous API nodes

[MYSQLD]

Id=51

Hostname=mysqld01.mysqlab.net

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]

[MYSQLD]