Ubuntu 12.04下mysql_cluster测试配置

Ubuntu 12.04下mysql_cluster测试配置

Ubuntu 12.04 下测试
可能缺少的库 libaio1

1. tar xvf Downloads/mysql-cluster-gpl-7.1.3-linux-x86_64-glibc23.tar.gz   
2. 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:

1. [ndb_mgmd]   
2. hostname=192.168.1.30  
3. datadir=/home/ddh/my_cluster/ndb_data   
4. NodeId=1  
5.   
6. [ndbd default]   
7. #ndb?   
8. NoOfReplicas=1  
9. DataMemory=344245094  
10. IndexMemory=122122547  
11. datadir=/home/ddh/my_cluster/ndb_data   
12. #BackupDataDir=/app/ndb/data/backup   
13. #LockPagesInMainMemory=1  
14.   
15. #TimeBetweenLocalCheckpoints=20  
16. #TimeBetweenGlobalCheckpoints=1000  
17. #TimeBetweenEpochs=100  
18. #TimeBetweenWatchdogCheckInitial=60000  
19.   
20. StringMemory=20  
21. MaxNoOfTables=1024  
22. MaxNoOfOrderedIndexes=2048  
23. MaxNoOfUniqueHashIndexes=512  
24. MaxNoOfAttributes=20480  
25. MaxNoOfTriggers=10240  
26.   
27. #DiskCheckpointSpeedInRestart=100M   
28. #FragmentLogFileSize=256M   
29. #NoOfFragmentLogFiles=16  
30. RedoBuffer=64M   
31.   
32. #MaxNoOfConcurrentOperations=500000  
33.   
34. #TransactionInactiveTimeout=50000  
35.   
36. #MaxNoOfExecutionThreads=8  
37.   
38. #BatchSizePerLocalScan=512  
39.   
40. ### 磁盘存储   
41. SharedGlobalMemory=20M   
42. DiskPageBufferMemory=80M   
43.   
44. [ndbd]   
45. hostname=192.168.1.114  
46. datadir=/var/my_cluster/ndb_data   
47. NodeId=4  
48.   
49.   
50. [mysqld]   
51. NodeId=50  
52.   
53. [mysqld]   
54.   
55. [mysqld]   
56.   
57. [mysqld]   
58.   
59. [mysqld]  

2.ndb 只需要启动就行

1. ./ndbd -c localhost:1186  
2. ./ndbd -c localhost:1186  

启动两个,干嘛用的?

3.mysql配置

mysql配置文件 conf/my.cnf:   

1. [mysqld]   
2. ndbcluster   
3. user=root   
4. datadir=/home/ddh/my_cluster/mysqld_data   
5. basedir=/home/ddh/mysqlc   
6. ndb-connectstring=localhost   
7. port=3307  
8. #[mysql_cluster]   
9. #ndb-connectstring=192.168.1.30  

1. [mysqld]   
2. ndbcluster   
3. user=root   
4. datadir=/var/my_cluster/mysqld_data   
5. basedir=/usr/local/mysqlc   
6. ndb-connectstring=192.168.1.30  
7. port=3307  
8. #[mysql_cluster]   
9. #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