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 …
Do I read this correctly that the system is now risking synchronisation issues and is inherently single-system-image?
-
-
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.
-
For their use-case (a control pane for configuration changes to their core streaming infrastructure) a couple of seconds of stake configuration data is acceptable
End of conversation
New conversation -
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.