* TNSNames: make coordinate source configurable

* backoff -> tenacity

backoff triggers deprecation warnings with Python 3.14 and seems
semi-abandoned, see:

https://github.com/litl/backoff/issues/211
https://github.com/pypi/support/issues/7364