PgDog is a Rust-based PostgreSQL proxy that handles connection pooling, load balancing, and database sharding on commodity hardware - managing thousands of connections where pgbouncer falls short.
https://github.com/pgdogdev/pgdog
#PostgreSQL #Rust #DatabaseScaling
🚀 Escalando PostgreSQL para 800 millones de usuarios de ChatGPT
Cómo OpenAI escaló PostgreSQL a millones de consultas por segundo.
https://openai.com/index/scaling-postgresql
#PostgreSQL #DatabaseScaling #Performance #RoxsRoss
OpenAI scales PostgreSQL for ChatGPT's 800M users using a single primary instance with multiple read replicas. This approach requires offloading some write-heavy workloads to Azure CosmosDB, sparking debate on its effectiveness and long-term implications. #DatabaseScaling 1/6
OpenAI cranked PostgreSQL to handle 800 M users—think connection pooling, Azure read replicas, and slick performance tweaks. Curious how they did it? Dive into the scaling secrets behind ChatGPT’s massive DB. #PostgreSQL #OpenAI #DatabaseScaling
🔗 aidailypost.com/news/openai-...
OpenAI reveals how 1 PostgreSQL primary + 50 replicas powers 800M ChatGPT users with 99.999% uptime and millions of QPS.
Full infrastructure breakdown by #AdwaitX ⬇️
#PostgreSQL #OpenAI #ChatGPT #DatabaseEngineering #Tech #News #DatabaseScaling #CloudArchitecture
On scaling, the debate centered on when sharding is truly needed vs. scaling a single Postgres instance. While a single database can handle large loads, sharding is seen as beneficial for managing very large tables and improving performance at scale. #DatabaseScaling 2/5
Before scaling or moving to distributed DBs, optimize! Discussion highlights optimizing queries, indexing, and config first. Many companies overspend due to inefficient practices, not lack of scale. #DatabaseScaling 5/6
📊📰 Scheduled scaling of Amazon Aurora Serverless with Amazon EventBridge Scheduler
buff.ly/681zRx4
#aws #AuroraServerless #AWS #DatabaseScaling #EventBridge #CloudComputing
We recently wrote about scaling MySQL using replicas.
Article: victoronsoftware.com/posts/mysql-master-slave...
Video: https://www.youtube.com/watch?v=mpCeatW4t_U
#DatabaseAdministration #MySQL #DatabaseScaling
We updated our MySQL replication article for the latest MySQL versions (8.0, 8.4, and 9.1)
victoronsoftware.com/posts/mysql-master-slave...
#DatabaseAdministration #MySQL #DatabaseScaling
When you start to really worry about your database... 👀 🚨 📈
#DatabaseScaling
We hit these database issues when scaling applications:
- Excessive database locks
- Read-after-write consistency
- Index limitations
#SQLPerformance #SQLDeveloper #DatabaseScaling #MySQL #DatabaseAdministration
victoronsoftware.com/posts/databa...
I discovered how simple it is to create a MySQL master-slave replica.
#MySQL #DatabaseScaling #DatabaseAdministration
victoronsoftware.com/posts/mysql-...