Deployment variants¶

Percona Distribution for MySQL provides two deployment variants: one is Percona Server for MySQL-based and another one is Percona XtraDB Cluster-based. Each deployment is available via its own repository and includes the base server (Percona Server for MySQL or Percona XtraDB Cluster) and components. The table below lists what components are available with each server:

Components	Percona Server for MySQL	Percona XtraDB Cluster
Orchestrator	YES	NO
HAProxy	NO	YES
ProxySQL	YES	YES
Percona XtraBackup	YES	YES
Percona Toolkit	YES	YES
MySQL Shell	YES	NO
MySQL Router	YES	NO

What deployment variant to choose?¶

The Percona Server-based deployment variant with asynchronous replication utilizes the primary / secondary replication model. It enables you to create geographically distributed infrastructures with the support for disaster recovery. However, this deployment variant does not guarantee data consistency on all nodes at the given moment and provides high availability of up to 4 nines.

The Percona Server-based deployment variant with Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Percona Server for MySQL-based deployment with Group Replication offers a high grade of high availability (4-5 nines) and almost instant fail over when associated with a proxy.

The Percona XtraDB Cluster-based deployment variant guarantees data consistency on all nodes and zero data loss. The Percona XtraDB Cluster-based deployment provides a high grade of high availability (4-5 nines) and almost instant failover.