Content added Content deleted
imported>Hundfred No edit summary |
imported>Hundfred No edit summary |
||
(One intermediate revision by the same user not shown) | |||
Line 1: | Line 1: | ||
'''mysql-clustering''' |
'''mysql-clustering''' |
||
this all was not tested and finally not working directly |
|||
while compiling mysqld you have to enable the ndb functionality: |
while compiling mysqld you have to enable the ndb functionality: |
||
--enable-db-clustering |
--enable-db-clustering |
||
Line 24: | Line 27: | ||
[ndb_mdmd default] |
[ndb_mdmd default] |
||
[tcp default] |
[tcp default] |
||
#management-server |
#management-server |
||
[ndb_mgmd] |
[ndb_mgmd] |
||
hostname=192.168.42.101 |
hostname=192.168.42.101 |
||
#list of all storage nodes including their data-directory |
#list of all storage nodes including their data-directory |
||
[ndbd] |
[ndbd] |
||
hostname=192.168.42.102 |
hostname=192.168.42.102 |
||
datadir="C:\Programme\MySQL\MySQL Server 7.0\mysql-cluster" |
datadir="C:\Programme\MySQL\MySQL Server 7.0\mysql-cluster" |
||
[NDBD] |
|||
hostname=192.168.42.103 |
hostname=192.168.42.103 |
||
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 |
||
Line 43: | Line 47: | ||
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 |
||
[...] |
[...] |
||
</pre> |
</pre> |
||
later we try to start the management-daemon |
|||
<pre> |
|||
ndb_mgmd |
Latest revision as of 21:28, 3 July 2009
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 #cluster-management-server ndb-connectstring=kurs001 [mysql-cluster] ndb-connectstring=kurs001
on the management-server, we create a folder
called mysql-cluster
inside that we create a file, called config.ini:
[ndb default] #number of data-copies noofreplicas=5 [mysqld default] [ndb_mdmd default] [tcp default] #management-server [ndb_mgmd] hostname=192.168.42.101 #list of all storage nodes including their data-directory [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 [...] #mysql-nodes [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 [...]
later we try to start the management-daemon
ndb_mgmd