On Sun, Aug 09, 2015 at 04:08:55PM -0400, Martin Owens wrote:
On Sun, 2015-08-09 at 12:27 -0700, Bryce Harrington wrote:
Should we implement some of our own additional contingency plans, or are our existing processes already up to snuff?
We have a non-zero contingency, which you saw in action. It's an sqlite db which is in read-only mode and it has issues up the wazzoo; the most significant being the downloads being missing from that db.
I'm thinking we need to get a regular backup going, but recent attempts to dump our database fail with the server killing the process (must be some sort of load protection maybe)
After the dust settles, if this remains an issue make sure to follow up with OSUOSL about it. Not being able to make our own backup is obviously a big roadblock for establishing contingency.
Our staging site could/should operate as a proof for the backups.
That's a good idea.
I'm thinking like identifying a temporary web host that could serve as an independent cold fall-over in a worst case scenario like this?
Not sure bout web host; that's something beyond these issues with the db. The web server was working well the whole time. It's just our cms and other data is rather db dependent.
It would be ironic (although hardly unrealistic) if they fix the database up great and next time it's something else like the vm host, that gets hosed. An ideal contingency would be completely independent of OSUOSL (and probably best housed outside the PNW and maybe outside the US.)
Bryce
Martin,
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1
iQIcBAABAgAGBQJVx7NXAAoJEOVbsiwf4qcgE7YQAKERInHnBWq4iFx9vEufruAi uS/t+m3P7qlKokNIapOVoPIOF/TMFgnFAzQuZerGjXx1Rk2UCtT5++fB1dE/jxgw AoGTHBk4L9r/BL2ckP6JdaccfThvd5qtB68keQGf/iVUbFykhbZ7pLztWrkH0Nmv wFGbBmw39Q2jyjk2On4R+vc3+/QqrPNfG2dkEft5XyvJCqQFq7iVq580s9+iZUB0 yZpxWuiSnbMOd/QYTgdHWXJcqAgdmOcEbWuJPAg10NT3P33m33FRmzXVqe0yUuue fsjJ5oooBEW0QyaXMW9KgwO41Nv/YtYWONEhEEs1hBgeN5FTzPL27puDzW8Lzez4 8yOc0XdvhPig+VONOUtw/rxt8brmy5zSu4kKD+i1gGLnzwmF/QWSQ4EnVBURdfFO QW0OCChHSsGznBnahqorMruQzJzmePgtCgTdUz2tim/dS9sw0X6yNgCv0CyyG27a uwlzxk2ragldaBaVt/5/j+QCxX6HwWEpZ/MC0V37Tl3giK8kBdWHVahW2aKe9UHG nypuokYH3hO84IgTLouPUjrOEWkUIavlPPDBIwi+qaMsZkec46tPySgLs1cc0RHP NzWoSzG28bUG8PN1V2jZu8yqY3GeTSlbF7KT0KR0bSuzznxxQ+OCEUecW0zh2aK1 s1VRnBzfcQBKHKulJy+8 =Ydop -----END PGP SIGNATURE-----