Re: mysql clustering

[ankush grover]

Hey,

Thanks for the reply.Can you further clear me.Let me explain you about the kind of scenario where we want to put mysql servers.

We are in healthcare domain,we are developing few applications for hospitals.In the ideal environment there will be 2 servers with the same configurations(running on RedHat Linux/Debian Linux).What I want to know as mentioned in the mysql manual one has to configure management server,sql nodes,data nodes for mysql cluster.Is it possible that all these 3 are on one server which will act as primary server and again all these 3 on the slave server also ?

When the primary server fails the slave server automatically takes up the charge with the same data as it was there on the primary server before it fails means data synchronizing should happen automatically.




Please guide me .

Thanks & Regards

Ankush Grover