The TencentDB for MySQL database proxy provides the transaction split feature. This feature separates read and write operations in one transaction to different instances for execution and forwards read requests to read-only instances, thereby lowering the load of the source instance.
By default, the TencentDB for MySQL database proxy forwards all requests in a transaction to the source instance to ensure the transaction correctness. In some frameworks, however, all requests are encapsulated to transactions that are not committed automatically, causing an excessive load of the source instance. In this case, you can use the transaction split feature.
The transaction split feature is disabled by default. You can enable it by adjusting the configuration of the database proxy address.
You have enabled the database proxy. For more information, see Enabling Database Proxy.
Note:You can also find the target access address in Database Proxy > Overview > Connection Address. Then, click Adjust Configurations in the Operation column.
Was this page helpful?