MySql database synchronization

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • foss
    New Member
    • Dec 2007
    • 11

    MySql database synchronization

    Hi all,
    My scenario goes like this:

    We have two Mysql Databases in different servers.
    The communication between these database servers is via low bandwidth internet (Again the internet may go down for some hours or some days).
    Both databases are having the same structure.
    We are not concerned to synchronize the database structure but we need to synchronize only the data stored in these databases.

    (I googled to search some strategies that would work for this scenario but could not get it. All I got was about some commercial applications.)

    I would be thankful if anyone can provide a solution or link to free php code (or modules) that can serve this purpose.

    Thanks
  • code green
    Recognized Expert Top Contributor
    • Mar 2007
    • 1726

    #2
    We are not concerned to synchronize the database structure but we need to synchronize only the data stored in these databases.
    What do you mean by synchronise.
    Is one simply a copy of the other are are they continually changing independently

    Comment

    • foss
      New Member
      • Dec 2007
      • 11

      #3
      Here,
      Both databases(runni ng on different servers) can be updated independently, i.e. if changes (inserting data, deleting data, modifying data ..) are made in Database1 then the Database2 should be updated accordingly. Again, if changes are made in Database2 then the Database1 should be updated accordingly. This is to say that neither of the database is master or slave. Changes can occur independently in any database BUT this should be reflected accordingly in the other database.

      Comment

      Working...