Skip to main content
Common Reference

Connectivity

Connectivity Test 1 – Connect to the connector and verify Primary host​

Scenario
shell> mysql -h`hostname` -P9999 -uapp -p -e"select @@hostname for update"
Expectation
  • The Primary hostname is returned.

Connectivity Test 2 – Verify access to Replicas​

This test is only required if read/write splitting has been enabled. It should be run from a connector running on a server other than the Primary.

Scenario
shell> mysql -h`hostname` -P9999 -uapp -p -e"select @@hostname"
Expectation
  • A hostname is returned.
  • Repeat the process on other hosts until a Replica hostname is returned

Connectivity Test 3 – Verify access to the Primary before and after a switch​

Scenario
shell> cctrl
cctrl> use usa
[LOGICAL] /usa> switch
Expectation

  • Run Test 1 again and verify the new Primary hostname is returned.