ClickHouse vs. Percona Server for MySQL

The most important thing when using ClickHouse is to be clear that the scenarios in which you want to use it really are the right ones. Many users think that when a database is very fast for a specific use case, it can be extrapolated to other contexts (most of the time different) in which a previous analysis has not been carried out.

ClickHouse is an analytical database, as such, it should be used for such purposes, where the information is stored correctly, the data volumes are really large and the queries to be performed are not the typical traditional queries on several columns with multiple aggregations. ClickHouse is not the solution for this.

On the other hand, if your case is not one of the above, it is quite possible that ClickHouse can help you. Where ClickHouse shines is when you are looking for aggregation over a particular column in large volumes of data.

Incentivized

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

• Opensource
• High performance
• Multiple engines to adapt user cases
• Easy configuration of data replication

Incentivized

• Faster than other server solutions
• Installation and configuration process is easy from the user's standpoint
• Easy to learn and good support

Incentivized

• Avro data manipulation
• Kafka consistency
• DDL operations errors (by replica configuration)

Incentivized

• Better documentation
• A better UI

It is easy to install and use. Using it along with Percona Monitoring and Management makes it even easier to use.

Incentivized

We are using opensource so we have not used customer support.

ClickHouse was not compared to them as a competitor but as the ideal partner to complete an information analysis system, providing users with the most complete and efficient tools. Therefore, in this case it was considered that it would be the ideal candidate due to its characteristics compared to the other competitors.

Incentivized

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

• Queries that used to take more than 2 minutes now take less than 1 second
• Possibility to analyze use cases in real time (before was impossible)
• The applications are more complete and the users decisions are better

Incentivized

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

Incentivized