Mysql-clustering

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

my.ini [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]
 * 1) number of data-copies

[ndb_mgmd] hostname=192.168.42.101 [ndbd] 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) management-server
 * 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