Vitess
kfox1111 opened this issue · 4 comments
Anyone try kine against a vitess cluster?
not that I'm aware of, but in my experience anything that does sharded multi-master clustering won't work well.
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.
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?
Vitess fails CREATE DATABASE queries by default, which makes Kine incompatible with some managed database providers.
kine/pkg/drivers/mysql/mysql.go
Line 46 in c5f2d89