The instance type used has 8 vCPUs and are selected to support a larger number of database threads in a production workload.
| Instance Type | Resource Specs | Price Per Hour (us-east) |
|---|---|---|
| db.m5.2xlarge | 8 vCPUs, 32GB RAM | $0.68 (MySQL) ($0.71 PostgreSQL) |
| db.r6g.2xlarge | 8 vCPUs, 64GB RAM | $0.86 (MySQL) ($0.90 PostgresSQL) |
| db.r7g.2xlarge | 8 vCPUs, 64GB RAM | $0.96 (MySQL & PostgreSQL) |
Changing the password of a MySQL account that an application uses was hard before MySQL 8.0. It is easy in MySQL 8.0 and later, thanks to two clauses of ALTER USER: RETAIN CURRENT PASSWORD and DISCARD OLD PASSWORD.
Read moreI recently tracked down a performance problem that turned out not to be in the application, the servers, or the CDN. A corporate TLS-inspecting proxy sat between the users and the site.
Read moreVillageSQL published Access MySQL over MCP with vsql-mcp . The extension serves the Model Context Protocol from inside the database, so an agent talks to MySQL over Streamable HTTP without a sidecar holding a credential.
Read more
