lead engineer interview questions shared by candidates
How would you measure the downtime required to perform this database migration?
The database size would determine the downtime needed to perform the migration.
Multiple factors affect downtime. You should start with planning an approach that minimizes it by taking into account factors like DNS changes, network latency, data rate of change and of course data set size too. Replication and load balancing could be other factors. The more points you mention and consider, the better the answer.