Automatic reconnect enables the Connector to re-establish a connection in the event of a transient failure. Under specific circumstances, the Connector will also retry the query.
Connector automatic reconnect is enabled by default in Proxy and
Smartscale modes. Use the tpm command option
--connector-autoreconnect=false to
disable automatic reconnect.
This feature is not available while running in Bridge Mode. Use the
tpm command option
--connector-bridge-mode=false to
disable Bridge mode.
Automatic reconnect enables retries of statements under the following circumstances:
not in bridge mode
not inside a transaction
no temp table has been created
no lock acquired and not released
the request is a read
To disable:
shell>tpm query stagingtungsten@db1:/opt/continuent/software/tungsten-clustering-6.0.5-40 shell>echo The staging USER is `tpm query staging| cut -d: -f1 | cut -d@ -f1`The staging USER is tungsten shell>echo The staging HOST is `tpm query staging| cut -d: -f1 | cut -d@ -f2`The staging HOST is db1 shell>echo The staging DIRECTORY is `tpm query staging| cut -d: -f2`The staging DIRECTORY is /opt/continuent/software/tungsten-clustering-6.0.5-40 shell>ssh {STAGING_USER}@{STAGING_HOST}shell>cd {STAGING_DIRECTORY}
shell> ./tools/tpm configure alpha \
--connector-autoreconnect=false
Run the tpm command to update the software with the Staging-based configuration:
shell> ./tools/tpm updateFor information about making updates when using a Staging-method deployment, please see Section 10.3.7, “Configuration Changes from a Staging Directory”.
shell> vi /etc/tungsten/tungsten.ini[alpha]
...
connector-autoreconnect=false
Run the tpm command to update the software with the INI-based configuration:
shell>tpm query stagingtungsten@db1:/opt/continuent/software/tungsten-clustering-6.0.5-40 shell>echo The staging DIRECTORY is `tpm query staging| cut -d: -f2`The staging DIRECTORY is /opt/continuent/software/tungsten-clustering-6.0.5-40 shell>cd {STAGING_DIRECTORY}shell>./tools/tpm update
For information about making updates when using an INI file, please see Section 10.4.4, “Configuration Changes with an INI file”.
Configuration group alpha
The description of each of the options is shown below; click the icon to hide this detail:
--connector-autoreconnect=false
Enable auto-reconnect in the connector
The autoreconnect status can be monitored within the
autoReconnect parameter output by
the tungsten show variables
while connected to the Connector. For example:
shell>tpm connectormysql>tungsten show variables like "autoReconnect";+----------------------+---------------+-------+ | Variable_Type | Variable_name | Value | +----------------------+---------------+-------+ | connector.properties | autoReconnect | false | +----------------------+---------------+-------+ 1 row in set (0.00 sec)
The above output indicates that the autoreconnect feature is disabled. The tungsten show command is not available in Bridge mode.