Database engines and plans
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:
PostgreSQL
The number of maximum simultaneous connections for PostgreSQL depends on RAM your service plan offers:
Plan | Max connection |
---|---|
Dedicated 4GB | 100 |
Dedicated 8GB | 200 |
Dedicated 16GB | 400 |
Dedicated 32GB | 800 |
Dedicated 64GB and above | 1000 |
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.
Updated 28 days ago