Hi guys!
I am having some doubts in how to implement a high availability,
geographically distributed MySQL DB.
The thing is, I would like to have.. let's say two (02) app. servers
with two (02) DB servers, running exactly the same data. In case one
fail, the other will be available. The thing is, how can i ensure that
both DB servers has exactly the same data? I took a look at Replication
features, but it seems to only use MyISAM tables. This way should not
work since, both App. Servers can insert data at any given moment, but
having ONLY one server isn't the answer neither. I would like to know
any suggestions on how to solve a problem like this. Any ideas are
welcome. Any suggestions are also VERY welcome.
Best Regards.
Vic.
