SpiceDB is an open source, Google Zanzibar-inspired, database system for creating and managing security-critical application permissions.

SpiceDB

Hi , we are planning to migrate our datastore from Postgres to Mysql. I wanted to understand what are the best practices , issues , limitations for this activity. Also would like to understand which data store will be better in performance and ease of support and maintenance with respect to postgres vs Mysql . Please provide your thoughts or suggestions.

It depends. Is this in production and cannot take downtime? Then you need to backfill and dual-write to both systems. You can do this by using `zed` backup and restore functionality, in combination with the Watch API:
- `zed backup` origin cluster 
- `zed restore` target cluster
- use `Watch API` to replicate changes from one system to the other, using the zedtoken provided by `zed backup` as the moment in time to start replicating. Please note no new schema changes can take place - watch API does not stream schema changes.

If downtime is feasible, then just using zed backup and restore should suffice.

Authzed maintain the MySQL datastore in a best effort basis, as it was contributed by GitHub and we don't operate it in production. We do operate Postgres, Spanner and CockroachDB in production, so those tend to receive more maintenance attention. If we had to recommend a system, we would suggest Postgres instead of MySQL.