- all questions are based on: a. Stand Alone Servers b. No shared storage c. All are on the same subnet (except for DR) 1. How would you do HA & DR for SQL 2019/2022 in docker containers, and have AlwaysOn AG /w Listener? 2. Can you have HA & DR on 2/3 Windows Server 2022 Core + SQL Server 2022, With AlwaysOn AG /w Listener? 3. Can you have HA with just SQL Server 2022 docker containers with AlwaysOn AG /w Listeners? 4. How do you do failover for HA & DR on SQL Server 2022 in docker with ALwaysOn AG /w Listener? Please & Thanks.
My responses below: 1) Why do you need to run Always On Availability Groups on Docker containers? 2) Yes 3) Same as #1, why do you need it to be on Docker containers? 4) Same as #1, why do you need it to be on Docker containers?
@@EdwinMSarmiento it should be the cheapest way to have HA is terms of resource. containers are easy, but unless you are using shared storage to start up a new host you will have data loss. Plus, I just wanted to know if it's possible. With AG the data should stay synced, that way you don't have to worry about the container if one goes down, just auto start a new one & sync the data.
@@fbifido2 What are your HA goals? RPO? RTO? It is possible to do what you want. But without having a clear HA goal - RPO/RTO/SLA + the apps connecting to the DB - what's the point? Start with defining the goal as clearly as you possibly can
please release the audio format in below podcasts channels as it helps listening while commuting/working.
thanks
The audio of this recording is going to make me lose my sanity
Okay it got better after the first couple of minutes. It sounded like some kind of noise cancelling thing being used in noisy environment.
- all questions are based on:
a. Stand Alone Servers
b. No shared storage
c. All are on the same subnet (except for DR)
1. How would you do HA & DR for SQL 2019/2022 in docker containers, and have AlwaysOn AG /w Listener?
2. Can you have HA & DR on 2/3 Windows Server 2022 Core + SQL Server 2022, With AlwaysOn AG /w Listener?
3. Can you have HA with just SQL Server 2022 docker containers with AlwaysOn AG /w Listeners?
4. How do you do failover for HA & DR on SQL Server 2022 in docker with ALwaysOn AG /w Listener?
Please & Thanks.
My responses below:
1) Why do you need to run Always On Availability Groups on Docker containers?
2) Yes
3) Same as #1, why do you need it to be on Docker containers?
4) Same as #1, why do you need it to be on Docker containers?
@@EdwinMSarmiento it should be the cheapest way to have HA is terms of resource. containers are easy, but unless you are using shared storage to start up a new host you will have data loss. Plus, I just wanted to know if it's possible. With AG the data should stay synced, that way you don't have to worry about the container if one goes down, just auto start a new one & sync the data.
@@fbifido2 What are your HA goals? RPO? RTO?
It is possible to do what you want. But without having a clear HA goal - RPO/RTO/SLA + the apps connecting to the DB - what's the point?
Start with defining the goal as clearly as you possibly can
Best topology to set up Always on between 3 data centers
Very good lesson!!
Looks and behaves very much like an Exchange DAG