One question I had, I see in the docs that Postgre...
# spicedbg
gub98
08/09/2022, 7:56 PMOne question I had, I see in the docs that PostgresSQL (https://docs.authzed.com/spicedb/selecting-a-datastore#usage-notes-2) is not recommended for global deployments, but it looks like AWS Aurora (https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-global-database.html) allows for a global distributed database. Curious on if you all have seen anything that indicates that Aurora * does not * work well with spiceDB globally?
j
jzelinskie
08/09/2022, 8:00 PMSome folks are indeed using Aurora with SpiceDB, but I don't think any one from Authzed has exhaustively tested it. The recommendation around PG/MySQL for regional deployments is mostly under the assumption of the typical replication models for these databases (e.g. read replicas). I'm not familiar with how Aurora does replication/scaling across regions, but datastores like CockroachDB or Spanner operate with awareness to regionality, so that's why we recommend them.
jzelinskie
08/09/2022, 8:02 PM> Your applications enjoy quick data access regardless of the number and location of secondary Regions, with typical cross-Region replication latencies below 1 second.
from https://aws.amazon.com/rds/aurora/global-database/
jzelinskie
08/09/2022, 8:03 PMIt looks like there is still regional replication lag, so you can consider Aurora to be a similar experience to manually scaling out a regular Postgres/MySQL to multiple regions with the typical replication delay.
jzelinskie
08/09/2022, 8:04 PMIf there are things we can add to the Postgres or MySQL datastores in SpiceDB to improve consistency on Aurora, we're definitely game for supporting it. Just file an issue if you find something.
g
gub98
08/09/2022, 8:07 PMgot it, appreciate the quick responses!