Did we lose a day of posts?
Moderator: rztom
Did we lose a day of posts?
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.
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
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
Re: Did we lose a day of posts?
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...
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...
Re: Did we lose a day of posts?
That's a bit of a fucker.
Different backup tools on the parts database?
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
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
Re: Did we lose a day of posts?
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.
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.
Re: Did we lose a day of posts?
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.
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.
Re: Did we lose a day of posts?
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.
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.
Re: Did we lose a day of posts?
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
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
Re: Did we lose a day of posts?
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.
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.
Re: Did we lose a day of posts?
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
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
Re: Did we lose a day of posts?
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!
If both those things happened, I think I would buy a lottery ticket afterwards!