The world's largest and most innovative businesses are turning to enterprise open source databases for mission-critical applications, with the most popular open source relational databases being MariaDB, MySQL, and Postgres.
However, while all three of these databases are open source, mature, and available in enterprise editions, there are significant differences between them — both in terms of application development as well as database administration and operations.
DBTA recently held a webinar featuring Thomas Boyd, director of technical marketing, MariaDB Corporation, who discussed the differences between MariaDB, MySQL, and Postgres.
Before choosing which relational database to use, Boyd outlined a few things to think about:
- Consider scaling and performance requirements
- Ask what DB features will you use
- Look at staff experience and expertise
- Perform data access abstraction & testing
For disaster recovery all platforms offer replication. However, EnterpriseDB doesn’t offer Incremental backups on standbys or point-in-time rollback online.
EnterpriseDB and MySQL fall short in the high availability category. Neither platform offers connection migration, session replay, or transaction replay.
Each solution has storage that is purpose-built for different use cases, Boyd said.
EnterpriseDB is heap only while MySQL and MariaDB offer InnoDB, Columnar, Aria, MyRocks, and more.
An archived on-demand replay of this webinar is available here.