Evaluation of open source databases

In order to extend an in-house IT service provider's database portfolio, multiple relational and non-relational open source databases are to be evaluated. Key aspects here include high availability, recovery, monitoring, security, the SQL scope, licensing, performance, and the installation and update process. MySQL, MariaDB, PostgreSQL, Firebird and Cassandra were examined. After a comparison was made using the recorded requirements, the selection was restricted to MySQL, PostgreSQL and MariaDB. These were evaluated again in greater detail, in some cases with the involvement of the manufacturers, in particular with regard to performance, monitoring and high availability. In addition, licensing models were set up for enterprise subscriptions. The project not only successfully extended the service provider's portfolio, it also acquired and documented advanced knowledge of the behavior, advantages and disadvantages of the individual relational database systems.