Experimental. Run away. RUN AWAY
The DB server is an experimental proxy layer for backend databases. It allows the platform services to be leveraged as part of the system. Dynamic config, auth, routing, selector, etc.
The DB uses the registry to find supported databases for proxying. It expects the metadata key "driver" to be set to the type of database. It should match one of the supported drivers.
- mysql (mariadb)
future
- elasticsearch
- cassandra
...
-
Install Consul
Consul is the default registry/discovery for go-micro apps. It's however pluggable. https://www.consul.io/intro/getting-started/install.html
-
Run Consul
$ consul agent -server -bootstrap-expect 1 -data-dir /tmp/consul -
Start one of the supported databases (mysql, elasticsearch, ...) and register with the registry.
Example. Register location of the **foo** database hosted by mysql $ micro register service '{"name": "go.micro.db.foo", "version": "0.0.1", "nodes": [{"id": "foo-1", "address": "127.0.0.1", "port": 3306, "metadata": {"driver": "mysql"}}]}' -
Download and start the service
go get github.com/micro/db-srv db-srv --database_service_namespace=go.micro.db
OR as a docker container
docker run microhq/db-srv --database_service_namespace=go.micro.db --registry_address=YOUR_REGISTRY_ADDRESS
DB server implements the following RPC Methods
DB
- Read
- Create
- Update
- Delete
- Search
micro query go.micro.srv.db DB.Create '{"database": {"name": "foo", "table": "bar"}, "record": {"id": "e7add322-e069-44c2-b920-c4fbfd62e6b5", "metadata": {"key": "value"}}}'
micro query go.micro.srv.db DB.Read '{"database": {"name": "foo", "table": "bar"}, "id": "e7add322-e069-44c2-b920-c4fbfd62e6b5"}'
{
"record": {
"created": 1.454704366e+09,
"id": "e7add322-e069-44c2-b920-c4fbfd62e6b5",
"metadata": {
"key": "value"
},
"updated": 1.454704366e+09
}
}
micro query go.micro.srv.db DB.Search '{"database": {"name": "foo", "table": "bar"}}'
{
"records": [
{
"created": 1.454704366e+09,
"id": "e7add322-e069-44c2-b920-c4fbfd62e6b5",
"metadata": {
"key": "value"
},
"updated": 1.454704366e+09
}
]
}
micro query go.micro.srv.db DB.Update '{"database": {"name": "foo", "table": "bar"}, "record": {"id": "e7add322-e069-44c2-b920-c4fbfd62e6b5", "metadata": {"key": "value", "key2": "value2"}}}'
micro query go.micro.srv.db DB.Delete '{"database": {"name": "foo", "table": "bar"}, "id": "e7add322-e069-44c2-b920-c4fbfd62e6b5"}'