500 Two-Stroke Tech

500cc GP-Replica Tech Forums

Search  FAQ  Register Login
It is currently Sat Sep 22, 2018 4:13 pm

All times are UTC - 4 hours [ DST ]




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: Did we lose a day of posts?
PostPosted: Fri Feb 03, 2017 9:40 pm 
Offline
- - - - -
- - - - -

Joined: Fri Aug 19, 2011 5:18 am
Posts: 1600
Location: Houston, Texas.
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.

_________________
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


Top
 Profile  
Reply with quote  
 Post subject: Re: Did we lose a day of posts?
PostPosted: Fri Feb 03, 2017 9:45 pm 
Offline
Site Admin
User avatar

Joined: Tue Nov 29, 2005 2:33 am
Posts: 1183
Location: Sydney, Australia
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...

_________________
http://www.2strokesdownunder.com
http://www.winsto.net/piggie/
http://www.winsto.net/projects/


Top
 Profile  
Reply with quote  
 Post subject: Re: Did we lose a day of posts?
PostPosted: Fri Feb 03, 2017 9:48 pm 
Offline
- - - - -
- - - - -

Joined: Fri Aug 19, 2011 5:18 am
Posts: 1600
Location: Houston, Texas.
That's a bit of a fucker.

Different backup tools on the parts database?

_________________
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


Top
 Profile  
Reply with quote  
 Post subject: Re: Did we lose a day of posts?
PostPosted: Fri Feb 03, 2017 10:04 pm 
Offline
Site Admin
User avatar

Joined: Tue Nov 29, 2005 2:33 am
Posts: 1183
Location: Sydney, Australia
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.

_________________
http://www.2strokesdownunder.com
http://www.winsto.net/piggie/
http://www.winsto.net/projects/


Top
 Profile  
Reply with quote  
 Post subject: Re: Did we lose a day of posts?
PostPosted: Fri Feb 03, 2017 10:25 pm 
Offline

Joined: Tue Jul 19, 2011 7:49 pm
Posts: 244
Location: Toulouse France
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.


Top
 Profile  
Reply with quote  
 Post subject: Re: Did we lose a day of posts?
PostPosted: Sat Feb 04, 2017 1:37 am 
Offline
Site Admin
User avatar

Joined: Tue Nov 29, 2005 2:33 am
Posts: 1183
Location: Sydney, Australia
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.

_________________
http://www.2strokesdownunder.com
http://www.winsto.net/piggie/
http://www.winsto.net/projects/


Top
 Profile  
Reply with quote  
 Post subject: Re: Did we lose a day of posts?
PostPosted: Sat Feb 04, 2017 6:02 am 
Offline
- - - - -
- - - - -

Joined: Fri Aug 19, 2011 5:18 am
Posts: 1600
Location: Houston, Texas.
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?

_________________
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


Top
 Profile  
Reply with quote  
 Post subject: Re: Did we lose a day of posts?
PostPosted: Sat Feb 04, 2017 6:42 am 
Offline
Site Admin
User avatar

Joined: Tue Nov 29, 2005 2:33 am
Posts: 1183
Location: Sydney, Australia
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.

_________________
http://www.2strokesdownunder.com
http://www.winsto.net/piggie/
http://www.winsto.net/projects/


Top
 Profile  
Reply with quote  
 Post subject: Re: Did we lose a day of posts?
PostPosted: Sat Feb 04, 2017 5:02 pm 
Offline
- - - - -
- - - - -

Joined: Fri Aug 19, 2011 5:18 am
Posts: 1600
Location: Houston, Texas.
Well, as long as Amazon don't have a GitLabs moment :)

_________________
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


Top
 Profile  
Reply with quote  
 Post subject: Re: Did we lose a day of posts?
PostPosted: Sun Feb 05, 2017 2:10 am 
Offline
Site Admin
User avatar

Joined: Tue Nov 29, 2005 2:33 am
Posts: 1183
Location: Sydney, Australia
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!

_________________
http://www.2strokesdownunder.com
http://www.winsto.net/piggie/
http://www.winsto.net/projects/


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 

All times are UTC - 4 hours [ DST ]


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group