1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL vs Percona MySQL

Discussion in 'Server Configuration and Hosting' started by ibaker, Apr 12, 2013.

  1. ibaker

    ibaker Well-Known Member

    I am getting a new server and was wondering about Percona. I don't manage the server myself as I know nothing about them except I use phpMyAdmin a lot for backing up, searching etc.

    So what are the pros and cons of me using Percona like is there any hardware impacts, does it require someone who really knows about it to use it, what about when installing XF or any other software that uses mySQL and what about when I migrate my sites from my old server that uses mySQL to the new server if it is set up with Percona

    Thanks for any help
  2. Cool

    Cool Active Member

    on sunday i want to win the quarter mile, next month i want to win the indy 500 the time between i want to travel with much comfort but all with the same car...wich one should i build/buy?

    you see there is no "one fits all". all have theire "pro and cons" and spec. optimizing sql-servers is a very very long-time job depending much on what software is running just on that server and so much more.

    if you have an server-admin with the right skills then only he can recommend you the way to go because only he
    can read out the information for just your server.

    my answer is based on:
  3. Mike Edge

    Mike Edge Formerly Da Bookie Mon

    Percona is a more developed and optimized SQL daemon. Once installed it is basically a MySQL drop in as config, importing and commands are exact same.
    HWS and Tracy Perry like this.
  4. Tracy Perry

    Tracy Perry Well-Known Member

    All I can tell you is that when I originally set up my VPS I was using mySQL (default Debian package) and Percona was a plug & play replacement. Took no changes to any configuration and it seems to be a little faster.
  5. Slavik

    Slavik XenForo Moderator Staff Member

    When you get access to your server, I would just install Percona from the get go rather than installing MySQL server.
  6. Tracy Perry

    Tracy Perry Well-Known Member

    Agree 100%. If I had it to do over again I would have just done that myself, but I was in a hurry to get up and running since HostGator cancelled my hosting account before they were supposed to (request was submitted at first of month to take effect at end of month - had prepaid for 2 years so it's not like they didn't have the money).
  7. CyclingTribe

    CyclingTribe Well-Known Member

    Percona is optimised for InnoDB - which is the engine type for most XF tables - and is what I chose for my latest server. As it's a direct drop-in for MySQL you may as well go for it - you've got nothing to lose. (y)

  8. euantor

    euantor Well-Known Member

    Sorry to hijack this thread, but does anybody have any insight into MariaDB vs Percona? I'm using MariaDB at the minute (been my choice for a year or more now) but I see Percona mentioned a lot here.
  9. HWS

    HWS Well-Known Member

    mariaDB is also a Drop-In replacement of MySQL. It is recommended if you use a lot of MyISAM tables, because it handles MyISAM better compared to Percona, which is a sole InnoDB specialist.

    Both of them (MariaDB and Percona) have advantages over stock MySQL and are recommended solutions.
  10. euantor

    euantor Well-Known Member

    Yeah, but does anybody have any real world examples of Percona/MariaDB when using XenForo? How much better is Percona at handling InnoDB?
  11. Tracy Perry

    Tracy Perry Well-Known Member

    Isn't mariaDB basically a fork of Percona with additional MyISAM and core improvements? From what I understood if you are using InnoDB then Percona is the better choice since it is usually a version ahead of mariaDB - who has to wait on Percona.
  12. HWS

    HWS Well-Known Member

    There are several benchmarks and real live experience reports with either Percona and MariaDB. Just Google. :)

    Or simply try it yourself. As all of them are drop-in replacements you can switch between them every day without changing your configuration. :)
  13. euantor

    euantor Well-Known Member

    Yeah, but I was asking specifically for XF. I'll stick with mariaDB for now as it's running just fine for my barely active board. I'll consider a switch to percona should I experience issues.
  14. karll

    karll Well-Known Member

    I installed MariaDB on my Ubuntu laptop for running my test installation of XF. It worked fine, but I didn't do any benchmarking tests. I'm still running standard MySQL on my live site.

    There was one issue though. This was running on Ubuntu and at one point when running the OS package upgrader it wanted to switch back the standard MySQL. There was some kind of problem with package version numbers because there was a newer version of standard MySQL than the MariaDB version. Silly, I know. Anyway, I couldn't find a way to make the upgrader accept the fact that I wanted to keep MariaDB, so eventually I just went back to standard MySQL.
  15. euantor

    euantor Well-Known Member

    Ah, no issue here as I'm using the testing version which is versioned as 10.x to stop that issue.
  16. Mike Edge

    Mike Edge Formerly Da Bookie Mon

    H mentioned in another thread on his server specs that it will have cPanel, which installs MySQL by default. Nothing yum remove can't fix though :D
    Tracy Perry likes this.
  17. Arkshine

    Arkshine Active Member

    A good answer found here : http://www.webhostingtalk.com/showpost.php?p=8550624&postcount=6

    I guess MariaDB is a good choice considering :
    • MariaDB focuses on both MyISAM and InnoDB performance, while Percona only on InnoDB.
    • MariaDB/Percona use both XtraDB, which means InnoDB performance is kind of the same.
    • XenForo is mixed with MyISAM/InnoDB, so the logic choice would be MariaDB, even if there are a lot more InnoDB tables, I would want to have good performance for both.
    p4guru likes this.
  18. HWS

    HWS Well-Known Member

    Xenforo -per default- is purely InnoDB.
  19. Arkshine

    Arkshine Active Member

    Never checked, looking at the tables, it would seem most for MyISAM came from Add-on ; well, most forum will run many add-ons ; so I still thinks MariaDB is a good choice. Unless Percona has something which makes XF running better or something, I'm not sure what you would choose Percona.
  20. Tracy Perry

    Tracy Perry Well-Known Member

    On a Debian OS, just pin the package.

Share This Page