SitePoint Sponsor

User Tag List

Results 1 to 3 of 3

Thread: DB replication

  1. #1
    SitePoint Addict
    Join Date
    Mar 2004
    Location
    Grand Junction, CO
    Posts
    292
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    DB replication

    First of all, I know this is probably a tough thing, so I don't expect a complete answer to my question. I'm really just looking for advice on where to go to figure this out.

    I want to run software on two separate servers, independently. Each will have a database, but I want both databases to maintain the same info. The problem is that I can't really just set up a basic master/slave replication relationship (I think), because each server will insert data into its own DB. So let's say that server1 inserts some records, then server2 should have that exact data as well, and vice versa.

    I was thinking of making one as a master, one as a slave, and just making updates to the master. But if the either server goes offline, I want the other one to continue running the software normally, and then the offline server will synch up its database when it comes back online.

    I imagine this is nontrivial...but it'd be great if it actually was simple Hopefully somebody can help me out with this, or point me somewhere. Thanks

  2. #2
    Non-Member l0t3k's Avatar
    Join Date
    Feb 2005
    Posts
    41
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    what db r u using????

  3. #3
    SitePoint Addict
    Join Date
    Mar 2004
    Location
    Grand Junction, CO
    Posts
    292
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Considering this is the MySQL forum :P


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •