3 ms·
I don't really understand this - what is an out of production read replica? Why wouldn't it just go to a production read replica? And what is an "analytics db"
by robertlagrant 1y ago
I don't really understand this - what is an out of production read replica? Why wouldn't it just go to a production read replica?
And what is an "analytics db" in this context?
- gkalin59 1y agoYou stream CDC events to have a 1 to 1 read replica in something like Snowflake/Databricks where you can run all kinds of OLAP workflows on this analytics db replica.
- robertlagrant 1y agoOh, sure, but wouldn't the whole website be served out of a read-friendly database? Why would you have a separate "analytics" database to the main database(s) driving the site?
- erulabs 1y agoIn general just avoiding mixed types of load. Predictable, audited application queries in a user request shouldn’t be mixed with potentially extremely expensive long running analytics queries. Different replica sets isolates customers from potential performance impacts caused by data analytics.