Fork me on GitHub
#datalevin
<
2023-08-10
>
Kein04:08:42

Hi, from an architecture POV, are there best practices/references/discussions about horizontal database scaling ? I’d like to foresee the dynamics and risks when we scale. [Q1] Also as Datalevin is an operational database, if we want to sync data between database replicas, what might be the approach? [Q2] Is event-driven architecture one of it?

Huahai12:08:25

Q1, depends on your use case. There are a few options now. One db per user is good for some use cases. There are limits on the number of dbs you can open in one process depending on memory, OS, etc; a couple of thousands normally. Another option is to use the server mode. The distributed mode is on the roadmap, but it is way down the road

Huahai12:08:52

Read replica is also on the road map. Right now, you can watch the datalog connection to see changes