I would like to know your opinion about how to build the best database architecture posible.
This is a website, let's say it is a forum, with traffic from everywhere around the globe.
I'm trying to figure out the best way, because now we have multiple apache servers around the world, connecting to a main database in EU, the performance is not really good, obviously.
So I'm thinking in the mysqi replication "system" can it be good or not for me? The idea is to have a main mysql server in EU (where all clients will write), and replications of this mysql database in each apache server for read-only.
So, users from NA will connect to a NA server, will read from a (replicated) database in NA and writing in the main EU database.
Do you think this is a good idea? Is mysql replication good enough for that?
If a user from south america, writes in the EU server, how long this database row will take to be available in the South america server to be read?
Hope my english is good enough and you can understand me :)
Thank you