Always on Availability group (AG) cluster in SQL Server
2.8 هزار بار بازدید -
پارسال
-
In this video, I am
In this video, I am going to introduce the concepts of Always On availability groups that are central for configuring and managing this type of cluster.
At first, I will show you why AG is needed and created, how it functions at high level. Afterwards, we will dive more deeply into internals of AG and I will show you in very much detailed way how AG works internally.
If you are building, troubleshooting or trying to understand AG cluster you find this video very useful.
Chapters
0:00 - Introduction
0:38 - Why AG is needed?
1:46 - Important features and concepts of AG: primary/secondary replica, listener, WSFC, data sync etc.
10:37 - Synchronization commit modes: Asynchronous-commit and synchronous-commit
14:05 - Internals of AG
21:24 - Disaster recovery solution: Manual, automatic and forced manual failovers
31:27 - Summary
Useful documentations on building multi region and multi subnet AG cluster:
https://learn.microsoft.com/en-us/azu...
https://learn.microsoft.com/en-us/azu...
📚 ►SQL Server internals: SQL Internals
📷 ►Follow me on Instagram - https://www.instagram.com/arslanov_bo...
🧑💼►Follow me on LinkedIn - LinkedIn: bobirmirzo-arslanov-548960173
Watch all my playlists here:
🚀►Full course on Encrypting connections to SQL Server- Full course on Encrypting connections...
🚀 ►SQL Server replication session: SQL Server replication
🚀 ►SQL Server Always On Availability Group: SQL Server Always On Availability Gro...
🚀 ► Full course on Troubleshooting sessions: Troubleshooting
🚀 ► Course in On-memory OLTP: Course on In-Memory OLTP
At first, I will show you why AG is needed and created, how it functions at high level. Afterwards, we will dive more deeply into internals of AG and I will show you in very much detailed way how AG works internally.
If you are building, troubleshooting or trying to understand AG cluster you find this video very useful.
Chapters
0:00 - Introduction
0:38 - Why AG is needed?
1:46 - Important features and concepts of AG: primary/secondary replica, listener, WSFC, data sync etc.
10:37 - Synchronization commit modes: Asynchronous-commit and synchronous-commit
14:05 - Internals of AG
21:24 - Disaster recovery solution: Manual, automatic and forced manual failovers
31:27 - Summary
Useful documentations on building multi region and multi subnet AG cluster:
https://learn.microsoft.com/en-us/azu...
https://learn.microsoft.com/en-us/azu...
📚 ►SQL Server internals: SQL Internals
📷 ►Follow me on Instagram - https://www.instagram.com/arslanov_bo...
🧑💼►Follow me on LinkedIn - LinkedIn: bobirmirzo-arslanov-548960173
Watch all my playlists here:
🚀►Full course on Encrypting connections to SQL Server- Full course on Encrypting connections...
🚀 ►SQL Server replication session: SQL Server replication
🚀 ►SQL Server Always On Availability Group: SQL Server Always On Availability Gro...
🚀 ► Full course on Troubleshooting sessions: Troubleshooting
🚀 ► Course in On-memory OLTP: Course on In-Memory OLTP
پارسال
در تاریخ 1402/03/26 منتشر شده
است.
2,838
بـار بازدید شده