Reminder - Teh Backup Forum

From: Ben (BENLUMLEY)17 Nov 2007 10:36
To: Peter (BOUGHTONP) 4 of 21
mysql replication would be a nice addition - has any thought been given to it?
From: Ben (BENLUMLEY)17 Nov 2007 10:36
To: Peter (BOUGHTONP) 5 of 21
also, it is down at present!

ed: works on hybridchill.com, backup.teh is down.
EDITED: 17 Nov 2007 10:38 by BENLUMLEY
From: Peter (BOUGHTONP)17 Nov 2007 15:34
To: Ben (BENLUMLEY) 6 of 21
Not in my head, until now. Not sure how simple it'd be to do though?
From: Ben (BENLUMLEY)18 Nov 2007 09:37
To: Peter (BOUGHTONP) 7 of 21

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!

From: ANT_THOMAS19 Nov 2007 17:03
To: ALL8 of 21
Was this the cause of the problems?
From: Peter (BOUGHTONP) 6 Oct 2008 20:53
To: ALL9 of 21
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. :)
From: Matt 6 Oct 2008 20:59
To: ALL10 of 21
It will be going down shortly for me to dump the database... but be back up ASAP.
From: Matt13 Sep 2012 10:15
To: Peter (BOUGHTONP) 11 of 21
Not that its all that important, although I'm probably tempting date fate by writing this, but Teh Backup Forum doesn't work.
EDITED: 13 Sep 2012 11:40 by MATT
From: 99% of gargoyles look like (MR_BASTARD)13 Sep 2012 10:16
To: Matt 12 of 21
quote: Matt
I'm probably tempting date by writing this

Are you asking Pete on a date, or expecting him to ask you?
From: Matt13 Sep 2012 10:47
To: 99% of gargoyles look like (MR_BASTARD) 13 of 21
Fortunately just using a predictive input method.
From: 99% of gargoyles look like (MR_BASTARD)13 Sep 2012 11:35
To: Matt 14 of 21
Just as long as he's aware of that! :Y
From: Peter (BOUGHTONP)13 Sep 2012 13:23
To: Matt 15 of 21
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...
From: Chris (CHRISSS) 5 Mar 2013 13:48
To: Peter (BOUGHTONP) 16 of 21
Thanks Pete.
From: milko 5 Mar 2013 15:16
To: Chris (CHRISSS) 17 of 21
is this a clever trick?
From: graphitone 5 Mar 2013 17:25
To: milko 18 of 21
Not that clever, he didn't even ask him what pizza toppings he liked. :C
From: Chris (CHRISSS) 5 Mar 2013 17:54
To: graphitone 19 of 21
I think that may be what scared him off.
From: Ken (SHIELDSIT) 5 Mar 2013 19:41
To: Chris (CHRISSS) 20 of 21
I miss him.  He's lucky I don't live over there.  I'd pay him a visit and /force/ him to post something.
From: Chris (CHRISSS) 5 Mar 2013 19:52
To: Ken (SHIELDSIT) 21 of 21
<gun to head>Post something or die Peteaaarrr </gun to head&Lt;
EDITED: 5 Mar 2013 19:55 by CHRISSS