Adapters¶
Rel uses adapter in order to generate and execute query to a database, below is the list of available adapters currently supported.
Adapter | Package | Godoc |
---|---|---|
MySQL | github.com/go-rel/mysql | |
PostgreSQL | github.com/go-rel/postgres | |
MSSQL | github.com/go-rel/mssql | |
SQLite3 | github.com/go-rel/sqlite3 |
Using Primary Replica Connections¶
REL Read Write separation for primary replica connections by using intermediary adapters.
package main
import (
"context"
_ "github.com/go-sql-driver/mysql"
"github.com/go-rel/primaryreplica"
"github.com/go-rel/mysql"
"github.com/go-rel/rel"
)
func main() {
// open mysql connections.
// note: `clientFoundRows=true` is required for update and delete to works correctly.
adapter := primaryreplica.New(
mysql.MustOpen("root@(source:3306)/rel_test?charset=utf8&parseTime=True&loc=Local"),
mysql.MustOpen("root@(replica1:3306)/rel_test?charset=utf8&parseTime=True&loc=Local"),
mysql.MustOpen("root@(replica2:3306)/rel_test?charset=utf8&parseTime=True&loc=Local"),
)
defer adapter.Close()
// initialize REL's repo.
repo := rel.New(adapter)
repo.Ping(context.TODO())
}
Load Balancing of Replicas¶
REL only implements a very primitive load balancing for multiple replicas. For large scale application we recommend you to use external load balancing solution.
Last update: 2024-08-16