Thanks guys for this brainstorm.
Thanks guys for this brainstorm. Multiple independent DB's isn't something I can do. I needed one DB, with read and write replicas. Where the write happens also to the nearest DB but would eventually propagate to all others.
11 Replies
Unknown User•3mo ago
Message Not Public
Sign In & Join Server To View
ah thank you
im new to thinking about this stuff.
so its not very likely to just write to the nearest one with trade-off of if anyone reads from the others they wont have up to date info?
Idk doesn’t Cassandra/Scylla support this?
Unknown User•3mo ago
Message Not Public
Sign In & Join Server To View
thanks guys. im trying to use d1 in eventually consistent mode. because my use case is i have churches which is geographically based. so everyone hitting and reading it from that matter is just people in that church. in the extreme rare case, support member helps out and he'll know to wait 1s before expecting things. and in a more extreme rare case, we have random users around the world curious to look at profile pages of churches around the world.
Unknown User•3mo ago
Message Not Public
Sign In & Join Server To View
Thanks very much for asking! That's a great point on the isolation. However there are cases where Churches work with each other. Like shared donation box, or shared event. The most common use case is the ability to follow multiple Churches, and 30% of users do that.
Unknown User•3mo ago
Message Not Public
Sign In & Join Server To View
Thanks very much for all the thoughts here!
My reads are low as all pages are static with Next.js ISR (incremental static regeneration - https://nextjs.org/docs/pages/building-your-application/data-fetching/incremental-static-regeneration ) - so I only experience problems when people are enrolling into events and its slow or admin dashboard is writing.
Unknown User•3mo ago
Message Not Public
Sign In & Join Server To View
Thanks @algads and everyone for the awesome brainstorming and intro here!
I didn't know writes across regions is sub 500ms thats very cool. That makes it not a problem.