I need to set up master vs slave replication.
My use case is quite simple. I need to back up a small but fairly
complex(30 MB data, 175 tables) DB remotely over T1 and be able to
switch to that if the main server fails. The switch can even be a
script run manually.
Can someone either comment in as much detail as possible or point me to
a comparison of Slony vs Longiste. Or some other option I have not
heard of?
From what I read Longiste is easy to set up while I got a quote for
Slony setup for 5-10k.