Customized Hints for Read/Write Isolation
DDM allows you to customize a hint to specify whether SQL statements are executed on the primary instance or its read replicas.
The hint is in the format of /*mycat:db_type=host*/.
In the format, host can be "master" or "slave". "master" refers to the primary DB instance, and "slave" refers to read replicas.
Generally, after read/write isolation, write operations are performed only on the primary DB instance, and read operations are performed only on its read replicas. In some special scenarios where data needs to be read from the primary DB instance, you can customize a hint to forcibly perform read operations on the primary DB instance.
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
