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

1 2 下一頁