Mysql-clustering

mysql-clustering

this all was not tested and finally not working directly

while compiling mysqld you have to enable the ndb functionality: --enable-db-clustering

my.ini on the cluster-node [mysqld] nbdcluster ndb-connectstring=kurs001 [mysql-cluster] ndb-connectstring=kurs001
 * 1) cluster-management-server

on the management-server, we create a folder called mysql-cluster inside that we create a file, called config.ini: [ndb default] noofreplicas=5 [mysqld default] [ndb_mdmd default] [tcp default] [ndb_mgmd] hostname=192.168.42.101
 * 1) number of data-copies
 * 1) management-server

[ndbd] hostname=192.168.42.102 datadir="C:\Programme\MySQL\MySQL Server 7.0\mysql-cluster" [NDBD] hostname=192.168.42.103 datadir="C:\Programme\MySQL\MySQL Server 7.0\mysql-cluster"hostname=192.168.42.103 [...]
 * 1) list of all storage nodes including their data-directory

[mysqld] hostname=192.168.42.102 datadir="C:\Programme\MySQL\MySQL Server 7.0\mysql-cluster" hostname=192.168.42.103 datadir="C:\Programme\MySQL\MySQL Server 7.0\mysql-cluster"hostname=192.168.42.103 [...]
 * 1) mysql-nodes

later we try to start the management-daemon ndb_mgmd