dice-fairlink icon indicating copy to clipboard operation
dice-fairlink copied to clipboard

Return connections to the master database

Open gedl opened this issue 6 years ago • 1 comments

One use case of a database cluster is by an application with a heavy bias towards reads. In this case, the master database can be mostly idle

This task is to implement a configurable mechanism where the user specifies whether (/how much) a connection to the writer instance should be returned, additionally to the read round-robin.

gedl avatar Oct 23 '18 18:10 gedl

I would also like to see this enhancement. We use the dice-fairlink driver for a read-only application but would like to be able to send connections to the writer too since it is very underutilized, which translates to a waste of thousands of dollars depending on the size. The writer instance must be kept at a large size in order to utilize autoscaling since the autoscaled instances are always created at the same size as the writer. Even if it was just a basic option to enable/disable connections to the writer, that would be very helpful and seems like it would be fairly easy to implement.

ballen-bw avatar Dec 09 '22 16:12 ballen-bw