<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<div class="moz-cite-prefix">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.<br>
<br>
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.<br>
<br>
On 04/23/2015 07:43 PM, Charles Butler wrote:<br>
</div>
<blockquote cite="mid:20150423234342.GA7880@Bushido" type="cite">
<pre wrap="">* Joe Prostko (<a class="moz-txt-link-abbreviated" href="mailto:joe.prostko@gmail.com">joe.prostko@gmail.com</a>) wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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
</pre>
</blockquote>
<pre wrap="">
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
</pre>
<blockquote type="cite">
<pre wrap="">_______________________________________________
wplug-internet mailing list
<a class="moz-txt-link-abbreviated" href="mailto:wplug-internet@wplug.org">wplug-internet@wplug.org</a>
<a class="moz-txt-link-freetext" href="http://www.wplug.org/mailman/listinfo/wplug-internet">http://www.wplug.org/mailman/listinfo/wplug-internet</a>
</pre>
</blockquote>
<pre wrap="">
</pre>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
wplug-internet mailing list
<a class="moz-txt-link-abbreviated" href="mailto:wplug-internet@wplug.org">wplug-internet@wplug.org</a>
<a class="moz-txt-link-freetext" href="http://www.wplug.org/mailman/listinfo/wplug-internet">http://www.wplug.org/mailman/listinfo/wplug-internet</a>
</pre>
</blockquote>
<br>
</body>
</html>