Percona vs. Leading Database Solutions
See how Percona stacks up
- Server
- Backup
- Components
-
Monitoring &
Management -
Kubernetes
Operator - DBaaS
-
Support and
Services
| Server Features | Percona Server for MySQL | MySQL Community Server | MySQL Enterprise Server |
| Open source, freely available software | |||
| High availability | |||
| MyRocks storage engine | |||
| Audit | |||
| Encryption functions | |||
| Data at Rest Encryption | With Integrations: AWS, KMS, Hashicorp, KMIP | Basic functionality only | With integrations: AWS, KMS, Hashicorp, KMIP |
| External authentication | LDAP, FIDO, Kerberos, PAM | LDAP, FIDO, Kerberos, PAM, Windows | |
| Thread pool | |||
| Data masking | |||
| See full feature comparison | |||
| Backup Features | Percona Distribution for MySQL | MySQL Community | MySQL Enterprise Edition |
| Back up to AWS cloud | |||
| Back up to GCP cloud | |||
| Back up to Azure cloud | |||
| Back up to OpenStack storage | |||
| Back up to MinIO (K8s storage) | Basic functionality only | ||
| Physical backup | |||
| Logical backup | |||
| Selective backup | With logical backups | With logical backups | |
| Point-in-time recovery | |||
| Hot non-backing backups |
| Components | Percona Distribution for MySQL | MySQL Community | MySQL Enterprise Edition |
| Load balancer | ProxySQL, MySQL Router, HAProxy | MySQL Router | MySQL Router |
| Failover automation | Orchestrator, Percona XtraDB Cluster, InnoDB Cluster | InnoDB Cluster | InnoDB Cluster |
| Scripts to automate DBA tasks | MySQL Shell, Percona Toolkit | MySQL Shell | MySQL Shell |
| Client and code editor | |||
| InnoDB Cluster (Group Replication) | |||
| Percona XtraDB (Galera Cluster) | |||
| Asynchronous replication |
| Monitoring and Management | Percona Monitoring and Management (PMM) | MySQL Workbench | MySQL Enterprise Monitor |
| Open source | |||
| Specialized dashboards: trends, replication, I/O, query analyzer, etc. | Limited | ||
| Performance Schema/Performance Schema Waits Analysis | Limited | ||
| InnoDB metrics | Limited | ||
| MyRocks storage engine metrics | |||
| Query analysis | Limited | ||
| Table statistics | Limited | ||
| User statistics | Limited | ||
| Advisors and alerting |
| Kubernetes Operator | Percona Operator for MySQL | MySQL Operator for Kubernetes | MySQL Operator for Kubernetes |
| Integrated multi-cloud deployment configuration | |||
| Automated upgrade | |||
| Scheduled backups | |||
| Incremental backups | |||
| Point-in-time recovery | |||
| Monitoring | Percona Monitoring and Management | ||
| Load balancing | ProxySQL and HAProxy | MySQL Router | MySQL Router |
| Transport encryption | |||
| Data at Rest Encryption | |||
| RedHat® OpenShift® certified |
| DBaaS | Percona Everest (Beta) | Not available | Oracle Enterprise Database Services |
| On-premises / hybrid | Available via third-party cloud providers | ||
| Cloud | Available via third-party cloud providers | Oracle Cloud Infrastructure |
| Support and Services | Percona for MySQL | MySQL Community | MySQL Enterprise |
| Post-EOL support for MySQL 5.7 | |||
| Multi-database support | Available with third-party vendors like Percona | ||
| Managed services | Available with third-party vendors like Percona | ||
| Tech-agnostic consulting | Available with third-party vendors like Percona |
Kindly switch to the desktop view for a full-page display.
Alternatively, access the complete comparison by downloading the PDF
- Server
- Backup
-
Advanced
Features - Security
-
Monitoring and
Management -
Kubernetes
Operator - DBaaS
-
Support and
Services
| Server Features | Percona Server for MongoDB | MongoDB Community Edition | MongoDB Enterprise Advanced | MongoDB Atlas |
| Fully compatible with MongoDB Community Server | ||||
| Document data store | ||||
| Default storage engine | WiredTiger | WiredTiger | WiredTiger | WiredTiger |
| In-memory storage engine | Above M40 sized systems Atlas memory caching providing in-memory capable performance | |||
| Supported deployment types | On-premises, cloud, hybrid | On-premises, cloud, hybrid | On-premises, cloud, hybrid | Cloud |
| Multiple availability zones | ||||
| Multiple regions | ||||
| Multiple cloud availability | ||||
| Redundancy via replica sets | ||||
| Built-in replication, up to 50 replica set members | ||||
| Automatic failover sharding |
| Backup Features | Percona Backup for MongoDB | MongoDB Community Edition | MongoDB Enterprise Advanced | MongoDB Atlas |
| Open source backup | ||||
| Binary database export (logical backup) | ||||
| Built-in point-in-time recovery support | ||||
| Physical backup | ||||
| Incremental backup (physical) | ||||
| Backup management interfaces | -Percona Backup for MongoDB (CLI) -Percona Monitoring and Management -mongodump / mongorestore (CLI) | -mongodump / mongorestore (CLI) | -Ops Manager -Cloud Manager -mongodump / mongorestore (CLI) | -Atlas backups -mongodump / mongorestore (CLI) |
| Sharded collections restores supported | ||||
| Cluster-to-cluster sync |
| Advanced Features | Percona Distribution for MongoDB | MongoDB Community Edition | MongoDB Enterprise Advanced | MongoDB Atlas |
| Multiple programming language support | ||||
| BI Connector | ||||
| Live resharding | ||||
| Time series collections | ||||
| Integrated advanced search | ||||
| Advanced operators, functions, and aggregation pipeline |
| Security Features | Percona Distribution for MongoDB | MongoDB Community Edition | MongoDB Enterprise Advanced | MongoDB Atlas |
| Queryable encryption | Explicit encryption | Explicit encryption | Automatic encryption Explicit encryption | Automatic encryption Explicit encryption |
| Data At Rest Encryption | ||||
| Key management compatibility | Hashicorp Vault KMIP Locally managed key files | KMIP Locally managed key files | AWS KMS Google Cloud KMS Azure Key Vault Locally managed key files | |
| Data-in-transit encryption | SSL/TLS | SSL/TLS | SSL/TLS | SSL/TLS |
| Client-Side Field Level Encryption | Explicit encryption | Explicit encryption | Automatic encryption Explicit encryption | Automatic encryption Explicit encryption |
| Authentication / authorization | SCRAM X.509 LDAP Kerberos | SCRAM X.509 | SCRAM X.509 LDAP Kerberos Fine-grained auditing | SCRAM X.509 LDAP Fine-grained auditing / Field-level redaction |
| Auditing | ||||
| Log redaction | ||||
| Role-based access control | ||||
| FIPS-140 module |
| Monitoring, Management, and Alerting | Percona Monitoring and Management (PMM) | MongoDB Community Edition | MongoDB Enterprise Advanced | MongoDB Atlas |
| Open source monitoring | ||||
| Configuration | ||||
| Automated patches and upgrades | ||||
| Alerting | ||||
| Alternative alerting methods | Email Webhooks Messenger integration External tool integration | Email HTTPS endpoints Messenger integration SNMP External tool integration | Email HTTPs endpoints Messenger integration SNMP External tool integration | |
| Index and schema recommendations | ||||
| Performance Advisor | ||||
| Query Analyzer |
| Kubernetes Operator | Percona Operator for MongoDB | MongoDB Community Edition | MongoDB Enterprise Advanced | MongoDB Atlas |
| Multi-cloud | ||||
| Monitoring | Percona Monitoring and Management | Ops Manager Cloud Manager | Atlas | |
| Backup and restores | Scheduled backups On-demand backups Point-in-time recovery Physical backups Incremental backups through Oplog / PITR | Scheduled backups On-demand backups Point-in-time recovery | Scheduled backups On-demand backups Point-in-time recovery | |
| Topologies | Hidden node Arbiter node Replica set Sharded cluster | Replica set | Hidden node Arbiter node Replica set Sharded cluster | Hidden node Arbiter node Replica set Sharded cluster |
| DBaaS | Percona Everest (Beta) | MongoDB Community Edition | MongoDB Enterprise Advanced | MongoDB Atlas |
| On-premises / hybrid | ||||
| Cloud | AWS | AWS GCP Azure | AWS GCP Azure |
| Support and Services | Percona for MongoDB | MongoDB Community Edition | MongoDB Enterprise Advanced | MongoDB Atlas |
| Multi-database support | ||||
| Managed services | ||||
| Tech-agnostic consulting |
Kindly switch to the desktop view for a full-page display.
Alternatively, access the complete comparison by downloading the PDF
- Distribution
- K8s Operator
- DBaaS
- Support and Services
| Distribution Components | PostgreSQL Community | Percona for PostgreSQL | EDB | Crunchy Data |
| Open source and free from vendor lock-in |
All components are open source |
|||
| Enterprise features | With expertise in choosing and testing the right extensions |
Production-ready out of the box |
Commercial software |
Commercial software |
| Distribution component testing | Components are tested separately |
Components are tested to work together |
Components are tested to work together |
Components are tested to work together |
| Operational support and bug fixes | Strong global community support |
Additional support from Percona Community, production support from Percona Services |
Via commercial support |
Via commercial support |
| High availability, load balancing, and replication | Various extensions |
Patroni, HAProxy |
EDB Postgres Distributed |
With commercial version |
| Connection pooling | Various extensions |
pgpool2, PgBouncer |
||
| Backup and restore | Various extensions |
pgBackRest |
||
| Transparent Data Encryption (TDE) | Various extensions |
pg_tde - extension created and supported by the Percona team |
Available for a fee in EDB Postgres Advanced Server and EDB Postgres Extended Server |
Available for a fee in Crunchy Hardened PostgreSQL |
| Authentication | Various methods |
Support for various Authentication methods, including LDAP |
Support for various Authentication methods, including LDAP |
Support for various Authentication methods, including LDAP |
| Sharding support for on-premises and private cloud infrastructures | Various extensions |
Coming soon via Citus integration |
||
| Time series database support | Various extensions |
Coming soon via TimescaleDB integration |
||
| Spacial data handling | PostGIS |
PostGIS |
PostGIS |
PostGIS |
| Monitoring and observability | Various extensions |
Percona Monitoring and Management, an open source monitoring solutionbased on Grafana pg_stat_monitor |
Postgres Enterprise Manager built on pgAdmin. Available by subscription |
Prometheus stack and pgMonitor |
| Audit logging | Various extensions |
pgAudit, pgBager, pg_gather |
edb_audit_statement |
pgAudit |
| Feature | Stackers | Percona Operator for PostgreSQL | Crunchy Data | EDB (CloudNativePG) | Zalando | KubeDB for PostgreSQL |
| Generic | ||||||
| Open source license | AGPL 3 | Apache 2.0 | Apache 2.0, but images are under Developer Program | Apache 2.0 | MIT | Open core |
| Kubernetes conformance | Various versions are tested | Various versions are tested | Various versions are tested | Various versions are tested | AWS EKS | None |
| Cluster-wide deployment | Yes | Yes | Yes | Yes | Yes | Yes |
| Network exposure | Yes | Yes | Yes | Yes | Yes | Yes |
| Maintenance | ||||||
| Operator upgrade | Yes | Yes | Yes | Yes | Yes | Image change |
| Database upgrade | Manual | Automated and safe | Manual | Manual | Manual | Manual image change |
| Compute scaling | Horizontal and vertical | Horizontal and vertical (automation coming soon) | Horizontal and vertical | Horizontal and vertical | Horizontal and vertical | Enterprise only |
| Storage scaling | Manual | Manual (automation coming soon) | Manual | Manual | Manual, automated for AWS EBS | Enterprise only |
| PostgreSQL Topologies | ||||||
| Warm standby | Yes | Yes | Yes | Yes | Yes | Yes |
| Hot standby | Yes | Yes | Yes | Yes | Yes | Yes, but without Patroni. KubeDB detects if some node failed and switches the label. Kubernetes service has these labeled as selectors. |
| Connection pooling | Yes | Yes | Yes | Yes | Yes | No |
| Delayed replica | No | No | No | No | No | No |
| Tablespaces | No | Yes | Yes | No | No | No |
| Backup | ||||||
| Scheduled backups | Yes | Yes | Yes | Yes | Yes | Yes, through Stash and in Enterprise version only |
| WAL archiving | Yes | Yes | Yes | Yes | Yes | Yes, through WAL-G |
| PITR | Yes | Yes | Yes | Yes | Yes | Yes, see above |
| GCS | Yes | Yes | Yes | Yes | Yes | No |
| S3 | Yes | Yes | Yes | Yes | Yes | Yes, via Stash |
| Azure | Yes | No | Yes | Yes | Yes | No |
| Monitoring | ||||||
| Solution | Exposing metrics in Prometheus format | Percona Monitoring and Management | Prometheus stack and pgMonitor | Exposing metrics in Prometheus format | Sidecars | Monitoring through Prometheus Operator |
| Misc | ||||||
| Customize PostgreSQL configuration | Yes | Yes | Yes | Yes | Yes | Yes, ConfigMaps |
| Helm | Yes | Yes | Yes | Yes | Yes | Yes |
| Transport encryption | Yes | Yes | Yes | Yes | Yes | No |
| Data at Rest Encryption | Through storage class | Through storage class | Through storage class | Through storage class | Through storage class | Through storage class |
| Create users/roles | Yes | Yes, limited | Yes | Yes | Yes, limited | Yes, someone can build and run their own docker image and PG version |
| DBaaS | PostgreSQL Community | Percona for PostgreSQL | EDB | Crunchy Data |
| On-premises, hybrid cloud | N/A | Percona Everest | ||
| Self-managed | N/A | Percona Everest | ||
| Fully managed public cloud | Various fully managed public cloud solutions: Cloud SQL, Amazon RDS, Aiven | Percona Everest with Percona Services | BigAnimal | Crunchy Bridge |
| Support and Services | PostgreSQL Community | Percona for PostgreSQL | EDB | Crunchy Data |
| Community support | Global PostgreSQL community | Global PostgreSQL community and Percona Community | Global PostgreSQL community | Global PostgreSQL community |
| Multi-database support | Only PostgreSQL | 24/7 support for original PostgreSQL, MySQL, MongoDB, MariaDB, and Percona forks | Only PostgreSQL and EDB forks | Only PostgreSQL and Crunchy Data forks |
| Managed services | Available through third-party providers | Round-the-clock database management for PostgreSQL, MySQL, MongoDB, MariaDB, and Percona forks | Via BigAnimal | Via Crunchy Bridge |
| Consulting | Available through third-party providers | Consulting for high availability set up, complex performance issue resolution, and database design challenges for PostgreSQL, MySQL, MongoDB, and their forks | Professional services for EDB Postgres software and original PostgreSQL | Not available |
| Training | Available through third-party providers | Training on PostgreSQL, MySQL, MongoDB, MariaDB, and their forks | Original PostgreSQL and EDB Postgres software | Available to Crunchy Data subscription customers |
Kindly switch to the desktop view for a full-page display.
Alternatively, access the complete comparison by downloading the PDF
-
Distribution and
Components - Backup
-
Monitoring, Management,
and Analytics - Cloud Native
-
Support and
Services
| Distribution and Components | Percona Software for MySQL | MariaDB Community | MariaDB Enterprise |
| Open source | |||
| Load balancing and routing | ProxySQL HAProxy MySQL Router | ProxySQL HAProxy | MariaDB MaxScale* |
| Database firewall | ProxySQL | ProxySQL | MariaDB MaxScale* |
| Scalability - clustering | MySQL Group Replication Percona XtraDB Cluster (based on a further engineered Galera Cluster) | MariaDB with Galera Cluster | MariaDB Enterprise Cluster (requires the deployment of MariaDB MaxScale)* |
| Security - data masking | Data masking plugin for MySQL | ProxySQL | MariaDB MaxScale* |
| Security - encryption | Data at Rest Encryption with external key management integrations | Data at Rest Encryption with external key management integrations | Data at Rest Encryption with external key management integrations |
| Security - auditing | Percona Audit Plugin | MariaDB Audit Plugin | MariaDB Audit Plugin |
| Distributed SQL | |||
| Additional storage engines | MyRocks: storage savings | No production-ready storage engine | No production-ready storage engine |
| Backup Features | Percona Software for MySQL | MariaDB Community | MariaDB Enterprise |
| Backup | Percona XtraBackup | MariaBackup (fork of Percona XtraBackup) | MariaBackup (fork of Percona XtraBackup) and MariaDB Enterprise Backup* |
| Monitoring, Management, and Analytics | Percona Software for MySQL | MariaDB Community | MariaDB Enterprise |
| Monitoring and management | Percona Monitoring and Management | ||
| Analytics | Clickhouse integration | MariaDB ColumnStore |
| Cloud Native | Percona Software for MySQL | MariaDB Community | MariaDB Enterprise |
| Kubernetes | Percona Operator for MySQL | ||
| DBaaS | Percona Everest (Beta) | Available through third-party cloud providers |
| Support and Services | Percona for MySQL | MariaDB Community | MariaDB Enterprise |
| Multi-database support | Available through third-party cloud providers | ||
| Managed services | Through MariaDB Cloud | Through MariaDB Cloud | |
| Tech-agnostic consulting | Available through third-party providers like Percona |
Kindly switch to the desktop view for a full-page display.
Alternatively, access the complete comparison by downloading the PDF
Need help choosing the right database solution for your business?
Our experts are ready to answer any questions you may have.
By submitting my information I agree that Percona may use my personal data in sending communication to me about Percona services. I understand that I can unsubscribe from the communication at any time in accordance with the Percona Privacy Policy. This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.