MySQL Replication, different continents

Discussion in 'MySQL' started by FredrikMH, Aug 1, 2007.

  1. #1
    I'm looking into having the same website and same data but different languange placed on different places. The english version will be placed in US on my current server and the other on in UK with some languages used in europe.

    1 DB with members and data related to that must be shared and both writing and reading will be done to this db so I was thinking about 2 masters for this.

    I will also have another local DB on each server with information that does not need to be shared or accessed from the other server.

    Is this possible to accomplish?
    What happens with auto_increment on tables which are synced?
    How much data can actually be transfered this way?

    I want to get a very fast connection to both Europe and US, and this is the only idea I can up with.
     
    FredrikMH, Aug 1, 2007 IP