Add retries for Temporal having connectivity failures for persistence database

[jatin27chopra]

Temporal server needs to retry transient 5xx errors from visibility datastore especially when it fails to acquire database connections temporarily.

I tried raising database resources such as CPU, memory but it didn't help.

It's the same error as reported in this

pingcap/tidb#52653

Or somehow expose connectAttributes and the variable "connect_timeout=XYZ" in temporal server configuration