MySql Master-Master Replication via Internet

Discussion in 'Installation/Configuration' started by Rocky, Jun 22, 2007.

  1. Rocky

    Rocky New Member

    Hey Guys,

    I was wondering if anyone has tried to do a mysql master master replication through the internet. I have 2 offices which are currently connected via a private point to point line. However, the boss wants to cut off the point to point line and have them use a DSL line for their internet. I am forced to find a way to replicate through the internet.

    Right now I have the two servers replicating through the point to point line and it's working flawlessly.
    My concern is will it replicate in a timely fashion via the internet? I was planning on using the master master tutorial found here.

    Anyone has any advice or suggestions?

    Thanks,

    Rocky
     
  2. falko

    falko Super Moderator

    I think that should work, of course depending on your bandwidth and how often the data in the database is changed.
     
  3. shayster01

    shayster01 New Member

    I have tried it and it works fine. I have only tried it with small files but it happens almost instantly.
     
  4. Rocky

    Rocky New Member

    I'll give it a shot after Verizon upgrades the other office to a higher DSL + static IP.

    Should I worry about using SSL with my setup? I will be replicating company sensitive data like orders and invoices and those kind of things.

    Rocky
     

Share This Page