I recently deployed a small inventory and sales application with an Angular frontend hosted on object storage and a CDN, plus a .NET API running on a small…
I recently deployed a very small inventory and sales application and am trying to keep the infrastructure affordable. The frontend runs on object storage and a CDN, while…
I manage seven AWS RDS PostgreSQL instances: three in the US, three in Europe, and one in Australia. Each instance contains roughly 3,000 mostly small databases. Because PostgreSQL…
I run seven AWS RDS for PostgreSQL instances: three in the US, three in Europe, and one in Australia. Each instance hosts roughly 3,000 mostly small databases. Because…
Our Amazon RDS MySQL instance currently uses a parameter group with `time_zone = 'US/Pacific'`. British Columbia is moving to a permanent UTC−7 offset, so the database would eventually…
Our managed MySQL database currently uses a parameter group with `time_zone = 'US/Pacific'`. British Columbia is moving to permanent Pacific Daylight Time at UTC−07:00, so the current timezone…
For anyone running MySQL on an m7i.24xlarge instance, what value do you get from `SHOW GLOBAL VARIABLES LIKE 'max_connections';`? Mine consistently returns 16,000, and I'm trying to determine…
For anyone running MySQL on an m7i.24xlarge instance, what value does `SHOW GLOBAL VARIABLES LIKE 'max_connections';` return for you? Mine consistently shows 16,000, and I'm trying to understand…
I'm using AWS SAM to provision API Gateway, Lambda functions, and an RDS database. I'd like to automate schema changes with a tool such as Alembic, but the…
I'm looking into the available patterns for moving an RDS or Aurora database back to an on-premises environment. As far as I know, the main choices are using…
I'm exploring the available patterns for moving an RDS or Aurora database back to an on-premises environment. My current understanding is that the main choices are either using…
I'm preparing to launch a website that I expect to be database-heavy. I prefer having control over my software and infrastructure, so I'm considering running and scaling the…
Amazon RDS MySQL 8.0 standard support ends on July 31. Starting August 1, instances that remain on MySQL 8.0 will automatically enter paid extended support unless you explicitly…
I'm preparing to launch a website that may generate significant database traffic. I prefer having control over my software and infrastructure, so I'm considering running and scaling the…
I'm trying to verify the correct hourly commitment for an AWS RDS Savings Plan. I have one db.r8i.2xlarge RDS instance running Windows with SQL Server continuously. The current…
I'm dealing with a frustrating performance issue on one of my Django API endpoints that connects to AWS RDS PostgreSQL. The endpoint takes a ridiculous 8-11 seconds to…