3 DevOps Guru for RDS insights: rightsize Aurora/RDS, diagnose issues faster, and pinpoint anomalous SQL using Database Load + Performance Insights.
Relational Databases
How to Set Up the Latest Version of PostgreSQL on AWS Linux 2
Tutorial for setting up PostgreSQL on AWS Linux 2: add the PostgreSQL yum repo, install and init the server, configure postgresql.conf and pg_hba.conf, and start PostgreSQL.
Optimal DB Architecture for Fast Access to Historical FX Data in MySQL
Design a MySQL schema for ultra-fast retrieval of historical FX time series at scale (~40k pairs): RDS vs S3 tradeoffs, indexing, table-per-pair strategy.