3 ms·
What is MSSQL's replication story these days? Master/slave or master/master? Automatic failover?
by lobster_johnson 10y ago
What is MSSQL's replication story these days? Master/slave or master/master? Automatic failover?
- technion 10y agoThe short of it is that it's pretty good. They call it "Always On", and you can do both asynchronous and synchronous, with the latter offering automated failover.
- sovnade 10y agoAutomatic failover with read-only replicas. No master/master - that's the only thing I would consider missing compared to Oracle. It scales up, but not out. Peer to peer replication technically is master/master, but calling that clunky would be a kindness.
- deleted 10y ago[deleted]