Read-only Routing

It is possible to deploy a connector that has been configured to provide read-only access to the underlying databases on the standard port. This enforces read-only connectivity through this connector, regardless of any session or connector configuration options. This can be useful for a standalone connector, or a single connector within a dataservice.

This setting places the connector into RO_RELAXED mode. The connector will choose the Primary if there is no available Replica. See "connector-routing-qos" for more detail on Quality of Service modes.

To enable this functionality, configure the connector using the connector-readonly option within you /etc/tungsten/tungsten.ini file, and execute tpm update:

connector-readonly=true

To enable this functionality on specific hosts only, only include this option in the /etc/tungsten/tungsten.ini on the hosts in which you want it applying.