#Access Methods

#Retrieve Account Information

1. Click MySQL-PXC in the left navigation bar.

2. Expand the cluster and click on the namespace.

3. Click on Instance Name.

4. In the User Management tab, obtain the username and password.

#Retrieve Connection Information

#For In-Cluster Access

After the instance is created, the information for in-cluster access can be found in the instance's Access Methods tab.

#For External Access

First, you need to add TCP listener ports for the LoadBalancer in the instance's Access Methods tab to receive connection requests from external clients.

#Procedure

1. In the External Access area, click Add Listener Port.

2. Choose the LoadBalancer.

3. Refer to the following instructions to configure the relevant parameters.

   Parameter	Description
   Internal Routing Group	The incoming traffic will be distributed to the internal routing's ports by default.
   Session Persistence	If session persistence is based on source address hash, access requests from the same IP address will always be forwarded to the backend service corresponding to the internal routing group.

4. Click Add.

5. Access the instance It is recommended to use the Standard MySQL Client to access the MySQL-PXC instance.

• Access from within the cluster: In the instance details page, click the Terminal Console in the top right corner to connect to the MySQL nodes. If you are connecting to a node within this instance, you can omit the -h parameter.

  mysql -h{Internal Routing Name}.{Namespace Name}.svc.cluster.local -u{Username} -p{Password}
  
  or
  
  mysql -h{Internal Routing IP Address} -u{Username} -p{Password}

• Access from outside the cluster

  mysql -h{LoadBalancer IP} -P{Listener Port} -u{Username} -p{Password}