tencent cloud

Feedback

Read/Write Separation

Last updated: 2024-01-06 17:34:55
TDSQL for MySQL instances support read/write separation in the following modes:
A replica comment flag such as /*slave*/ can be added in a SQL statement, and the -c parameter is added after mysql to parse mysql -c -e "/*slave*/sql" to send the SQL statements to the replica server.
Note:
Comment flags including /*slave:slaveonly*/, /*slave:20*/, and /*slave:slaveonly,20*/ are also supported, where their values indicate the delay requirement that the replica server should satisfy, and slaveonly indicates that the query will not be sent to the source server if there is no eligible replica server.
//Read data from source//
select * from emp order by sal, deptno desc;
//Read data from replica//
/*slave*/ select * from emp order by sal, deptno desc;
Requests sent by read-only accounts are sent to the replica server based on 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