Test the configuration of mysql_cluster in Ubuntu 12.04

Testing in Ubuntu 12.04
Possible missing library 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/ndb_data my_cluster/conf

1. mgm Configuration

Mgm configuration file conf/config. ini:

1. [Ndb_mgmd]
2. Hostname =192.168.1.30
3. Datadir =/home/ddh/my_cluster/ndb_data
4. NodeId =1
6. [NdbdDefault]
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
15. # TimeBetweenLocalCheckpoints =20
16. # TimeBetweenGlobalCheckpoints =1000
17. # TimeBetweenEpochs =100
18. # TimeBetweenWatchdogCheckInitial =60000
20. StringMemory =20
21. MaxNoOfTables =1024
22. MaxNoOfOrderedIndexes =2048
23. MaxNoOfUniqueHashIndexes =512
24. MaxNoOfAttributes =20480
25. MaxNoOfTriggers =10240
27. # DiskCheckpointSpeedInRestart = 100 M
28. # FragmentLogFileSize = 256 M
29. # NoOfFragmentLogFiles =16
30. RedoBuffer = 64 M
32. # MaxNoOfConcurrentOperations =500000
34. # TransactionInactiveTimeout =50000
36. # MaxNoOfExecutionThreads =8
38. # BatchSizePerLocalScan =512
40. ### Disk storage
41. SharedGlobalMemory = 20 M
42. DiskPageBufferMemory = 80 M
44. [Ndbd]
45. Hostname =192.168.1.114
46. Datadir =/var/my_cluster/ndb_data
47. NodeId =4
50. [Mysqld]
51. NodeId =50
53. [Mysqld]
55. [Mysqld]
57. [Mysqld]
59. [Mysqld]

2. ndb only needs to be started.

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

Start two. Why?

3. mysql Configuration

Mysql configuration file 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

Install mysql database
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 Next Page