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 taken a look into MySQL Clusters, Master-Master replication, Galera Cluster, Circular Replication etc and was wondering what your thoughts were? I've read many pros and cons and simply can't decide what the best option is. Are there any reference setups that you are aware of?
I thank you for your time and valuable input :)