linux - Centos 单机 源码 编译 安装 mysql cluster 7.2.7 source install
原文链接http://blog.csdn.net/ylqmf/article/details/7795497
tudou@xiaomi
mkdir -p /opt/soft/mysql-cluster-7.2.7
tudou@xiaomi
CHOST="x86_64-pc-linux-gnu" \
CFLAGS=" -O3 \
-m128bit-long-double \
-m64 \
-ftree-loop-linear \
-fprefetch-loop-arrays \
-freg-struct-return \
-fgcse-sm \
-fgcse-las \
-frename-registers \
-fforce-addr \
-fivopts \
-ftree-vectorize \
-ftracer \
-frename-registers \
-minline-all-stringops \
-felide-constructors \
-fno-exceptions \
-fno-rtti" \
CXXFLAGS="${CFLAGS}" \
cmake -DCMAKE_INSTALL_PREFIX=/opt/soft/mysql-cluster-7.2.7 \
-DMYSQL_UNIX_ADDR=/tmp/mysql-cluster.sock \
-DDEFAULT_CHARSET=utf8 \
-DDEFAULT_COLLATION=utf8_general_ci \
-DEXTRA_CHARSETS=all \
-DWITH_EMBEDDED_SERVER=0 \
-DWITH_MYISAM_STORAGE_ENGINE=1 \
-DWITH_INNOBASE_STORAGE_ENGINE=1 \
-DWITH_MEMORY_STORAGE_ENGINE=1 \
-DWITH_BLACKHOLE_STORAGE_ENGINE=1 \
-DWITH_FEDERATED_STORAGE_ENGINE=1 \
-DWITH_PARTITION_STORAGE_ENGINE=1 \
-DWITH_NDBCLUSTER_STORAGE_ENGINE=1 \
-DENABLED_LOCAL_INFILE=1 \
-DMYSQL_USER=mysql \
-DWITH_DEBUG=0 \
-DWITH_SSL=yes
tudou@xiaomi
make
make install
#config
vi config.ini
[NDBD DEFAULT]NoOfReplicas=2DataMemory=644245094IndexMemory=322122547DataDir=/app/ndb/dataBackupDataDir=/app/ndb/data/backupLockPagesInMainMemory=1TimeBetweenLocalCheckpoints=20TimeBetweenGlobalCheckpoints=1000TimeBetweenEpochs=100TimeBetweenWatchdogCheckInitial=60000StringMemory=28MaxNoOfTables=1024MaxNoOfOrderedIndexes=2048MaxNoOfUniqueHashIndexes=512MaxNoOfAttributes=20480MaxNoOfTriggers=10240DiskCheckpointSpeedInRestart=100MFragmentLogFileSize=256MNoOfFragmentLogFiles=16RedoBuffer=64MMaxNoOfConcurrentOperations=500000TransactionInactiveTimeout=50000MaxNoOfExecutionThreads=8BatchSizePerLocalScan=512### 磁盘存储SharedGlobalMemory=20MDiskPageBufferMemory=80M###### COMPUTER DEFINITIONS ######### Datanode Computer #1[COMPUTER]Id=1HostName=datanode1.mysqlab.net### Datanode Computer #2[COMPUTER]Id=2HostName=datanode2.mysqlab.net# Management Node Computer #1[COMPUTER]Id=3HostName=mgmtnode.mysqlab.net#### Data Nodes# Node group #1[NDBD]Id=1ExecuteOnComputer=1[NDBD]Id=2ExecuteOnComputer=2# Node group #2[NDBD]Id=3ExecuteOnComputer=1[NDBD]Id=4ExecuteOnComputer=2# Node group #3[NDBD]Id=5ExecuteOnComputer=1[NDBD]Id=6ExecuteOnComputer=2# Node group #4[NDBD]Id=7ExecuteOnComputer=1[NDBD]Id=8ExecuteOnComputer=2### Management node[NDB_MGMD]Id=9ExecuteOnComputer=3# Anonymous API nodes[MYSQLD]Id=51Hostname=mysqld01.mysqlab.net
