Testing Read/Write Splitting Performance¶
After read/write splitting is enabled, databases can be connected through a read/write splitting address. You can use internal SQL commands to verify the read/write splitting performance.
Procedure¶
Use a read/write splitting address to connect to the database. For details, see Enabling Read/Write Splitting.
Run the following command to view the routing result of the previous SQL statement. The result is the private IP address of the DB instance.
show last route;
Figure 1 Query result¶