Containers are just processes, and SQLite is actually great at read concurrency provided you ensure only one process is writing to it at a time.
This post has more details on exactly what @segment are using their local relocated SQLite database for https://segment.com/blog/separating-our-data-and-control-planes-with-ctlstore/ …https://twitter.com/rbranson/status/1214648084761739266 …
-
Show this thread
-
Do I read this correctly that the system is now risking synchronisation issues and is inherently single-system-image?
1 reply 0 retweets 0 likes -
Replying to @slightlylate @segment
I read it as SQLite essentially working as a local-per-instance cache of their core MySQL database. They have ~50GB of SQLite relational data on each instance and a polling mechanism that updates each one with changes every few seconds.
2 replies 0 retweets 2 likes
Got it.
8:55 AM - 9 Jan 2020
0 replies
0 retweets
0 likes
Loading seems to be taking a while.
Twitter may be over capacity or experiencing a momentary hiccup. Try again or visit Twitter Status for more information.
& Web Standards TL; Blink API OWNER
Named PWAs w/
DMs open. Tweets my own; press@google.com for official comms.