search

Mins / TuxLite

A complete LAMP and LNMP setup script for Debian or Ubuntu
http://tuxlite.com
253 stars 112 forks source link

Percona Server option #13

Closed wizonesolutions closed 11 years ago

wizonesolutions commented 11 years ago

Can Percona Server also be offered as an alternative to MySQL? It supposedly helps performance and is binary-compatible like MariaDB. It doesn't, in my experience, hurt performance at least. I've started to move over to it.

wizonesolutions commented 11 years ago

For what it's worth, actually, simply adding the APT repos for Percona as per http://www.percona.com/doc/percona-server/5.5/installation/apt_repo.html and then specifying percona-server-server-5.5 and percona-server-client-5.5 in MISC_PACKAGES works fine. aptitude appears to figure out how to resolve the conflict, and Percona Server prevails. That's what I did for the server setup that motivated me to post this issue (just in case people are interested in the interim).

Mins commented 11 years ago

Thanks for the details with the installation.

I'm OK with adding this as a feature. However, it would be nice to know why you prefer Percona over MariaDB since most distributions are selecting MariaDB (instead of Percona) to replace MySQL.

If I'm not mistaken, MariaDB uses the XtraDB storage engine from Percona and is faster with MyISAM, making it the better option among the two.

By the way, MariaDB has been implemented in the recent commits, but I've yet to package it for release.

wizonesolutions commented 11 years ago

Ah, I didn't know that about MariaDB. I had the impression it was just more well-known but was unsure of the technical specifics. On Apr 24, 2013 5:09 PM, "Mins" notifications@github.com wrote:

Thanks for the details with the installation.

I'm OK with adding this as a feature. However, it would be nice to know why you prefer Percona over MariaDB since most distributions are selecting MariaDB (instead of Percona) to replace MySQL.

If I'm not mistaken, MariaDB uses the XtraDB storage engine from Percona and is faster with MyISAM, making it the better option among the two.

By the way, MariaDB has been implemented in the recent commits, but I've yet to package it for release.

— Reply to this email directly or view it on GitHubhttps://github.com/Mins/TuxLite/issues/13#issuecomment-16936905 .

Mins commented 11 years ago

Yep, that seems to be the case with MariaDB. Perhaps give it a try and see if the performance is to your expectations?

wizonesolutions commented 11 years ago

Should be fairly easy to swap out Percona (they all conflict with each other, I think), so I will do that when I get a chance and see if I notice any difference. Any recommended way of testing? ab or something? I'm not too concerned about it being a perfect test, just a decent way of comparing apples to apples.

wizonesolutions commented 11 years ago

This is an interesting thread too: http://www.webhostingtalk.com/showthread.php?t=1236272

It seems like MariaDB lags a little behind Percona in InnoDB performance, but it merges in the work Percona does one version later. InnoDB performance does have relevance for me because I mostly work on Drupal sites, but it looks like MariaDB is worth another look (haven't had any bad experiences with it either).

Mins commented 11 years ago

Ah, SysBench appears to be the tool you're looking for to perform your tests.

As for the performance figures, it doesn't seem to matter much whether you use MySQL, MariaDB or Percona for small to medium (majority) workloads. The graphs are fairly equal from the benchmarks I've seen [1] if you compare only the lighter workloads ( e.g. <16 threads, <24GB RAM, etc).

[1] http://blog.mariadb.org/category/performance/