Help Center/ GaussDB(for MySQL)/ User Guide/ Database Proxy (Read/Write Splitting)/ Changing Configurations of a Proxy Instance/ Enabling Transaction Splitting for a Proxy Instance
Updated on 2024-09-06 GMT+08:00
View PDF

Enabling Transaction Splitting for a Proxy Instance

In most cases, a proxy instance sends all requests in transactions to the primary node to ensure transaction correctness. However, in some frameworks, all requests are encapsulated into transactions that are not automatically committed using set autocommit=0. This causes heavy loads on the primary node.

Proxy instances support transaction splitting. With transaction splitting is enabled, GaussDB(for MySQL) can route the read requests prior to write operations in a transaction to read replicas, reducing the pressure on the primary node.

Transaction splitting is disabled by default. After transaction splitting is enabled and autocommit is set to 0, GaussDB(for MySQL) starts a transaction only for write requests. Before the transaction starts, read requests are routed to read replicas through load balancers.

Constraints

  • The kernel versions of proxy instances must be 2.3.9.5 or later.
  • Translation isolation levels of GaussDB(for MySQL) instances must be READ UNCOMMITTED or READ COMMITTED. The default isolation level is REPEATABLE READ.
  • Proxy instances must be in the in read/write mode.
  • After transaction splitting is enabled, the transaction isolation level can only be changed to READ UNCOMMITTED or READ COMMITTED. To change the isolation level to a higher level, disable the function.

Procedure

  1. Log in to the management console.
  2. Click in the upper left corner and select a region and project.
  3. Click in the upper left corner of the page, choose Databases > GaussDB(for MySQL).
  4. On the Instances page, click the target DB instance name to go to the Basic Information page.
  5. In the navigation pane on the left, choose Database Proxy.
  6. Click the name of a proxy instance.
  7. On the Basic Information page, click next to Transaction Splitting.

    Figure 1 Configuring transaction splitting

  8. In the displayed dialog box, click Yes.

    • To disable transaction splitting, click .
    • Transaction splitting takes effect only for new connections established after this function is enabled or disabled.

APIs

Parent Topic: Changing Configurations of a Proxy Instance