RDS PostgreSQL and MySQL

Overview

This document guides the provisioning and management of Amazon RDS PostgreSQL and MySQL databases in Party Bus environments. It outlines how these supported database services are integrated, what capabilities are available to product teams (such as schema management and migrations), and the operational boundaries enforced by MDO.

Deployment

Request an RDS PostgreSQL or MySQL database by submitting a Pipeline Issue Help Desk ticket .

We support one database per application. These databases run on AWS Aurora, providing backups, redundancy, and other high-availability features.

Connection and Authentication

For connection to these databases, we provide host, port, database name, and username/password environment variables. We recommend using a database connection library to manage these connections rather than creating the connection string yourself. We provide admin, read-write, and read-only users, as shown in the environment variables below.

If you have a PostgreSQL database, these are the environment variables injected into your application:

• PGHOST
• PGPORT
• PG_DATABASE
• PG_USER
  • Used with: APP_DB_ADMIN_PASSWORD
• PG_RW_USER - Used with: APP_DB_RW_PASSWORD
  • PG_RO_USER - Used with: APP_DB_RO_PASSWORD

If you have a MySQL database, these are the environment variables injected into your application:

• MYSQL_HOST
• MYSQL_PORT
• MYSQL_DB_NAME
• MYSQL_DB_ADMIN_USER
  • Used with: MYSQL_DB_ADMIN_PASSWORD
• MYSQL_DB_RW_USER
  • Used with: MYSQL_DB_RW_PASSWORD
• MYSQL_DB_RO_USER
  • Used with: MYSQL_DB_RO_PASSWORD

External Interactions

Only applications deployed in Party Bus may connect to RDS; external access (e.g., from developer computers) is not permitted. In those instances, we recommend adding endpoints to your application that can serve to proxy your requests.

FAQs

What is the RDS engine version for MySQL?

The current minimum version of MySQL is Aurora MySQL 8.x (minor version updates are automatic).

What is the RDS engine version for PostgreSQL?

The current minimum version of PostgreSQL is Aurora PostgreSQL 14.xx (minor version updates are automatic). PostgreSQL version 14.xx will reach EOL in November 2026, and will be updated to version 15.xx.

Can my team choose a different PostgreSQL version?

Yes. Customers who pay for a single-tenant Amazon RDS environment can request any PostgreSQL Aurora version currently supported by AWS. Request a different PostgreSQL version using the General Support help desk ticket.

Are there any version limitations for single-tenant RDS environments?

Yes. PostgreSQL version 18.xx is currently in preview and is not yet supported for production use. AWS typically adds support for a new major PostgreSQL version about once per year.

How do I drop my database? How do I restore my database from a backup?

Submit a Help Desk ticket to have the operations team carry out these actions.

How often do RDS automated backups happen?

RDS databases are automatically backed up every 12 hours, with the previous 30 days of backups retained. Additionally, biweekly manual backups are performed and retained for an extended period.

What character set is used for MySQL?

latin1

What are the differences between the admin user, the ReadOnly user, and the ReadWrite user?

Role	Permissions
Admin	(All)
ReadOnly (RO)	SELECT
ReadWrite (RW)	SELECT, INSERT, UPDATE, DELETE