Clustering/Replication

[Kerry Colligan]

Hey all.

In a previous thread, Sinisa responded to a question about MySQL with 2
servers as such:

>Much better solution then what you proposed is use of clustering with
>data replication. 

How do I set up data replication such that immediate failover is attained?
Or, if the primary MySQL server fails, how do I ensure that data on the
secondary is current?

Any comments greatly appreciated.

Kerry Colligan