MySQL vs Percona MySQL

[ibaker]

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]

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

 

[Mike Edge]

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.

 

[TPerry]

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]

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.

 

[TPerry]

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).

 

[CTXMedia]

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.

http://www.percona.com/software/percona-xtradb

 

[euantor]

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]

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]

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

 

[TPerry]

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]

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]

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]

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.

 

[euantor]

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

 

[Mike Edge]

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

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

 

[Arkshine]

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.

 

[HWS]

Xenforo -per default- is purely InnoDB.

 

[Arkshine]

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.

 

[TPerry]

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.