In today's Live Session, we discussed How to Replicate a Database across many machines.
We focused on a specific type of replication - Asynchronously replicating a Relational Database across a single machine.
Let's say you are running a website on a single database hosted on a single machine. Now, you're seeing traffic spike up so you want to add a replica for the DB. You want to replicate the database but since your application is not write-intensive, you want to create a read replica. It can be replicated asynchronously.
We went over different approaches and had a very detailed discussion about it. Notes below.
To access these sessions live, please sign up at Interview Camp