Multiple updates have been made to the Managed Databases service with this release.

Added

PGBouncer support for PostgreSQL

To improve performance and scalability of your PostgreSQL database clusters, you can configure connection pooling, using features offered by our PostgreSQL database partner, Aiven. A PGBouncer pooler uses fewer backend connections. This frees up server resources for more important uses, such as disk caching. This lets you maintain a large number of database connections without sacrificing overall performance. To learn more, see Aiven's documentation on connection pooling.

We've added several new operations for this support:

• Create a PostgreSQL connection pool (POST /databases/postgresql/instances/{postgresqlInstanceId}/connection-pools).

• List PostgreSQL connection pools (GET /databases/postgresql/instances/{postgresqlInstanceId}/connection-pools).

• Get a PostgreSQL connection pool (GET /databases/postgresql/instances/{postgresqlInstanceId}/connection-pools/(poolName}).

• Update a PostgreSQL connection pool (PUT /databases/postgresql/instances/{postgresqlInstanceId}/connection-pool/(poolName}).

• Delete a PostgreSQL connection pool (DELETE /databases/postgresql/instances/{postgresqlInstanceId}/connection-pool/(poolName}).

We've also updated several existing operations to support PGBouncer connection pools:

• List PostgreSQL Managed Database advanced parameters (GET /databases/postgresql/config).

• Create or restore a PostgreSQL Managed Database (POST /databases/postgresql/instances).

• List PostgreSQL Managed Databases (GET /databases/postgresql/instances).

• Get a PostgreSQL Managed Database (GET /databases/postgresql/instance).

• Update a PostgreSQL Managed Database (PUT /databases/postgresql/instance).

New endpoints object

A new endpoints object has been added to help clarify the availability of private and public hostnames in your MySQL or PostgreSQL Managed Databases. You can find it in the response output, when viewing your Managed Databases:

• List MySQL Managed Databases (GET /databases/mysql/instances).

• Get a MySQL Managed Database (GET /databases/mysql/instance).

• List PostgreSQL Managed Databases (GET /databases/postgresql/instances).

• Get a PostgreSQL Managed Database (GET /databases/postgresql/instance).

Changed

Organization of the Databases category

To better organize Managed Databases-specific operations, we've re-ordered the table of contents in the documentation:

• Databases. This sub-category now contains general operations that apply to all Managed Databases-supported engines.
• MySQL. All operations used to manage MySQL databases are contained here.
• PostgreSQL. All operations used to manage PostgreSQL databases are contained here.