Connect with Go
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
SingleStore is wire-compliant with MySQL, which means you can connect to your SingleStore cluster with Go similar to a MySQL database.
Prerequisites
-
A SingleStore cluster
-
Go
-
The
mysql
module for Go:go get github.com/go-sql-driver/mysql
Connection Details
To connect your Go application to your SingleStore cluster, you'll need the following information:
-
Host: the endpoint or IP Address of your SingleStore cluster.
-
Port: default is
3306
-
User:
root
-
Password
-
Database
Here's an example of a Go connection for a SingleStore cluster:
func main() {HOSTNAME := "svc-12345678-1234-1234-1234-2d4b84322fd8-ddl.aws-region-1.svc.singlestore.com"PORT := "3306"USERNAME := "admin"PASSWORD := "<your admin password>"DATABASE := "acme"connection := USERNAME + ":" + PASSWORD + "@tcp(" + HOSTNAME + ":" + PORT + ")/" + DATABASE + "?parseTime=true"db, err := sql.Open("mysql", connection)}
More Information
For a complete example, including samples of CRUD operations, refer to this GitHub repository.
For information on using stored procedures with Go, see GitHub.
Last modified: April 5, 2023