When deploying ​Akamai​ Managed Databases powered by Aiven, you are able to select from a variety of database engines and plans. While each database engine enables you to store data, application compatibility and the way in which they store and access data can vary greatly.

Database engines

MySQL

MySQL is an industry standard relational database management system (RDMBS) that uses the SQL query language. Compared to other databases, it's relatively easy to use and its large community means there are lots of online resources available. MySQL values performance and accessibility over pure SQL compliance, so its syntax can slightly differ from strict SQL. Many popular applications (including WordPress) require MySQL or a MySQL compatible database.

MySQL Managed Databases are recommended for general-purpose websites and applications, e-commerce sites, applications employing LAMP or LEMP stacks, and for beginner database developers looking for robust online resources.

PostgreSQL

PostgreSQL is an object-relational database management system (ORDBMS) that can use SQL. It's more flexible and feature-rich than MySQL, though it's not a drop-in replacement and applications need to have built-in support for it. It also has support for more data types, including JSON, and adopts some features of NoSQL databases. While PostgreSQL is generally more challenging to implement, it can support more advanced queries and is a popular choice for enterprise applications.

PostgreSQL Managed Databases are recommended for experienced SQL developers, applications that perform complex queries, using PostgreSQL-specific features, and for business users looking for dedicated commercial support.

Database plans

Each Managed Database can be deployed with a specific set of resources. This collection of resources is called the plan. ​Akamai​ offers two plan types for Managed Databases: Shared CPU and Dedicated CPU.

Maximum number of connections

MySQL

The number of maximum simultaneous connections for MySQL depends on RAM your service plan offers:

• Plans under 4 GiB .
• Plans with 4 GiB or more .

PostgreSQL

The number of maximum simultaneous connections for PostgreSQL depends on RAM your service plan offers:

To learn more about connection pooling and maximum number of connections for PostgreSQL, see Connection pooling. For related troubleshooting, refer to Troubleshoot connection pooling problems.