tencent cloud

Feedback

Read/Write Separation

Last updated: 2021-09-22 10:49:41

TDSQL for MySQL instances support read-write separation in the following modes:

  • A comment flag such as /*slave*/ can be added to send specified SQL statements to the secondary server.

    Note:

    Comment flags including /*slave:slaveonly*/, /*slave:20*/, and /*slave:slaveonly,20*/ are also supported, where the value indicates the delay requirement that the secondary server should satisfy, and slaveonly indicates that the query will not be sent to the primary server if there is no eligible secondary server.

  • Requests sent by read-only accounts are sent to the secondary server according to the configured attributes.

Contact Us

Contact our sales team or business advisors to help your business.

Technical Support

Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

7x24 Phone Support