Page 1 of 2 12 LastLast
Results 1 to 15 of 19

Thread: MariaDB

  1. #1
    Join Date
    Aug 2013
    Location
    On the Internet and Perfectionist World
    Posts
    89
    Points
    3,442
    Level
    24

    Thumbs up MariaDB

    Hi guys,

    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!

    Name:  Screenshot 2014-05-30 17.06.23.png
Views: 395
Size:  26.7 KB
    Name:  Screenshot 2014-05-31 16.39.46.png
Views: 411
Size:  19.8 KB
    Last edited by Shyuan; 05-31-2014 at 12:39 PM.

  2. The Following 2 Users Say Thank You to Shyuan For This Useful Post:


  3. #2
    Join Date
    Apr 2012
    Posts
    2,179
    Points
    24,207
    Level
    68
    Hi shyuan

    Thanks for Sharing and please could you do another update in a month or so, with your thoughts.

    Excellent domain myforum.com I thought

    Have a lovely weekend

    Many thanks

    John

  4. #3
    Join Date
    Aug 2013
    Location
    On the Internet and Perfectionist World
    Posts
    89
    Points
    3,442
    Level
    24
    Quote Originally Posted by d2d4j View Post
    Hi shyuan

    Thanks for Sharing and please could you do another update in a month or so, with your thoughts.

    Excellent domain myforum.com I thought

    Have a lovely weekend

    Many thanks

    John
    John, you misunderstood the "myforum.com" it's just masking my true domain, that domain is not mine at all! :P

    I will definitely update this thread about a month later with a graph again to show how stable MariaDB is!

  5. #4
    Join Date
    Apr 2012
    Posts
    2,179
    Points
    24,207
    Level
    68
    Hi shyuan

    Doh sorry, I can be slow at times sorry.

    Many thanks

    John

  6. #5
    Join Date
    Aug 2013
    Location
    On the Internet and Perfectionist World
    Posts
    89
    Points
    3,442
    Level
    24
    Quote Originally Posted by d2d4j View Post
    Hi shyuan

    Doh sorry, I can be slow at times sorry.

    Many thanks

    John
    Not at all John, you help us a lot most of the time!

  7. #6
    Join Date
    Oct 2013
    Location
    Alcester, UK
    Posts
    152
    Points
    2,227
    Level
    19
    Looks great can you update us like John said in a month or two, I might consider moving Licensecart over to MariaDB if it does a great job.
    Michael Dance
    Licensecart Certified Distribution for Blesta, Interworx, KernelCare, CraftSRV, Softaculous, SolusVM, LiteSpeed & SSLs.
    Free Softaculous & 50% off KernelCare with every InterWorx license bought with us. We pride ourselves by being the cheapest External provider.
    Need Help? Check out the InterWorx FAQs or check out our Knowledgebase. In the InterWorx family, you're never alone!


  8. The Following User Says Thank You to Licensecart For This Useful Post:


  9. #7
    Join Date
    Apr 2012
    Posts
    2,179
    Points
    24,207
    Level
    68
    Hi

    It would be interesting to see which compares better, mariadb or perconna

    We do not have a ram issue on our systems, but MySQL does use a lot of CPU I think from memory.

    Many thanks

    John

  10. The Following User Says Thank You to d2d4j For This Useful Post:


  11. #8
    Join Date
    Sep 2014
    Location
    Sydney, Australia
    Posts
    26
    Points
    1,261
    Level
    14
    Sorry to open an old post, Anyone know how this went?
    Australian Cloud Hosting inodecloud.com
    +Expert Cloud Engineers +99.95% Uptime +30Day Retrievable Backup +Blazingly Fast Cloud Servers
    +AWS Engineers +DR/HA +GitHub

  12. #9
    Join Date
    Apr 2012
    Posts
    2,179
    Points
    24,207
    Level
    68
    Hi inodecloud

    I know it's possible (sorry, obviously given this post) but shyuan has never updated the post.

    On a side note, I believe I read IW are looking at using Mariadb, along side perconna

    I could be entirely wrong though, so I apologise in advance

    Many thanks

    John

  13. #10
    Join Date
    Sep 2014
    Location
    Sydney, Australia
    Posts
    26
    Points
    1,261
    Level
    14
    Hooray! cant wait for MariaDB or Percona to be part of interworx.
    Australian Cloud Hosting inodecloud.com
    +Expert Cloud Engineers +99.95% Uptime +30Day Retrievable Backup +Blazingly Fast Cloud Servers
    +AWS Engineers +DR/HA +GitHub

  14. The Following User Says Thank You to inodecloud For This Useful Post:


  15. #11
    Join Date
    Apr 2012
    Posts
    2,179
    Points
    24,207
    Level
    68
    Hi kappy

    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

    I'm looking forward to 5.1 release and centos 7.

    Many thanks

    John

  16. #12
    Join Date
    Oct 2013
    Location
    Alcester, UK
    Posts
    152
    Points
    2,227
    Level
    19
    Quote Originally Posted by d2d4j View Post
    Hi inodecloud

    I know it's possible (sorry, obviously given this post) but shyuan has never updated the post.

    On a side note, I believe I read IW are looking at using Mariadb, along side perconna

    I could be entirely wrong though, so I apologise in advance

    Many thanks

    John
    Yeah MariaDB in Centos 7, Perconna is for the InterWorx stuff. Not sure if 5.1 stuff is for both Centos 7 and Centos 6.
    Michael Dance
    Licensecart Certified Distribution for Blesta, Interworx, KernelCare, CraftSRV, Softaculous, SolusVM, LiteSpeed & SSLs.
    Free Softaculous & 50% off KernelCare with every InterWorx license bought with us. We pride ourselves by being the cheapest External provider.
    Need Help? Check out the InterWorx FAQs or check out our Knowledgebase. In the InterWorx family, you're never alone!


  17. #13
    Join Date
    Apr 2012
    Posts
    2,179
    Points
    24,207
    Level
    68
    Hi mike

    Sorry, I thought I'd read 5.1 is for centos6 as centos7 next beta will not be released until after 5.1.

    Many thanks

    John

  18. The Following User Says Thank You to d2d4j For This Useful Post:


  19. #14
    Join Date
    Aug 2013
    Location
    On the Internet and Perfectionist World
    Posts
    89
    Points
    3,442
    Level
    24
    This is literally a dream come true

  20. #15
    Join Date
    Feb 2015
    Posts
    78
    Points
    1,804
    Level
    17
    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
    Code:
    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
    ★ Ramon Reyes @ EidolonHost
    ★ Shared, Reseller, VPS and Dedicated Servers.
    ★ Need more stuff? Ask us about custom configurations!
    ★ Authorized Blesta and InterWorx License Reseller! See Web Host Licenses

  21. The Following User Says Thank You to Keiro For This Useful Post:


Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •