Option to set an absolute TTL for connections

blackbeam / mysql_async

Asyncronous Rust Mysql driver based on Tokio.

Apache License 2.0

372 stars 113 forks source link

Closed cloneable closed 10 months ago

cloneable commented 10 months ago

The TTL, if set, forces connections to be disconnected, even overriding the minimum pool size constraint.
The TTL can be combined with a random jitter value to prevent all connections closing at the same time.
This enables gradual connection migration and regular connection recycling when automatic CONN_RESET is not desired.

cloneable commented 10 months ago

Hi @blackbeam! Is this something that you would consider accepting? I still have to write tests, would like to hear from you first.

cloneable commented 10 months ago

Hey @blackbeam! Have you had a chance to look at this?

blackbeam commented 10 months ago

Hi, @cloneable. I don't mind including this into the codebase but could you please add connection URL support for both ttl and jitter values?

cloneable commented 10 months ago

Thank you, @blackbeam! I made the changes. Please have a look.