its fairly straightforward to set up master slave replication, assuming you've got that level of access to the server, which would make sure everything added here gets added to the other server.

 

difficult thing would be how to deal with the other direction. you can use replication in both directions, but the servers need to use offset auto increments (one uses odd numbers, the other uses even) and things, to ensure that they don't both add data with the same primary key. this would mess up the thread/post numbering though, since it relies on primary keys.

 

only way i can see it working is if use 2 way replication, but use a script to prevent people accessing the backup forum unless this place is down.

 

but such a script would need to be fairly robust, or it may not let us in when we need the backup place, and equally, may let people in when it shouldn't.

 

so, probably more effort than its worth!

Was this the cause of the problems?

Just bumping this thread because I'm a bit paranoid at the moment.

So, if this place ends up going AWOL, remember:

http://backup.tehforum.co.uk

(and hybridchill.com/~tehbak if that URL fails)


BOOKMARK THEM BOTH NOW!


Thank you. :)

It will be going down shortly for me to dump the database... but be back up ASAP.

Not that its all that important, although I'm probably tempting date fate by writing this, but Teh Backup Forum doesn't work.

Are you asking Pete on a date, or expecting him to ask you?

Fortunately just using a predictive input method.

Just as long as he's aware of that! :Y

What a fortunate prediction! How did you know I wanted to on a date and input with you? :D

Is tomorrow good? I'm a bit busy today...

Thanks Pete.

is this a clever trick?

Not that clever, he didn't even ask him what pizza toppings he liked. :C

I think that may be what scared him off.

I miss him.  He's lucky I don't live over there.  I'd pay him a visit and /force/ him to post something.

<gun to head>Post something or die Peteaaarrr </gun to head&Lt;