首页 技术 正文
技术 2022年11月11日
0 收藏 735 点赞 5,009 浏览 2407 个字

自己测试机器上搭建使用,大家可以参考一下


[NDBD DEFAULT]

#TotalSendBufferMemory = 256M

NoOfReplicas=2

DataMemory=2500M

IndexMemory=256M

DataDir=/var/lib/mysql-cluster

#FileSystemPath=/data/dbdata

#Redo log

FragmentLogFileSize=32M

InitFragmentLogFiles=SPARSE

NoOfFragmentLogFiles=8

RedoBuffer=1024M

StringMemory=25

LockPagesInMainMemory=1

MaxNoOfTables=4096

MaxNoOfOrderedIndexes=2048

MaxNoOfUniqueHashIndexes=1024

MaxNoOfAttributes=24576

MaxNoOfTriggers=14336

ODirect=1

MaxNoOfConcurrentTransactions=10000

MaxNoOfConcurrentOperations=50000

MaxNoOfLocalOperations=55000

TimeBetweenGlobalCheckpoints=1000

TimeBetweenEpochs=100

TimeBetweenWatchdogCheckInitial=60000

TransactionBufferMemory=10M

DiskCheckpointSpeed=10M

DiskCheckpointSpeedInRestart=100M

TimeBetweenLocalCheckpoints=20

SchedulerSpinTimer=400

SchedulerExecutionTimer=100

RealTimeScheduler=1

BackupMaxWriteSize=1M

BackupDataBufferSize=16M

BackupLogBufferSize=4M

BackupMemory=20M

MaxNoOfExecutionThreads=4

TransactionDeadLockDetectionTimeOut=10000

BatchSizePerLocalScan=512

### Increasing the LongMessageBuffer b/c of a bug (20090903)

LongMessageBuffer=8M

### Heartbeating 

HeartbeatIntervalDbDb=15000

HeartbeatIntervalDbApi=15000

[MGM DEFAULT]

PortNumber: 1186

DataDir: /var/lib/mysql-cluster1

[TCP DEFAULT]

SendBufferMemory: 64M

#######################################

# Change HOST1 to the name of the NDB_MGMD host

# Change HOST2 to the name of the NDB_MGMD host

# Change HOST3 to the name of the NDB_MGMD host

# Change HOST4 to the name of the NDBD host

# Change HOST5 to the name of the NDBD host

# Change HOST6 to the name of the NDBD host

# Change HOST7 to the name of the NDBD host

# Change HOST8 to the name of the NDBD host

# Change HOST9 to the name of the NDBD host

#######################################

[NDB_MGMD]

NodeId: 1

HostName: 10.100.200.36

ArbitrationRank: 1

[NDBD]

NodeId: 4

HostName: 10.100.200.37

[NDBD]

NodeId: 5

HostName: 10.100.200.38

#[NDBD]

#NodeId: 

#HostName:

######################################################

# Note: The following can be MySQLD connections or   #

#      NDB API application connecting to the cluster #

######################################################

[API]

NodeId: 10

HostName: 10.100.200.39

ArbitrationRank: 2

[API]

NodeId: 11

HostName: 10.100.200.39

ArbitrationRank: 2

[API]

NodeId: 12

HostName: 10.100.200.39

ArbitrationRank: 2

[API]

NodeId: 13

HostName: 10.100.200.39

ArbitrationRank: 2

[API]

NodeId: 14

HostName: 10.100.200.41

ArbitrationRank: 2

[API]

NodeId: 15

HostName: 10.100.200.41

ArbitrationRank: 2

[API]

NodeId: 16

HostName: 10.100.200.41

ArbitrationRank: 2

[API]

NodeId: 17

HostName: 10.100.200.41

ArbitrationRank: 2

[API]

[API]

#[API]

#Id: 12

#HostName: HOST3

相关推荐
python开发_常用的python模块及安装方法
adodb:我们领导推荐的数据库连接组件bsddb3:BerkeleyDB的连接组件Cheetah-1.0:我比较喜欢这个版本的cheeta…
日期:2022-11-24 点赞:878 阅读:8,962
Educational Codeforces Round 11 C. Hard Process 二分
C. Hard Process题目连接:http://www.codeforces.com/contest/660/problem/CDes…
日期:2022-11-24 点赞:807 阅读:5,486
下载Ubuntn 17.04 内核源代码
zengkefu@server1:/usr/src$ uname -aLinux server1 4.10.0-19-generic #21…
日期:2022-11-24 点赞:569 阅读:6,331
可用Active Desktop Calendar V7.86 注册码序列号
可用Active Desktop Calendar V7.86 注册码序列号Name: www.greendown.cn Code: &nb…
日期:2022-11-24 点赞:733 阅读:6,114
Android调用系统相机、自定义相机、处理大图片
Android调用系统相机和自定义相机实例本博文主要是介绍了android上使用相机进行拍照并显示的两种方式,并且由于涉及到要把拍到的照片显…
日期:2022-11-24 点赞:512 阅读:7,747
Struts的使用
一、Struts2的获取  Struts的官方网站为:http://struts.apache.org/  下载完Struts2的jar包,…
日期:2022-11-24 点赞:671 阅读:4,781