Replication? Clustering? or?

[Luca Rondanini]

Hi all,

I have a huge(for me) latency problem. think to the internal web portal of my company as a kind of "excel file"....lots of writes/updates! We have 3 locations: California, Australia and Austria (Europe).

My architecture is a classic Apache+PHP+Mysql. Right now, all the services are stored in California...which means...a huge latency in Australia and Austria. The perfect scenario would be to have 3 mysql instances running locally in each location but I don't know which is the best way to synchronize all the instance with each other. I need fast inserts/selects but I can wait to see my data replicated on the other servers. Consistence between the 3 instances of course is crucial: all the 3 dbs MUST be an exact replica of each other.

Replication seems the best solution cause I don't really need synchronous updates...but I have lots of writes...and those writes should be instantly visible to the local instance! It seems like I need a "creative" solution but as you can see I don't have much experience on this matter....if anyone of you can point me in the right direction....it would be a great help

Thanks