4 ms·
Ah yes, PgBouncer or mysqlProxy. The idea makes sense. However, it never works. You can't push all your db traffic through a single vm (PgBouncer). Next! Some
by ransom1538 3y ago
Ah yes, PgBouncer or mysqlProxy. The idea makes sense. However, it never works. You can't push all your db traffic through a single vm (PgBouncer). Next! Someone on the team suggests 2 vms! This is not the path forward. What you need is a cloud supported load balancer to push all the traffic through and just health check the port 3306/5432.
- nikita2206 3y ago1. Why can you not push all your traffic through a single PgBouncer? 2. You can have three PgBouncers and clients can have their own balancing of available database proxies as well, the entire migration is doable with multiple PgBouncers too - it’s just a bit more code to implement the pausing and the switch over for many instances simultaneously.