Can anyone explain this with an example please.
Thanks in advance.
Type your question above this line.
Course: https://www.educative.io/collection/5668639101419520/5649050225344512
Lesson: https://www.educative.io/collection/page/5668639101419520/5649050225344512/5728116278296576
Hi @Vinay_Kumar,
Yes, it is possible to scale relational databases across multiple servers, and it is a challenging and time-consuming process.
The idea to scale relational databases is to have a master database, with slave databases on multiple servers continuously copying data from the master database. When the master goes down, you flip a switch and go off a slave. You lose some data during the switch, but that is often preferable to not working until the DB comes back up.
To scale a relational database, the first step is usually to load balance with a read-only slave. That is a duplicate (via replication) of your master server, and you can direct heavier reads to the slave. The slave is not guaranteed always to be current, so you need to send reads to the slave where it is fine if they are a little behind (like long-running report type queries or queries for data that doesn’t change much).
Most of the Fintech companies practice this technique.
I hope I have answered your query; please let me know if you still have any confusion.
Thank You 