Just feel like talking about what MariaDB did to my personal server.
I have been reading a lot of good things about MariaDB since long ago but I didn’t bother to upgrade my personal VPS to it until recently I was so tired of having server errors popup every ~2 days on my xenForo forum (this happens since many months ago and I just didn’t take it too seriously). These server errors are memory related. When my forum dumps these memory errors, that’s when my RAM graph jumped to the toppest (I supposed processes were killed at this time) and then I get “myforum.com is in trouble” email from my server monitoring website. In this case, MySQL was the culprit. I finally seek advice from my hosting provider and agreed to upgrade to MariaDB to see if it does improve my RAM performance.
Below graph shows since May 28 my memory has been so steady and I no longer seeing memory errors on my forum. Prior to this date, the RAM utilisation was so crazy. MariaDB does a really good job, you almost instantly see the result. If anyone hesitates whether to use it on your personal/business interworx/cpanel/etc servers, I urge you to try it out!
Yes, would be excellent. I personally like perconna myself.
Although, you have already made it part of IW
Have you installed bfd and there’s another price of software which prioritises processes, such as MySQL, http etc… But just cannot remember what it’s called, but will look it up
Looks like MariaDB works rather nicely… I just did a MySQL to MariaDB migration on the InterWorx server I have.
Only issue I had was getting MariaDB to start. The issue was resolved by commenting out
pid-file=/var/run/mysqld/mysqld.pid
. Once that was sorted, MariaDB successfully started.
Also performed mysql_upgrade so that MySQL databases were properly set to work with MariaDB. So far, seeing a pretty good drop in heavy usage after the switch. Less of an issue with MySQL now on our server, I hope… but I’ll be monitoring how things go.
Incidentally… I have a feeling this was a very bad idea on my part because InterWorx is most likely already working on a MySQL-MariaDB setup for CentOS 6.x
You are correct though, IW should be already running Maria db
Many thanks
John[/QUOTE]
Not in my case. If there was a button to switch to MariaDB for MySQL, I did not see it. I realized that MariaDB wasn’t active when I tried to import a DB from a MariaDB-enabled cPanel server. As you can imagine, it failed to import. So I did the switch from MySQL to MariaDB. A second attempt in importing the DB then passed successfully upon switching.
Maybe I should have IW check it over, just to be sure, though…
Today my interworx server with 400 sites successfully upgraded tp mariadb 10.0 and everything is smooth. Will update if any problem. So far so good. All wordpress, Joomla, Magento sites are working fine.