A very interesting topic of server administration is the choice of a nice MySQL-Server for high performance purposes and solutions.
Many people underestimate this choice, which is surely a huge mistake! The correct research before setting up your database server is the first step into a really good direction.
Let us talk about the MySQL-Server solution of Percona a bit. This is my personal choice and I will give you some basic background information and nice to knows about it.
I recommend at least basic knowledge of MySQL to understand most of the things explained in the following part.
Most important reasons to choose Percona instead of “standard” MySQL solution:
Before I will go into detail, I want to show you a graphic from Percona.com which shows where the story goes.
Stability here does not mean that the server is free of crashes, because you can truly say that this counts for all MySQL versions too. It means the stability on which Percona answeres database questions or executes queries and prepared statements. This really is a must have if you want to run powerul applications without lags or huge overload. Of course the benefit depends on the usage of your database server (READ- or WRITE-heavy), but this can never be a disadvantage. In the graphic above you can clearly see the amazing difference between MySQL- and Percona-Server!
In my experience, with WRITE-heavy databases, it is really needed to guarantee a stable and consistent service.
As you can see in the graphic above and read in the article on Percona site, it is 40% faster than MySQL! To repeat this: Without doing anything you simply get much more efficiency! Now imagine this combined with Server SDDs and more performance changes you did manully. I think every additional word is wasted here.
As if the over-all performance was not enough, all InnoDB users will be happy to hear that Percona has been doing a great job in tuning InnoDB perfomance too. They developed a high performance InnoDB clone, called XtraDB. You can see the huge performance impact in following graphic from Percona.com:
There are more reasons to use Percona Server of course, but I think the most doubts are killed by explaining stability and performance advantages above. I hope you enjoyed reading this and maybe switch to Percona Server too. If you have feedback, regards or corrections please let me know!
Any time soon a tuturial for installing and setting up Percona will follow. Additionally I will show you how to optimize and tune your Percona- or MySQL-Server on your purposes in another tutorial.