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 staging
tungsten@db1:/opt/continuent/software/tungsten-clustering-7.0.3-141 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-7.0.3-141 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 update
For 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 staging
tungsten@db1:/opt/continuent/software/tungsten-clustering-7.0.3-141 shell>echo The staging DIRECTORY is `tpm query staging| cut -d: -f2`
The staging DIRECTORY is /opt/continuent/software/tungsten-clustering-7.0.3-141 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 connector
mysql>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.