Help Center/ TaurusDB/ User Guide/ Database Proxy (Read/Write Splitting)/ Testing Read/Write Splitting Performance
Updated on 2025-07-14 GMT+08:00
View PDF

Testing Read/Write Splitting Performance

After a proxy instance is created, you can connect your TaurusDB instance through a proxy address. You can use internal SQL commands to verify the read/write splitting performance.

Procedure

  1. Log in to an ECS. For details, see Elastic Cloud Server User Guide.
  2. Connect to a DB instance through a proxy address.

    mysql -h <hostIP> -P <port> -u <userName> -p <password>

    Table 1 Parameter description

    Parameter

    Description

    <hostIP>

    Proxy address.

    <port>

    Database port. By default, the value is 3306.

    <userName>

    Username of the TaurusDB database administrator account. The default username is root.

    <password>

    Password

  3. Run the following command to view the instance that executes the SQL command:

    Run show last route; to view the routing result of the previous SQL statement.
    Figure 1 Query result

    Do not use show last route for service code or multi-statement execution.