mysql_fdw 集成go-mysql-server 开发的mysql server
早期go-mysql-server golang 包对于mysql 的支持有限，但是dolthub团队扩展之后我们可以集成了
以下是一个简单的demo测试
环境准备
- docker-compose
mysql_fdw 环境
version: "3"
services:
pg:
image: dalongrong/pgspider:mysql
ports:
- "5432:5432"
environment:
- "POSTGRES_PASSWORD=dalong"
- mysql server
go.mod
module mysql-app
go 1.15
require github.com/dolthub/go-mysql-server v0.6.1-0.20201113020219-f934e2bcb07f
main.go
package main
import (
sqle "github.com/dolthub/go-mysql-server"
"github.com/dolthub/go-mysql-server/auth"
"github.com/dolthub/go-mysql-server/memory"
"github.com/dolthub/go-mysql-server/server"
"github.com/dolthub/go-mysql-server/sql"
)
func main() {
driver := sqle.NewDefault()
driver.AddDatabase(createTestDatabase())
config := server.Config{
Protocol: "tcp",
Address: "0.0.0.0:3306",
Auth: auth.NewNativeSingle("root", "dalong", auth.AllPermissions),
}
s, err := server.NewDefaultServer(config, driver)
if err != nil {
panic(err)
}
s.Start()
}
func createTestDatabase() *memory.Database {
const (
dbName = "test"
tableName = "mytable"
)
db := memory.NewDatabase(dbName)
table := memory.NewTable(tableName, sql.Schema{
{Name: "name", Type: sql.Text, Nullable: false, Source: tableName},
{Name: "email", Type: sql.Text, Nullable: false, Source: tableName},
})
db.AddTable(tableName, table)
ctx := sql.NewEmptyContext()
rows := []sql.Row{
sql.NewRow("John Doe", "john@doe.com"),
sql.NewRow("John Doe", "johnalt@doe.com"),
sql.NewRow("Jane Doe", "jane@doe.com"),
sql.NewRow("Evil Bob", "evilbob@gmail.com"),
}
for _, row := range rows {
table.Insert(ctx, row)
}
return db
}
运行
- 启动服务
docker-compose up -d
go run main.go
- 效果
pg 
mysql 
说明
以上只是一个简单的demo，实际上dolthub 团队扩展的go-mysql-server 支持的特性还是比较多的
参考资料
https://github.com/dolthub/go-mysql-server
https://github.com/EnterpriseDB/mysql_fdw
https://github.com/pgspider/pgspider
https://github.com/rongfengliang/pgspider-docker
https://hub.docker.com/repository/docker/dalongrong/pgspider
https://github.com/rongfengliang/go-mysql-server-mysql-fdw
