Hi Keto team, When going through the production d...
# talk-keto
b
Hi Keto team, When going through the production deployment documentation of Keto, (https://www.ory.sh/docs/keto/guides/production) it is stated that the supported set of databases are PostgreSQL, MySQL and CockroachDB. I’m working on setting up a deployment on Azure and the available options for me are PostgreSQL and MySQL. Are there any performance related advantages or disadvantages in using one over the other? Could you recommend an option for a db platform? Also, is there a plan to support MSSQL in the roadmap?
s
We will probably never support proprietary databases, as we cannot test support for them in our CI.
I'd recommend postgres over mysql. In my experience tests run way faster against postgres, mysql seems to be slower in general, and needs a long time to come live.
b
Thanks for the quick response @steep-lamp-91158. Really appreciate how engaged you guys are with the community. 😃
h
The best option you have if you want multi-region keto that scales is to consume it via Ory Cloud 🙂 We take care of all the operations and are working towards a 30ms 99th percentile request latency (hopefully pushing it down even more in the future). Running keto yourself at scale is hard, and running it multi-region even more so if you use psql/mysql which are not horizontally scalable