Percona XtraDB Cluster

Pros: This tool offers automatic provisioning of nodes thanks to the Incremental Snapshot Transfer functionality that allows saving the last transactions so that when a node is left out of the cluster and rejoins some time later, it will synchronize with the rest of the nodes, reading the pending transactions.

A cluster configured with Percona XtraDB Cluster allows the inclusion of three or more servers in a single logical structure where all have all the data and the same reading and writing capacities.

These clusters ensure that a query can be resolved by any of the servers without the need for remote access, and in the event that a node fails, the cluster will continue to operate in high availability.

Cons: The replication of the information of the nodes sometimes does not get to have a good performance since the update is carried out synchronously. This means that the update time of a node may be higher than in the other nodes.

Overall: Percona XtraDB Cluster allows the creation, administration and monitoring of the cluster of several Percona Server or MySQL servers, thus offering a response to the scalability requirements of those applications that see an increase in their number of transactions.

Pros: Migrating to PXC 5.7 helped fix our performance issues as previously our production environment could not handle the traffic at our peaks. Since moving to PXC, our environments are performing much better.

Cons: The overall system is a little more complicated to manage than our previous environment.

Overall: Overall, we have been very happy with our performance since switching to PXC 5.7. Our databases can handle a much higher level of simultaneous transactions than before.

Pros: It has the ability to be powerful in configuration options.
Great solutions for HA setups in MySQL
Percona XtraDB Cluster and the company behind it outperform the industry.

Cons: Nothing in the cons works really well for me. Great application.

Overall: I am recommending, entirely this database for small startup that has incredibly intense data workloads. It's very Simple to configure, easy enough to grasp administrative tasks.

Pros: Open Source, One of the best reasons for using Percona XtraDB Cluster.

Cons: Documentation can be a little better if aimed towards beginners.

Overall: Easy to use and 0 deploy delays.

Pros: Percona XtraDB Cluster is a one stop solution for all RDBMS with its High Availability and SST feature.

Cons: Need to improvise in handling bulk update and delete transactions.

Overall:

Pros: Percona XtraDB Cluster is a fast , reliable and stable product
it has many good features and really help in clustering of data.

Cons: Sometimes it has less community support and documentation or learning over the web.

Overall: Percona XtraDB Cluster is overall a good product with various features and services which can be used for cluster.

Pros: The dashboard is really helpful and easy to use to analyse, is very secure and open source. It also has a dark theme.

Cons: Needs docker set up to install, no native support.

Overall: Overall this is a pretty solid way for Db analysis. It is easy to use, secure, open source, has great optimization as well.

Pros: PXC allowed our business to ramp up without the usual challenges in scaling up. The product is an excellent drop-in replacement and required little change in our operation during integration and management.

Cons: As a mature product, the documentation and related articles are useful but don't always feel fresh and current.

Overall: This is a fully featured product designed to scale and work without problems. It is regularly updated and Percona can be relied upon for support if you have complex needs or challenges. I have no difficulty recommending this to those who want a more feature rich environment without losing on reliability.

Pros: Percona XtraDB Cluster provide high availability to applications. It is best option at low investment with high performance.
One stop solution for high availability and scalability.

Cons: Commit issues on nodes.
Split brain.

Overall: Good clustering solutions.

Pros: I have used Percona XtraDB Cluster as a synchronous cluster solution for quite a long time now and it's stable, very stable. I have also used other Galera implementations and they had frequent glitches and problems. But PXC just works.

Opinions expressed here are my own and not the opinions of my employer.

Cons: Only 2 cons;
1. PXC cannot be faster than your network. Try to keep the latency between the nodes low or your performance will decrease.
2. Online DDL is not longer online in a cluster. Any DDL will impact the rest of your operations, plan with care.

Opinions expressed here are my own and not the opinions of my employer.

Overall: I have used Percona XtraDB Cluster for the last 4-5 years and I think it's a great product. If you are lucky enough to have Percona Support it's a winning combination. But even if you don't have the budget and want to spend nothing, use it. I really think is the best Galera implementation out there!

Opinions expressed here are my own and not the opinions of my employer.

Pros: XtraDB Cluster offers lot of Enterprise features for free like encryption at rest, hot backup. Comparing to MariaDB it offers better documentation IMHO.

Cons: To be honest I cannot find even one. I tried to use XtraDB Cluster Operator but there is no feature like multi-region so I had to build everything manually.

Overall: Software is very good and pretty mature, I use it as multi-region DB solution. We decided to use it due to free features comparing to for example Cockroachdb.