Hello Team,
I’ve been looking around for some sort of documentation about the db_replica_host configuration, and whether this replica host can be used for database load balancing? (I.e., when using a replica, can SQL read queries go through this replica server, or do they always go through the main (primary) database?)
I’m considering start using a transaction pooling mechanism, but as a quick workaround, I’m wondering if this approach could alleviate pressure on a main instance.
Many thanks in advance and looking forward to hearing from you.
Cheers,
Ismael