search

k3s-io / kine

Run Kubernetes on MySQL, Postgres, sqlite, dqlite, not etcd.
Apache License 2.0
1.56k stars 233 forks source link

Vitess #152

Closed kfox1111 closed 10 months ago

kfox1111 commented 1 year ago

Anyone try kine against a vitess cluster?

brandond commented 1 year ago

not that I'm aware of, but in my experience anything that does sharded multi-master clustering won't work well.

kfox1111 commented 1 year ago

Might be an interesting use case to test, as vcluster/k3s usage grows, and having one, scaleable mysql cluster behind all the tenant clusters could make management easier.

kfox1111 commented 1 year ago

Its not multi-master by design: https://vitess.io/docs/15.0/overview/scalability-philosophy/

So, it may not be a problem there. The sql schema seems pretty simplistic. If a cluster name property was added to the schema, you might not even need separate databases for multiple instances and could shard on it?

l2dy commented 11 months ago

Vitess fails CREATE DATABASE queries by default, which makes Kine incompatible with some managed database providers.

https://github.com/k3s-io/kine/blob/c5f2d892d70778fb9ad15208d4ca8617c3c794da/pkg/drivers/mysql/mysql.go#L46