This document describes how to use the hint syntax on the database proxy.
The hint syntax can be used to forcibly execute SQL requests on the specified instance. A hint has the highest routing priority. For example, it is not subject to consistency and transaction constraints. Please reasonably evaluate whether it is required in your business scenario before using it.
When using the MySQL command line tool to connect and use the
HINTstatement, you need to add the
-coption in the command; otherwise, the hint will be filtered by the tool.
Currently, three types of hints are supported:
/* to master */ /*FORCE_MASTER*/
/* to slave */ /*FORCE_SLAVE*/
/* to server server_name*/
server_namecan be a short ID, such as
/* to server test_ro_1 */.