By default, the Tungsten Connector listens on port 9999
so
as to avoid conflicting with the default MySQL listener port of
3306
.
The best practice is the change the MySQL port to 13306
and the Tungsten Connector port to 3306
.
For example, modify my.cnf
to define the port, then
restart MySQL:
port = 13306
For more information, see Section B.3.2, “MySQL Configuration”.
Configure the the Tungsten Connector to listen on port
3306
:
shell > tpm update alpha --application-port=3306
This change is especially important if the Tungsten Connector will be installed directly on the database nodes. ALL traffic needs to flow through the Tungsten Connector, so hiding the actual MySQL port prevents mistaken connections directly to the database.