SingleStoreDB v7.5

Connect to Your Cluster

The Operator creates two services intended for access by clients and database users:

  • One service, svc-memsql-cluster-ddl, is the DDL endpoint. This endpoint is for creating tables.

  • The other service, svc-memsql-cluster-dml, is the DML endpoint. This endpoint is for read/write operations and is load-balanced among the available aggregators.

If the count field of the aggregatorSpec in the memsql-cluster.yaml file has a value of 1, then only the DDL endpoint is created.

If the count field of the aggregatorSpec in the memsql-cluster.yaml file has a value of 2 or greater, the DML endpoint is created as well.

Display the Service Endpoints

Run kubectl get services to display the DDL and DML endpoints. Include -n <namespace> to view these services in a specific namespace.

kubernetes-operator-service-listing.png

Use these IP addresses from the CLUSTER-IP column to access these services.

  • The DDL port is accessible on the local host on 10.98.190.175

  • The DML port is accessible on the local host on 10.101.157.16

If the Operator cluster resides on a cloud service provider, use the IP addresses from the EXTERNAL-IP column instead, which can be reached externally.

Connect with the MySQL Client

To connect to the SingleStoreDB cluster, run the following command from a computer that can access the Kubernetes cluster. Use the admin database user with the password you defined in the memsql-cluster.yaml definition file.

mysql -u admin -h <hostname> -P <port> -p<password>
In this section: