mysql clustering ?

[tnk]

Hello All,

I followed the your how-to and everything seems to work fine, great thanks!

http://www.howtoforge.com/book/print/1179

However my collague told me it would be better to have the whole setup
on just 2 machines in case 1 of the loadbalancer's indicates an faulty
error?

Also the MySQL 5.1 reference has this basic setup:
1 - management node
1 - sql node, which the application talks to
2 - data node which stores/reads the data

now in your setup we have

1 - management/loadba
1 - loadba
2 - sql nodes?

I'm somehow questioned where the data nodes went?

Also, let's say the application talks to this virtual ip, now the data
gets written to 1 specific mysql server (1 or 2) now if 1 crashed 2
should take over, but will the mysql data be exactly the same as on 1?


Regards

[tnk]

Nobody here with mysql clustering knowledge?

[falko]

I'm somehow questioned where the data nodes went?SQL and data nodes are the same in this tutorial.

Also, let's say the application talks to this virtual ip, now the data
gets written to 1 specific mysql server (1 or 2) now if 1 crashed 2
should take over, but will the mysql data be exactly the same as on 1?
Yes. :)

[tnk]

However my collague told me it would be better to have the whole setup
on just 2 machines in case 1 of the loadbalancer's indicates an faulty
error?

Is it possible to have this whole setup on just 2 machines?

[falko]

I'm not sure if you can have a management node and an SQL node on the same machine. If yes, then it should work.