作者:1212 | 来源:互联网 | 2017-10-11 16:35
Ubuntu12.04下测试可能缺少的库libaio1tarxvfDownloads/mysql-cluster-gpl-7.1.3-linux-x86_64-glibc23.tar.gzln-smysql-cluster-gpl-7.1.3-linux-x86_64-glibc23&nb
Ubuntu 12.04 下测试
可能缺少的库 libaio1
- tar xvf Downloads/mysql-cluster-gpl-7.1.3-linux-x86_64-glibc23.tar.gz
- ln -s mysql-cluster-gpl-7.1.3-linux-x86_64-glibc23 /usr/mysqlc
mkdir my_cluster my_cluster/ndb_data my_cluster/conf
1.mgm的配置
mgm配置文件 conf/config.ini:
- [ndb_mgmd]
- hostname=192.168.1.30
- datadir=/home/ddh/my_cluster/ndb_data
- NodeId=1
-
- [ndbd default]
- #ndb?
- NoOfReplicas=1
- DataMemory=344245094
- IndexMemory=122122547
- datadir=/home/ddh/my_cluster/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
-
- [ndbd]
- hostname=192.168.1.114
- datadir=/var/my_cluster/ndb_data
- NodeId=4
-
-
- [mysqld]
- NodeId=50
-
- [mysqld]
-
- [mysqld]
-
- [mysqld]
-
- [mysqld]
2.ndb 只需要启动就行
- ./ndbd -c localhost:1186
- ./ndbd -c localhost:1186
启动两个,干嘛用的?
3.mysql配置
mysql配置文件 conf/my.cnf:
- [mysqld]
- ndbcluster
- user=root
- datadir=/home/ddh/my_cluster/mysqld_data
- basedir=/home/ddh/mysqlc
- ndb-cOnnectstring=localhost
- port=3307
- #[mysql_cluster]
- #ndb-cOnnectstring=192.168.1.30
- [mysqld]
- ndbcluster
- user=root
- datadir=/var/my_cluster/mysqld_data
- basedir=/usr/local/mysqlc
- ndb-cOnnectstring=192.168.1.30
- port=3307
- #[mysql_cluster]
- #ndb-cOnnectstring=192.168.1.30
安装"mysql"数据库
cd mysqlc
scripts/mysql_install_db --no-defaults --datadir=$HOME/my_cluster/mysqld_data/
/usr/local/mysqlc/bin/mysqladmin --defaults-file=/var/my_cluster/conf/my.cnf -u root password root