MySQL database solution

Question

I have 2 offices that are located around 500km apart and both offices need to access the MySQL database frequently. So to make it faster I am planning to set up two MySQL servers where each office has one server then make these two MySQL servers act as master/master replication so both offices can read/write with updated data.

Now I am wondering whether this is the right solution or there is a better one? Please advise.

Answer 1

Master/master replication is certainly the way to achieve the desired results but you need to take into consideration possibly lag resulting from a combination of bandwidth and the amount of data that is to be transferred to maintain syncronisation.