Gorb is a package built upon Gorp and strongly inspired by Nap. It allows load balancing in a round robin style between master and replica databases.
Read queries are executed by replica.
Write queries are executed by the master.
Use .MasterCanRead(true) to perform WRITE queries with the master and READ queries with the master and replica.
func main() {
dsns := "root:root@tcp(master:3306)/masterpwd;"
dsns += "root:root@tcp(replica:3306)/replicapwd"
b, err := gorb.NewBalancer("mysql", gorp.MySQLDialect{"InnoDB", "utf8mb4"} , dsns)
if err != nil{
panic(err)
}
err = b.Ping()
if err != nil{
panic(err)
}
// Master is used only for write queries, this is the default value
b.MasterCanRead(false)
// Master is used for write and read queries
b.MasterCanRead(true)
count, err := b.SelectInt("SELECT COUNT(*) FROM mytable")
if err != nil{
panic(err)
}
fmt.Println(count)
}Gorb is licensed under the MIT License.