MySQL Data Center Replication

view story

http://serverfault.com – I have a (possibly not so quick question) about the best way to set up a 'global' MySQL Database. I basically need to set up multiple MySQL servers in separate geographical locations that will all server the same data set (i.e. If I add data to one server, it will appear on another server relatively quickly). For example, if a user in America connects to our US website and orders a product (the US web server will be connected to a US MySQL Server), we need the data that was just inserted/updated/deleted/whatever to be syncronised with our Australian, New Zealand, UK etc MySQL Servers. I've t (HowTos)