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