Not everything is completely working as yet, but first a note as to why...
After my database outage turned out to be a hacking incident. I've plugged the security holes.
I've also redone the way my backups work (a word to the wise here) - my new backup scripts now shut down MySQL during the backup just to be sure the dump is as consistent as possible. This gives me about 60 seconds of downtime per evening... well worth the effort as my DB backup was not usable and I had to roll back further than I wanted to.
The galleries are back, but the blog entries need some repair to show the images correctly.
Also, in the course of this restoration effort, I decided I've hit the limit of what can reasonably be backed up by tar. I've switched to dar. It has much better single-file recovery capability. It also compresses files on a per-file basis inside the archive. It is a bit clunky about how it handles "out of space" errors, so you have to plan ahead. It's incremental backup facility works much better than with tar, including file removal recording.
I also decided that swapping 500gb drives in an out via USB is too much manual work - and manual work tends to mean that backups don't get done. So, I'm building a new server with a huge RAID 5 array just for running backups. I also plan to run a WinXP virtualized client so I can keep using Retrospect for windows backups.
In the course of THAT project I sadly figured out that the dual core 2140 cpu I ordered (because it was very cheap and a great value) does not support hardware virtualization.
The Conroe 4500 seems like the value-ticket for running a virtualized WinXP system.
Although I love Newegg, I've started recently ordering from ClubIT. They have ood service, good pricing, and for CPUs they sell by stepping - which is critical if you are working on an overclocking project. I've seen various favorable posts from them on various tech forums as well.
Stay tuned for more on the gallery reorg.
-Bob





