Likelihood to Recommend Percona Server for MySQL covers 100% of our requirements in terms of our OLTP traffic and provides the High Availability levels required through a typical primary and 2 replica's using semi-synchronous replication. We're able to scale our writes using sharding, but a true distributed database would be a great option on top of this. In terms of OLAP traffic, we leverage columns stores available, but Percona Server fairs well
Read full review It's a great tool when building the software, the ability to add SQL and No-SQL databases. Very convenient to write the queries and generate the filtered data we require. Gives the ability to export, import databases of various formats and generate reports from them. It might not be suitable if you want the data to be seen in a visualized manner
Read full review Pros Faster than other server solutions Installation and configuration process is easy from the user's standpoint Easy to learn and good support Read full review Table filters are simple and easy to use I love the ability to install plugins: Export tables to Laravel migrations is one of our most used plugins Super easy to connect to local Docker containers, Vagrant and remote DBs through SSH Read full review Cons Better documentation A better UI Read full review It crashes CONSTANTLY. If you have more than one connection tab open and close one of them, it crashes. If you just have it open in the background, it randomly crashes. If you're using it, it randomly crashes. When you try to send a crash report, the CRASH REPORTER CRASHES. Can be a bit slow. No way that I'm aware of to query multiple databases in the same query. Read full review Usability It is easy to install and use. Using it along with Percona Monitoring and Management makes it even easier to use.
Read full review Support Rating We are using opensource so we have not used customer support.
Anil Yadav Senior Engineering Manager (Site Reliability Engineering)
Read full review It's open-source and very convenient to work with. I can easily import any database I want using a data dump and runt the queries on them to derive the data insights on the data. I might want to use Excel to visualize that, that might be one of the disadvantages.
Read full review Alternatives Considered Performance and stability sets Percona Server for MySQL apart from the rest. Percona embraces the upstream version and contributes towards the upstream version making MySQL stronger on two fronts and thus having a much larger community. Many quality contributions have been made by Percona into the base code. Percona provides great tools to support Percona Server for MySQL and this makes the monitoring and management easier
Read full review MySQL Workbench is a wonderful tool, but the routine editing of existing data is note nearly as straightforward as it is in Sequel Pro. The ability to sort a data view with a single click makes Sequel Pro my definite choice. phpMyAdmin is pretty ubiquitous, but the routine editing of existing data is much more cumbersome than it is in Sequel Pro.
Read full review Return on Investment At the performance level, it maintains and even improves other open-source databases such as MariaDB or some commercial ones such as Oracle. If we compare it with MySQL, we could have up to 50% improvement in performance. For some small companies or startups, the price of the complete solution and the support can be a bit high. Read full review The user interface is great. Since all of our computers are macOS based, we can all use it and share knowledge with our colleagues It enables me to make things in such a faster way that it enables us to spend our time with coding and providing more solutions to our clients The workflow is much improved with the import and export feature, so we don't waste time with that kind of work. Read full review ScreenShots Percona Server for MySQL Screenshots