9 ms·
Do you need to store data? If yes, how is it replicated over multiple datacenters? If yes, does failover work flawlessly?
by static_noise 10y ago
Do you need to store data?
If yes, how is it replicated over multiple datacenters?
If yes, does failover work flawlessly?
- ZenoArrow 10y ago> "If yes, how is it replicated over multiple datacenters?" Depends on the database engine used. For example... https://msdn.microsoft.com/en-gb/library/ms151799.aspx https://msdn.microsoft.com/en-gb/library/ms151799.aspx >"If yes, does failover work flawlessly?" Again, depends on the database engine used. To use SQL Server as an example again... https://technet.microsoft.com/en-us/library/ms189590(v=sql.105).aspx https://technet.microsoft.com/en-us/library/ms189590(v=sql.1...
- brazzledazzle 10y agoTraditional clustering with SQL Server is a huge pain in the ass. When it works (most of the time) it works well but failures can get hairy quick. There's tradeoffs but if you can make it work AlwaysOn is so much easier to deal with from an ops perspective.