Timeline for SQL Server 2016 Availability Group - 2 Nodes as Primary & Readable Secondary, 1 Node as DR
Current License: CC BY-SA 4.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 20, 2018 at 1:44 | vote | accept | ktsrg | ||
| Jul 23, 2018 at 14:06 | comment | added | Goforebroke | You will also want to monitor the AO synchronization status and latency between the nodes and generate alerts as needed. This can be done with home grown scripts and native sql alerts or with 3rd party monitoring tools | |
| Jul 23, 2018 at 13:56 | comment | added | Goforebroke | 2 of 3 votes are needed in above scenario to keep the cluster online. So if you lose two voting members at the same time in the primary data center the cluster goes down. | |
| Jul 23, 2018 at 5:23 | comment | added | ktsrg | if node 1 and 2 down, will WSFC cluster become offline? because there are only 1/3 (less than one-half) of the voting nodes in the cluster | |
| Jul 23, 2018 at 4:17 | history | edited | Goforebroke | CC BY-SA 4.0 |
edited body
|
| Jul 23, 2018 at 4:09 | history | edited | Goforebroke | CC BY-SA 4.0 |
edited body
|
| Jul 23, 2018 at 3:13 | history | answered | Goforebroke | CC BY-SA 4.0 |