Did we lose a day of posts?

News on forum updates, enhancements and/or special announcements

Moderator: rztom

Post Reply
Message
Author
RC45
- - - - -
- - - - -
Posts: 1637
Joined: Fri Aug 19, 2011 5:18 am
Location: Houston, Texas.

Did we lose a day of posts?

#1 Post by RC45 » Fri Feb 03, 2017 9:40 pm

That was a close one :)

Anytime you come back from a catastrophic hosting location failure intact its a good day :)

Way to have the backups tested.
CBR1000RR SP2 HRC WSBK
TZ500V/OW53 Track bike
YZR500 OW81 Clone
OW69 Daytona 200 Replica - 784cc Monster
NS400 Track Bike
RS250R NF5
TZ250T 2KM
TZ250B 3YL
TZR250 3MA Track Bike
427ci C5 Z07

User avatar
hybrid
Site Admin
Posts: 1189
Joined: Tue Nov 29, 2005 2:33 am
Location: Sydney, Australia
Contact:

Re: Did we lose a day of posts?

#2 Post by hybrid » Fri Feb 03, 2017 9:45 pm

Yes, we lost around a days worth of posts since we had to go to backup.
Unfortunately, we weren't so lucky with the parts database.

Not sure if we will get any data back from that.... the best laid plans...

RC45
- - - - -
- - - - -
Posts: 1637
Joined: Fri Aug 19, 2011 5:18 am
Location: Houston, Texas.

Re: Did we lose a day of posts?

#3 Post by RC45 » Fri Feb 03, 2017 9:48 pm

That's a bit of a fucker.

Different backup tools on the parts database?
CBR1000RR SP2 HRC WSBK
TZ500V/OW53 Track bike
YZR500 OW81 Clone
OW69 Daytona 200 Replica - 784cc Monster
NS400 Track Bike
RS250R NF5
TZ250T 2KM
TZ250B 3YL
TZR250 3MA Track Bike
427ci C5 Z07

User avatar
hybrid
Site Admin
Posts: 1189
Joined: Tue Nov 29, 2005 2:33 am
Location: Sydney, Australia
Contact:

Re: Did we lose a day of posts?

#4 Post by hybrid » Fri Feb 03, 2017 10:04 pm

I just dump the main databases to file, then send them offsite.
The parts section used a completely separate DB that I overlooked.

I think I'm going to configure (very carefully) a full system backup once a month. I previously avoided it because it's so damn big and you can get a clean server up pretty quick these days.
In this case though, it would have saved our bacon.

So I will generate a full backup and see how big it ends up.

User avatar
phildu31
Posts: 271
Joined: Tue Jul 19, 2011 7:49 pm
Location: Toulouse France

Re: Did we lose a day of posts?

#5 Post by phildu31 » Fri Feb 03, 2017 10:25 pm

Hi.
If you use MySQL, you can also setup a second database server and enable replication between the two servers.
The online database will be master for replication and the offline database will be slave for replication.
By doing so, all datas and actions will be mirrored.
But you still have to do complete backups at regular time ( in case of unlucky delete commands ... )
You can PM me for more informations if desired.

User avatar
hybrid
Site Admin
Posts: 1189
Joined: Tue Nov 29, 2005 2:33 am
Location: Sydney, Australia
Contact:

Re: Did we lose a day of posts?

#6 Post by hybrid » Sat Feb 04, 2017 1:37 am

Yes I have experience with MySQL replication via MASTER/SLAVE and MASTER/MASTER.
Overkill for what we need - especially when the costs come from my own pocket.
We just need to make sure we don't leave any important stuff out of the backups, which is what happened here.

RC45
- - - - -
- - - - -
Posts: 1637
Joined: Fri Aug 19, 2011 5:18 am
Location: Houston, Texas.

Re: Did we lose a day of posts?

#7 Post by RC45 » Sat Feb 04, 2017 6:02 am

Do you you need us to throw in a couple bucks to license something more robust than freeware or hosting company hosted database backup tools?
CBR1000RR SP2 HRC WSBK
TZ500V/OW53 Track bike
YZR500 OW81 Clone
OW69 Daytona 200 Replica - 784cc Monster
NS400 Track Bike
RS250R NF5
TZ250T 2KM
TZ250B 3YL
TZR250 3MA Track Bike
427ci C5 Z07

User avatar
hybrid
Site Admin
Posts: 1189
Joined: Tue Nov 29, 2005 2:33 am
Location: Sydney, Australia
Contact:

Re: Did we lose a day of posts?

#8 Post by hybrid » Sat Feb 04, 2017 6:42 am

Thanks for the offer, but no I will just have to be more diligent with making sure everything is covered.
The backups are going to Amazon S3 storage, which is plenty robust enough.

Considering what happened, we haven't come out of it too badly really.

RC45
- - - - -
- - - - -
Posts: 1637
Joined: Fri Aug 19, 2011 5:18 am
Location: Houston, Texas.

Re: Did we lose a day of posts?

#9 Post by RC45 » Sat Feb 04, 2017 5:02 pm

Well, as long as Amazon don't have a GitLabs moment :)
CBR1000RR SP2 HRC WSBK
TZ500V/OW53 Track bike
YZR500 OW81 Clone
OW69 Daytona 200 Replica - 784cc Monster
NS400 Track Bike
RS250R NF5
TZ250T 2KM
TZ250B 3YL
TZR250 3MA Track Bike
427ci C5 Z07

User avatar
hybrid
Site Admin
Posts: 1189
Joined: Tue Nov 29, 2005 2:33 am
Location: Sydney, Australia
Contact:

Re: Did we lose a day of posts?

#10 Post by hybrid » Sun Feb 05, 2017 2:10 am

That would have to happen at the same time as our systems being wiped for it to be a problem.
If both those things happened, I think I would buy a lottery ticket afterwards!

Post Reply