Follow-up from "feat(database): use service discovery for primary address"

The following discussion from !1271 (merged) should be addressed:

• @jdrpereira started a discussion:

  While at it, I think it's worth exposing these as options (WithMaxIdle, WithMaxOpen) to generalize this function for multiple use cases.