[wplug-internet] FYI: MariaDB crashed on wplug.org last night

[John Lewis]

Chuck, we are currently now using a backup service other than the random
linode system backup that occasionally happen. If we think it would
help, I can create a rsnapshot job and back WPLUG's system up with the
rest of my backups including dumping the databases.

We are running sysstat so we can troubleshoot what was happening when
the Database crashed, I just upped the logging to where I like it today.

On 04/23/2015 07:43 PM, Charles Butler wrote:
> * Joe Prostko (joe.prostko at gmail.com) wrote:
>> I'm still investigating the root cause, but MariaDB crashed last night a
>> little after 3 AM.  It seems that the RAM got entirely used up, and this
>> was related to our set innodb_buffer_pool.  That said, something doesn't
>> seem exactly right to me, so I'm going to examine the logs more.  Also,
>> there were some things in the mariabd.log file about tables possibly being
>> corrupted, so likely early in the AM tomorrow morning I'll go about
>> repairing the tables, just in case.
>>
>> - joe
> Joe,
>
> are we using a backup service like tarsnap or something similar to give
> us a layer of data integrity in the event of catastrophy?
>
> All the best,
>
> Chuck
>
>> _______________________________________________
>> wplug-internet mailing list
>> wplug-internet at wplug.org
>> http://www.wplug.org/mailman/listinfo/wplug-internet
>
>
> _______________________________________________
> wplug-internet mailing list
> wplug-internet at wplug.org
> http://www.wplug.org/mailman/listinfo/wplug-internet

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.wplug.org/pipermail/wplug-internet/attachments/20150424/6a8a0589/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 490 bytes
Desc: OpenPGP digital signature
URL: <http://www.wplug.org/pipermail/wplug-internet/attachments/20150424/6a8a0589/attachment.sig>