For each database, three replicas are maintained for each database that one provision. One of them is primary replica. All read/write happen on primary replica and other replicas are kept in sync with primary replica. If for some reason, primary goes down, other replica is promoted to primary. All this happens under the hood.
(Read more here http://bit.ly/sql-interview)
For each database, three replicas are maintained for each database that one provision. One of them is primary replica. All read/write happen on primary replica and other replicas are kept in sync with primary replica. If for some reason, primary goes down, other replica is promoted to primary. All this happens under the hood.
(Read more here http://bit.ly/sql-interview)
No comments:
Post a Comment