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
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?
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.