Тёмный

SQL AlwaysOn High Availability step by step Part 1 

Enayat Meer
Подписаться 3,5 тыс.
Просмотров 57 тыс.
50% 1

AlwaysOn Availability Groups (SQL Server)
The AlwaysOn Availability Groups feature is a high-availability and disaster-recovery solution that provides an enterprise-level alternative to database mirroring. Introduced in SQL Server 2012, AlwaysOn Availability Groups maximizes the availability of a set of user databases for an enterprise. An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of read-write primary databases and one to four sets of corresponding secondary databases. Optionally, secondary databases can be made available for read-only access and/or some backup operations.
An availability group fails over at the level of an availability replica. Failovers are not caused by database issues such as a database becoming suspect due to a loss of a data file, deletion of a database, or corruption of a transaction log.
In this Topic:
• Benefits
• Terms and Definitions
• Interoperability and Coexistence with Other Database Engine Features
• Related Tasks
• Related Content
Benefits
AlwaysOn Availability Groups provides a rich set of options that improve database availability and that enable improved resource use. The key components are as follows:
Supports up to five availability replicas. An availability replica is an instantiation of an availability group that is hosted by a specific instance of SQL Server and maintains a local copy of each availability database that belongs to the availability group. Each availability group supports one primary replica and up to four secondary replicas. For more information, see Overview of AlwaysOn Availability Groups (SQL Server). Important
Each availability replica must reside on a different node of a single Windows Server Failover Clustering (WSFC) cluster. For more information about prerequisites, restrictions, and recommendations for availability groups, see Prerequisites, Restrictions, and Recommendations for AlwaysOn Availability Groups (SQL Server).
===========================================

Опубликовано:

 

10 фев 2018

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 54   
@mariyumgee7515
@mariyumgee7515 3 года назад
Sql has always been a headache for me but I’m glad I got to know abt it through ur channel, makes my life a lot easier 🤤😪❣️
@salahsadeq2868
@salahsadeq2868 3 года назад
Excellent video
@nazakkatkhan114
@nazakkatkhan114 5 лет назад
Excellent video, not sure how someone thumbs down these kind of unique very simple to understand a very hot topic videos Love these explanations
@larryrodriguez7166
@larryrodriguez7166 5 лет назад
Great sequence with the very simple explanations
@enayatmeer7598
@enayatmeer7598 4 года назад
Many Thanks
@gam3955
@gam3955 3 года назад
excellent, good rythme and all provided informations are useful. thanks 🙏
@cherylmatrasko2773
@cherylmatrasko2773 5 лет назад
Good technical video! Thank you for sharing!
@enayatmeer7598
@enayatmeer7598 4 года назад
Thanks a lot
@asmalovely8064
@asmalovely8064 4 года назад
Great video and very nice explanation. Thank you so much!
@enayatmeer7598
@enayatmeer7598 4 года назад
Thank You Asma, appreciated
@redwest7617
@redwest7617 5 лет назад
Thank you for this!
@enayatmeer7598
@enayatmeer7598 4 года назад
Many Thanks
@guddigee2471
@guddigee2471 2 года назад
Amamzing content ..was so glad to see the eau u explained it
@enayatmeer7598
@enayatmeer7598 2 года назад
Thank You
@nazakkatkhan114
@nazakkatkhan114 4 года назад
What a nice explanations- How dare someone can thumbs down this video? Maybe those people who are newcomers in SQL world
@enayatmeer7598
@enayatmeer7598 4 года назад
Appreciated
@ursenthils
@ursenthils 5 лет назад
Good job sir
@enayatmeer7598
@enayatmeer7598 4 года назад
Thank You, appreciated
@harismir3319
@harismir3319 3 года назад
Grest work
@ash3rr
@ash3rr 3 года назад
For SQL 2017 HA solution using a file share witness for quorum, do we also need to provision shared storage between the windows failover cluster?
@seyma6627
@seyma6627 Год назад
Thank youuu
@arefin932
@arefin932 5 лет назад
Excellent Tutorial. I do have a question though. For configuring applications with the databases we need to point applications to the Listener IP address, Correct ?
@enayatmeer7598
@enayatmeer7598 4 года назад
In SQL Server Always On, we can define a SQL Server Always On Availability listener for all user connections. A virtual network name always points to the primary replica. The client application does not need to know the underlying configuration of Always On replica
@cherylmatrasko2773
@cherylmatrasko2773 5 лет назад
Question please. Why is the quorum called a witness? Quorum is just a separate drive space for the cluster configuration correct? Is the witness a separate server? Thanks much, Cheryl
@enayatmeer7598
@enayatmeer7598 4 года назад
A Windows File Share Witness is a file share that is available to all nodes in a high availability (HA) cluster. The job of the Witness is to provide an additional quorum vote when necessary in order to ensure that a cluster continues to run in the event of a site outage
@ash3rr
@ash3rr 3 года назад
@@enayatmeer7598 if we are using windows server 2016 and use node majority voting, do we need the quorum drive?
@wilvalencia3018
@wilvalencia3018 5 лет назад
Hey enayat, what is the minimum number of nodes that i can have to deploy always on availabiity groups?
@Chcwdikk
@Chcwdikk 4 года назад
2
@enayatmeer7598
@enayatmeer7598 4 года назад
also check this link: blogs.msdn.microsoft.com/samlester/2017/03/14/what-is-the-minimum-number-of-alwayson-nodes-required-to-obtain-both-ha-and-dr/
@spideyspider3865
@spideyspider3865 2 года назад
what is the DNS you use and how please write a short note...
@dmac5808
@dmac5808 4 года назад
I like your tutorial, do you do training ?
@enayatmeer7598
@enayatmeer7598 4 года назад
Thank You. Unfortunately, currently I am busy with several projects but, will continue to post new videos. If you have any specific question, please feel free to send me an email.
@AtulKumar-lx4iy
@AtulKumar-lx4iy 4 года назад
at 9:56 why remaining 3 nodes are not displaying, like earlier all nodes were displaying ??
@enayatmeer7598
@enayatmeer7598 4 года назад
Because, this is your choice if you want to add a list of servers from "Add Server" option from server management. I did not use that option to add additional servers from server manager. Its very common to add or do not add servers for remote managements. If you still have a question, send me email.
@enayatmeer7598
@enayatmeer7598 3 года назад
Please find detailed answer from my failover cluster videos
@binumhaneef
@binumhaneef 4 года назад
getting error after creating cluster, ' the system couldnot find the environment option", what could be the issue
@enayatmeer7598
@enayatmeer7598 4 года назад
Make sure perquisites met. Run cluster verification wizard to single out the source of the issue
@Jeffordsays
@Jeffordsays 3 года назад
Hi Sir Enayat Meer, Can I have a copy of this document? Thanks!
@enayatmeer7598
@enayatmeer7598 3 года назад
Please access my website for my dropbox link www.ny1technology.com
@sopheakvlogs
@sopheakvlogs 3 года назад
could u share doc?
@enayatmeer7598
@enayatmeer7598 3 года назад
please get it from my dropbox link under the ADMT video series (description)
@physophak4581
@physophak4581 5 лет назад
do you have full document for practices?
@nazakkatkhan114
@nazakkatkhan114 4 года назад
phy sophak I found a Dropbox link from author’s website Www.ny1technology.com for his shared documents Link was sent to me upon request
@enayatmeer7598
@enayatmeer7598 4 года назад
@@nazakkatkhan114 This is correct. Please acess my dropox from my site
@rajneeshsaini2983
@rajneeshsaini2983 3 года назад
@@enayatmeer7598 plz share the same. i would be thankful
@enayatmeer7598
@enayatmeer7598 3 года назад
@@rajneeshsaini2983 please get it from my dropbox link under the ADMT video series (description)
@aguafria9565
@aguafria9565 3 года назад
The music is distracting.
@enayatmeer7598
@enayatmeer7598 3 года назад
I will try to make videos without music: Thank you and sorry for the inconvenience
@mirzajameel7328
@mirzajameel7328 4 года назад
slow
@enayatmeer7598
@enayatmeer7598 4 года назад
Don't want to go fast in order to keep balance as per audience requirements
Далее
WoT Blitz. Late Night Birthday Lotto + Gifts and Presents
1:07:55
Kerberos Authentication Explained | A deep dive
16:52
Просмотров 328 тыс.
Intro to AWS - The Most Important Services To Learn
50:07
High Availability Options for SQL Server
1:33:53
Просмотров 8 тыс.
WoT Blitz. Late Night Birthday Lotto + Gifts and Presents
1:07:55