Hi, I noticed that MySQL is not
# spicedbd
diegoleonardourban
02/23/2024, 3:11 PMHi, I noticed that MySQL is not recommended as a datastore implementation and I am curious why.
Could you elaborate what are the reasons behind it?
v
vroldanbet
02/23/2024, 4:14 PMWhere did you find that recommendation? MySQL is the only datastore implementation Authzed does not run ourselves in our managed services, so it's perhaps less battle tested (by Authzed), but we are aware of different organizations using it.
diegoleonardourban
02/23/2024, 4:19 PMBut I couldn't find any reasonable explanation behind it in the docs.
v
vroldanbet
02/23/2024, 4:19 PMI'll get back to the team to understand where does come from. I think the framing is a bit harsh, and I can only imagine it steeming from the fact that we don't have operational experience running it, but that's it. It passes all our tests, and we know folks are using it.
d
diegoleonardourban
02/23/2024, 4:21 PMThanks
diegoleonardourban
02/23/2024, 4:22 PMOw, just bumped into this caveat:
https://github.com/authzed/spicedb/tree/main/internal/datastore/mysql
The MySQL datastore only supports a single primary node, and does not support read replicas. It is therefore only recommended for installations that can scale the MySQL instance vertically and cannot be used efficiently in a mulit-region installation.j
Joey
02/23/2024, 4:28 PMsame caveat applies to Postgres
Joey
02/23/2024, 4:28 PMif you need multiregion or multi-primary, CRDB or Spanner are required