MySQL Errors & Dedicated Database Server Questions

I'm running WHM 11.50.1 Build 1 (Current) on CentOS 6.5 x64 with CloudLinux 6.6 and using MariaDB 10.0.21. All of the sudden my MariaDB server is malfunctioning out of nowhere (I have made no modifications to prompt this). My sites aren't able to connect to the database server unless I restart MariaDB. Each time I restart it, it lists a bunch of tables that are marked as "Crashed" which I then have to repair. After that everything works fine for a while and then it happens again... ]http://content.screencast.com/users/a1983hd88/folders/Jing/media/aeac298f-3c71-4d6d-8ee9-5c23167d27bc/2015-08-22_0243.png
I looked for logs under /var/log but there are none for MySQL/MariaDB. I was thinking about just reinstalling with centos7 and cloudlinux but I have some questions first: [LIST]

What can I do to get to the bottom of these errors? I don't want it to happen again.

Could these errors be the result of using WHM "Current?"

I did have SpiderOak monitoring the /Backup directory. When it notices changes it uploads the files to their cloud. Could this have been the initial cause? I found after having to restart the DB server several times that SpiderOak is no longer running for some reason. It would upload while the backup process was underway. I didn't turn SpiderOak back on though and the problem is persisting. This is why I don't believe SpiderOak is causing the error. It isn't running anymore (And it doesn't use MySQL). It could have consumed too much resources during backups but that can no longer be the case.

I've read a lot on using a dedicated MySQL server but some things aren't clear to me. Starting with a fresh install is the procedure to setup the remote server, move over any local databases, connect WHM to the remote server, and then deactivate the local mysql server?

Does a remote db server need to be running WHM? There's no one page I can find detailing the entire process of setting up the remote server and how/what to transfer to it and what to do with the local server afterward.

Can the remote server be the main server in a Percona or MariaDB cluster? If so, is there anything special I need to do for such a configuration?

Are there any recommended specs for a remote server? Some ratio of combined database sizes to RAM/HDD/CPU? I would be running it on a VPS. Like I said, I'd like to get to the bottom of the current errors first. I do have cpanel backups for the past week but I don't want to migrate tables to a new install that are going to harm it. Thank you.

kray

August 22, 2015 09:24

I just had to restart MySQL again and got the following: ]http://content.screencast.com/users/a1983hd88/folders/Jing/media/e6c1d219-18aa-41dd-88ff-1da66aa0e0c8/2015-08-22_0524.png

August 22, 2015 09:46

Here's the main mysql error log. I've uploaded it to a site because it's too big to attach to this post:

cPanelMichael

August 31, 2015 18:48

Hello :) I suggest tweaking your MySQL configuration to help prevent the memory errors referenced in the image you attached to the thread. The following thread will help you get started:

MySQL Errors & Dedicated Database Server Questions

Comments

Didn't find what you were looking for?