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

MySQL vs Percona MySQL

ibaker

Well-known member
#1
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
 

Cool

Active member
#2
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:
I don't manage the server myself as I know nothing
 

Tracy Perry

Well-known member
#4
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
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.
 

Slavik

XenForo moderator
Staff member
#5
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
When you get access to your server, I would just install Percona from the get go rather than installing MySQL server.
 

Tracy Perry

Well-known member
#6
When you get access to your server, I would just install Percona from the get go rather than installing MySQL server.
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).
 

euantor

Well-known member
#8
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.
 

HWS

Well-known member
#9
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.
 

euantor

Well-known member
#10
Yeah, but does anybody have any real world examples of Percona/MariaDB when using XenForo? How much better is Percona at handling InnoDB?
 

Tracy Perry

Well-known member
#11
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.
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.
 

HWS

Well-known member
#12
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. :)
 

euantor

Well-known member
#13
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.
 

karll

Well-known member
#14
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.
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.
 

Arkshine

Active member
#17
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.
 

Arkshine

Active member
#19
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.
 

Tracy Perry

Well-known member
#20
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.
On a Debian OS, just pin the package.