9 Nov
2016
9 Nov
'16
11:06 p.m.
On 2016-11-09 17:09, Ted Roche wrote:
Well, any computer file has potential for corruption. And there's lots and lots of settings for tuning. If you're using phpMyAdmin or similar, there's likely a "Settings"page.
My primary MariaDB system still under maintenance does a daily mysqldump to SQL, compressed, and shipped off to a warm standby system, where it's reconstituted, so the data is rebuilt nightly on the standby systems. The main system is dumped and rebuilt monthly or so.
Wow. Impressive. Makes me think about my setup, but as I said, there's been no signs of trouble, so I'm not wanting to do anything to a "not broken" system.