Cafe Husky Server Crashed and Gone

[Moto7man]

Well, just like the site AllThingsmoto.com, Cafe Husky site is also toast.

http://www.cafehusky.com/account/alerts

[Wbdisco]

That?s weird

[(F5)]

If you need to look at departed sites you can see archived material on the whole internerd:
The way back machine. Google it if unfamiliar. Still appears to be working.

[SS109]

I truly hope that can't happen with this forum.

[Neil E.]

It can happen with any forum. A good hosting plan with daily backups is the usual way to prevent issues. If the site owner forgets to pay some of the important bills, the host can delete a site. A totally privately owned site relies on the quality of the hardware. Usually the worst case is losing a few days of content based on the most recent backup. It's easy for things to go poof in this electronic age ....... cue the end of the world movies. I often think we'd be better off without (anti)social media.

[webmaster]

I do backups of the data on disk once a week and also a backup of the sql database on same interval. I store this off site on my personal google drive (cloud).

If disaster struck - At most, we would lose one week in posts...

They obviously didn't have a good backup routine in place on cafehusky...

There is an sql command to repair the database if it becomes corrupted. And I use that on occasion with good success - so I have never had to use the backup.

jeff

[gasgasman]

Originally Posted by SS109

I truly hope that can't happen with this forum.

That's why the donations are so important.

[webmaster]

Another thing to mention is that this site is quite old school where the web server is running at my home. It is a linux box running apache webserver and mysql database. We pay for internet connection with static IP address versus hosting/vps fees.

I have thought about moving it off - but I had trouble with one site off site where it had too much activity and slowed down a shared machine - they shut me down.

Searching and web crawlers will slow down a site - this one is pretty fast even though the machine is a little old. We have the entire CPU and entire memory to ourselves...

I talked to my friend Les and he told me that cafehusky owner dean died a few years back and then someone was able to get into his hosting company to keep it going for a while. Sounds like they had it limping along until it finally died....

jeff

[coopernicus]

Originally Posted by webmaster

Another thing to mention is that this site is quite old school where the web server is running at my home. It is a linux box running apache webserver and mysql database. We pay for internet connection with static IP address versus hosting/vps fees.

I have thought about moving it off - but I had trouble with one site off site where it had too much activity and slowed down a shared machine - they shut me down.

Searching and web crawlers will slow down a site - this one is pretty fast even though the machine is a little old. We have the entire CPU and entire memory to ourselves...

I talked to my friend Les and he told me that cafehusky owner dean died a few years back and then someone was able to get into his hosting company to keep it going for a while. Sounds like they had it limping along until it finally died....

jeff

Does mysql have a transaction log that can have a script run against it for db transactions in a specified date range? That way most transactions can be re-applied from the db backup as long as the transaction log dumps are also saved. A LONG time ago we used to rebuild Sybase from a db backup and re-apply transactions for our systems. We had storage limitations in the old days that necessitated that process. I don't know if RDBs are like that these days!

Yes. I'm old...

[webmaster]

Originally Posted by coopernicus

Does mysql have a transaction log that can have a script run against it for db transactions in a specified date range? That way most transactions can be re-applied from the db backup as long as the transaction log dumps are also saved. A LONG time ago we used to rebuild Sybase from a db backup and re-apply transactions for our systems. We had storage limitations in the old days that necessitated that process. I don't know if RDBs are like that these days!

Yes. I'm old...

Yes, mysql logging is enabled. Never had to use it though - thank god... My understanding is that it can be used to restore to a point somewhere between the weekly backups...

jeff