Should I migrate to Percona server from MariaDB/MySQL?

Question

MySQL

Good afternoon!

On the centos7 server, a couple of small projects are running on mariadb 5.5.60-1.el7_5.
Up for: 109d 21h 37m 7s (1B q [176.802 qps], 36M conn, TX: 7257G, RX: 139G)
Reads / Writes: 99% / 1%
Physical Memory : 3.7G
Data in MyISAM tables: 343.9M (Tables: 19)
Data in InnoDB tables: 1.6G (Tables: 620)

Everything seems to be working and not particularly slow, but sometimes there is a desire to optimize)) in the mysql config is not very strong. I read that Percona Server is better in every way and much easier to administer.
Is it worth switching to it? Will it be faster on such tasks? Is the transition just a dump/fill dump?

Answer 1

The question is not trivial and the transition should be done by a specialist.
The choice of the entire movement should be based, among other things, on the realities of your business / project, a team of specialists and other things.
Thus, if now everything works and suits and you personally do not see the pros / cons, and do not even know much about the settings, then I would recommend focusing on improving, developing other parts of the project in which you are in the subject.
And for moving, scaling the database, allocate a budget for a specialist when the budget appears. And so, don’t touch it, because moving is always pitfalls, time, nerves and possible downtime. Do you need it? I think no.
Therefore, do not rush.
And first of all, make a list, an easy technical task, of problems and tasks of database administration in your case. Then it can be applied to your current move, and maybe it's not so bad. And most likely, there are many tools that facilitate, automate the work in MariaDB as well.
Or maybe you don’t have enough functions in sql itself, maybe you need PostgreSQL?
No, this is not how things are done, the question is generally meaningless, except that in the comments you are waiting for fans of holivars for the sake of holivars.

Answer 2

For starters, you can upgrade to the new version 10.4
Version 5.5 has been released for a long time.
If you want to optimize, then this should be done on queries, using Slow Queries, EXPLAIN and monitoring.