"LOAD BALANCED SERVER CLUSTER" sounds great. It assures fail over and a 100% up time of the sites. So I decided to go for it and get them. Now I'm stacked thinking how the h*ll can I use MySQL in this configuration. I look forward for sugestions.

Here are the options I found:
1. MySQL 4.1's clustering implementation which would solve the problemif I can make it work on two computers and not on three. Is this possible ?

2. write the data into the master server's DB and keep a replica on the slave. Still, I don't know how can I switch the slave to use the replica if the master goes down.



I'd really need some help here. Now I will try to see if I can configure a native MySQL clustering on two servers only and still function correctly. Should I even bother ?

Jorj