Using Hints for Read/Write Splitting
In addition to configuring weights of nodes for read/write splitting, you can use hints in SQL statements to route read and write requests to a primary node or read replica.
Precautions
- Hints are only used as routing suggestions. In non-read-only SQL and non-transaction scenarios, SQL statements cannot be routed to read replicas.
- If you want to connect to a DB instance using the MySQL CLI and hints, add the -c option.
Usage
You can add the following hints at the beginning of an SQL statement as needed.
/*FORCE_MASTER*/: The SQL statement is executed on the primary node.
/*FORCE_SLAVE*/: The SQL statement is executed on read replicas.
For example, if you run select * from table1, the SQL statement will be executed on a read replica by default. If you change it to /*FORCE_MASTER*/ select * from table1, the SQL statement will be executed on the primary node.
/*FORCE_MASTER*/ only works for read/write addresses. Even if you use it for a read-only address, the SQL statement will not be executed on the primary node.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
