Behavior with regard to open connections when changing rds proxy target

Question

Hello,

we have an RDS proxy pointing to a single RDS PostreSQL instance. If we change the proxy target to a new RDS instance while there are ongoing connections / queries to the proxy, what exactly will happen with these queries? Will they be allowed to finish before the proxy switches to the new target? Or should we expect them to fail?

We have seen this [example](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/rds-proxy.examples.html#example-mysql-preserve-connections) in the documentation but our use case is a little different.

Answer

The RDS proxy will terminate the connections on changing the proxy target. They will close connection to one RDS Proxy target to another.So yes the queries won’t be allowed to finish ,because the session will be terminated as I explained above.

Behavior with regard to open connections when changing rds proxy target

Contenido relevante