Transcript for:
High Availability and Disaster Recovery with Windows Failover Cluster

this conference will now be recorded okay once again very good morning and uh thanks for joining uh so as part of today's session we are going to start the one of the High availability and Disaster Recovery that is Windows failure cluster okay next three to four session we are going to discuss completely on complete on the windows on Windows failure cluster how to create Windows failure cluster how to deploy SQL on cluster till no whatever you've done is a standalone SQL whatever we completely practiced and whatever you've done in the that is nothing but SQL on Standalone now we are going to install C colon cluster so when you go for SQL and cluster what are the advantages what are the disadvantages how to configure what are the additional things you need to take care what are the way Services what is unaware services and how to troubleshoot all this we are going to discuss next two to three sessions and each and every property of Windows failure clusters so that you will be so confident how to create Windows failure cluster in on Services how to create Windows failure cluster on azure okay being we already discussed about how to deploy the virtual missions now you are you are somewhat good at how to deploy the virtual missions if you know how to deploy the virtual missions you're almost good you are good to deploy the windows failure cluster okay apart from this uh that's what my request to everyone batch 39 and Bash 38 even even for bass 37 as also okay please be available for next 15 to 20 days with me you you waited for a long time but again just bear with me for 15 to 20 days every day we are planning for two sessions uh morning will go for regular seasons evening will go for additional Concepts so mostly tomorrow you will get it how to uh create the visuals to how to install the visual studio how to install the data tools okay being we are a database administrator that is also very important sometimes you may also get a chance to install the data tools to install the visual studio so how to install Visual Studio how to install the data tools how to create SSS packages basic I'm not going for deeper dive but how to create the basic SSS packages we are going to discuss over the evening part that's that is one thing okay please be available next 20 to 25 days with me maximum content I'm I'm going to share with in this 22-25 days come with multiple questions the people from 38th batch 37 page you've already done and maybe you are you already got opportunity to work in real world the people who are starting your journey Stay With Me the market is now okay it is starting and we are getting uh a number of calls okay please please stay with me and pick the calls and schedule it let's see everything will go for very smooth okay so stay with me for next 20 to 25 days uh spend more time please be available in the sessions and we already created the discussion group any questions any doubts go for the discussion group sorry it can be small query or or it can be somewhat very interesting or you are struggling something just doing the discussion group that is very very important okay so instead of in case the people who are not not already part of the discount group just rise your hands I am not part of Discussion Group I will add you into the discussion group that is a one thing okay today I will add everyone the people who are missed our people is not part of the discussion group and the people who are not part of the job Seeker group okay so Gautam and Shiva they are coming to me because they are near to me and they are receiving multiple calls the people who are other people okay please uh stay with me definitely we'll place as soon as possible okay once the market is somewhat good now so we completed log shipping except troubleshooting we completed mirroring except troubleshooting and we completed replication except troubleshooting so these three concept a basic concept we already done how to configure how to do the failover except block shipping manual failover okay so what is the application how to configure application what are the jobs everything we discussed let's discuss the troubleshooting part as well this week okay along with the replication log shipping and mirroring along with will also we are planning to complete the ssis part as well how to deploy how to create the visual studio how to uh install the data tools how to create an ssdb how to deploy one package in sssdb and how to migrate sshdbs uh everything we will discuss about sshdb this whole week will complete the block shipping mirroring replication troubleshooting along with the ssisdb complete end-to-end complete along with in morning session we'll discuss clusters once we complete the cluster we'll go for the always on availability group okay so we'll go for in sequence please be available adjust your time here and there okay just spend some more time with me for next 25 days I'm not asking too much just 25 days will complete everything in 25 days okay hope everyone clears yes yes so get get all your questions doubts again one things are nowadays everyone is asking to come to the interviewer for at least one round at least one down so please prepare for interview okay so that's the major reason I just pulled 37 batch 38 batch and 39 batch okay the people who noted placed from these three batches okay just join this batch get all your questions doubts definitely will will place it's a one good news last week I I already repeated but again I'm repeating last week one of our student got placed in uh one of the reputation company IBM okay I cannot reveal the name name of the student but he placed in IBM okay definitely you people also will place okay so ask a number of questions because at least you should handle the interview now that's the major goal why are you just pulling again 37 38 and along with the current batch okay just stop me get your questions prepared by your questions what kind of questions they are asking make a note okay we are having the discussion group post your work for example you are attending one interview post you all your questions so place two resumes on the portal level now Curry or Monster or LinkedIn okay nowadays you should also apply everything in the LinkedIn as well you can do in LinkedIn so three different places okay one resume generally you can place it one resume you can so so you can prepare in place and whatever the getting calls you can try to attend those calls okay so that you will get somewhat confidence so what kind of questions are asking where I'm standing what kind of question answers I am giving to the interviewer whether they are impressing or not so try to First grab the interviews that is very important now self interviews is very important for everyone okay that is one thing again I'm repeating in case if someone is asking we are having opening blah blah something just contact me immediately I will give you the session whether you should okay apply for that job or not okay whether we can trust him or not don't simply blame and don't simply waste your amount that's the only one thing now where good sir any questions up to here so I am just pulling 37 38th batch as well because almost 36 batch today 37 batch also almost they placed no one left 38 and 39th batch only still we are we are having uh difficulty replacement okay so that's the reason again I pull you people as well so that you will you have whatever the questions you you're not able to answer to the interviewer if someone is asking so clarify all your questions and doubts okay and this week I'm also planning for the mock interview definitely sir okay this week I will come up with a mark interview please prepare till replication everyone whatever we discuss still replication everything you should prepare okay yes no yes sir yeah okay yes sir okay please be attend everyone my main intention is everyone should placed okay because you already paid amount to me okay again the market is not good for not only this technology all the Technologies little bit tough Market okay for next one or two months that time whatever the calls we are receiving we should be somewhat more careful okay somewhat more careful so whatever the mock interview I'm going to ask almost you will get same sort of questions how to answer those questions basic part okay this week and next week we'll go for somewhat advanced level mock interview again we'll go for somewhat advanced level mock interview okay okay yeah that's it let me start it okay now we are going to start one of the awaiting future that is Windows failure cluster most of the people are waiting for Windows failure clusters on always on availability group this week we are going to discuss complete about Windows failure cluster configuration part failover fail back okay properties along with the troubleshooting completely end-to-end troubleshooting and how many simplest techniques are there to to troubleshoot the cluster logs because whenever you generate the cluster log you will get more log info it's very difficult to analyze that log info will see some simplified techniques so that you can analyze the cluster log in the easiest mechanism okay that's what so first let me ask a question okay to to the people everyone what is Windows failure cluster w share FC so Windows failover cluster it's referred to a group of servers that work together to provide a high availability to applications and services if one of the server goes down another server in the cluster can assume the workload with either minimum time or no down time okay any other answers out of 14 people mostly Azar is responding everything what about rest what about rest any difficulty to answer foreign yes no the people who are working if they are not answering no issue for me because they already stay stable in the organization the people who are starting Journey why you people are not answering anything if I'm asking questions I hope you already watched all the sessions like Gotham why are you there yes sir yes then why you are not able to answer no I'm just simply getting ready because if you are answering in front of this many people okay you will you will you will get you may lost your fear okay please try to answer I don't want force uh individual names okay either it can be wrong or it can be right okay you should answer okay Gotham please make this as a habit if you are just simply connecting and just putting on mute no need to join at all okay the people who are maybe the people due to lack of uh urgent work or they're they're in different shifts the people who are not able to attend the live sessions again I'm requesting them okay then the people who are not not working why you people are not joining I'm not sure join for at least for two months sorry 20 days these 20 days are very critical when we are discussing lot of technical stuff here itself very technical whatever we just now whatever we are discussing next this 22-25 days that is very critical for everyone okay now Windows failover cluster something happened to this database I can bring another database to all normal downtime because then supports automatic failure right you must runs would require minimal downtime but if you go for database mirroring it is also database level it's also DB level okay with no downtime or very very minor minimal downtime so in case suddenly something happened to Prince say you're not on Audible or not Audible okay everyone able to hear I said okay okay uh where you lost everyone you were saying something about database failover let me again okay let me recall everything okay so if you go to the log shipping log shipping is a database level okay where it required some sort of downtime definitely because it doesn't support automatic payload but you need to do manual failover correct you need to do the manual failover when you go for database mirroring it supports automatic failover with no data loss you can move your entire data with the minimal to minimal downtime with minimal to minimal downtime if you go for application it's object level where you can replicate multiple objects to the different location and you can balance the load you can you can perfectly balance the load means whatever the tables you are going to perform mostly read operations you can move the data to the subscriber instance and you can tell to your application team hey you can read the data from the subscriber instance so that you can balance the load all the rates go for the subscriber all the rights will go for the publisher instance all the rights will go for the publisher instance that is how you can balance the load but what is Windows failover cluster okay a lock shipping where we are going to maintain the database mirroring where you are going to maintain the database replication where you can maintain the database or maintain the objects it's completely SQL level high availability SQL level Disaster Recovery agree not agree SQL level where you are going to maintain but if you go for Windows failure cluster it's a instance level failover instance level if something happened to the server something happened to the server something happened to the any one of the resources okay interior instance resource will replicate will move to the another node so for example this is technical you should call it as a no sir in in specially when you go for clusters you should call it as a notes how many nodes are going to part of cluster how many nodes are going to part of cluster like if you go for uh log shipping you are calling as a primary server secondary server primary database secondary database in mirroring you will call it as a principal server mirror server principal database mirror database in in replication you are calling is a publisher distributed subscriber like say if you go to the windows failure cluster every server or which is going to part of this cluster which is going to part of this cluster you should technically call it as a notes should technically call it as a notes so for example this is my server one server this is one more server this is one more server this is I am calling as a simply node one this I am calling as a node two if suddenly something happened to this node okay whatever the resources you are running whatever the resources you were running like Services whatever the services are part of cluster are part of cluster all the services will move to the node to automatically essay instance level feature it's an instance level feature means whatever the services you are running on top of cluster on top of cluster whatever Services all the services will move will move to the node 2. we'll move to the node 2 means can you share yours you're not able to see my screen okay okay okay no thanks I was just yes yes okay okay nothing waiting for your skin and connecting but not able to see again oh okay okay okay now everyone able to see right yes yeah I was just about to ask you thank you now it's time sir no problem nothing I I drawn okay so now again let me repeat now every server whatever going to part of cluster you should call it as a technical nodes okay for example I'm having one node One servers are one server one more server with the name called node two this is node one that is node two now for example on top of this nodes whatever the services you are deploying on cluster cluster we'll see what is cluster all that stuff okay on top of that if something happened to this server something happened unfortunately suddenly this hour went down whatever the services you are running on top of the cluster all the services will move into the node two is a instance level feature it's not a DB level feature Windows failure cluster is a instance level Windows failure cluster is a instance level for better understanding everyone will think that okay Windows failure cluster is only for SQL Server no sir you can keep a number of services on top of cluster I will show you okay we'll see practical by tomorrow okay Windows failure cluster is not only for SQL not only for SQL like lock shipping is only for SQL mirroring only for SQL replication only for SQL okay always one is only for SQL but Windows failure cluster is not what sqls are not only for SQL you can keep n number of resources on top of Windows failure cluster you can keep n number of out of that SQL is also one resource you can keep storage on cluster you can keep Network on cluster you can keep VM on cluster you can keep IP on cluster you can keep that's what you can keep n number of services on top of cluster out of this SQL is also one service where you can keep on top of cluster where you can keep on top of clustered SQL is also one resource SQL is also one resource for your simple better understanding a cluster cluster okay cluster is a group of independent computer systems that will work as a together for example take this is my laptop sir and this is your laptop like for example Poonam laptop okay both laptops are working independently correct whatever the services I install in my laptop that is independent whatever the services you want to install on this laptop is independent but I decide okay let's work together let's work together so how you will group these two different devices into into one group how with the help of Windows failure cluster means with help of cluster you can group N number of servers that will work as a together as a unit hope your understanding sir everyone every system is working independently now every device see uh last to last session we deploy the VMS right we deploy Windows VM we deploy Linux VM every system is working independently and every system you are you are connecting and you are installing whatever whatever Services you want but if if I decide okay I need to work a multiple system to work together I need some sort of additional benefits okay how you can group that group you can do with help of cluster with help of colosomes on top of this VMS I am going to configure the cluster with help of cluster I can group the servers which they can work as a single unit hope you are getting it's not a sequence again what can confuse SQL not only for SQL you can keep a number of services on top of Windows failure cluster SQL is also one resource where you can keep on top of cluster on top of cluster what is cluster cluster is is a group is a cluster is a group where you are going to group multiple servers to work together see a cluster is a group of independent computer system refers as a nodes working together as a unified Computing resources as a as a unit as a single unit and a cluster provides a single name means so for example uh all these servers you are keeping one single name on top of that and you that name you should call it as a virtual name cluster virtual name okay while you are confident cluster you need one virtual name cluster virtual name and you need node information how many nodes are going to part of cluster along with IP address so we'll see one by one practical okay that's what see a cluster provides a single name for the for the clients to use and single administrator interface means you can open the free load cluster manager and you can handle everything by there you can failover you can fail back you can add you can add the disk you can do whatever you can in that interface in that cluster manager interface that sort of benefits you will get it sir when you go for cluster means in a simple items if someone is asking what is Windows failure cluster is nothing but group of servers where where it is working as a single unit hope you understand yes sir yes okay see Microsoft Microsoft servers provides three Technologies to support the clustering not only for resources even you go for Network load balancers you can balance the networks Network Network load balancers like we are going to we are not discussing about networks are we will discuss about the load balancers okay because how to create the load balancers why we need to create the load balancer especially for always an availability group all that stuff we are going to see in the next week so you can configure Network load balancers you can configure component load balancers and you can also manage the clustered services that is nothing but failure cluster manager so Microsoft came up with a different different techniques out of this out of this Windows failure cluster is also one technique not only were maintaining resources Microsoft is maintaining the components load balancer components Microsoft is maintaining Network balancers along with Microsoft it is also maintaining the failure clustered services hope you understand oh yes yes like in the back end cell so for example this is one server this is one more server which is working independently okay but I want to group these two worker work and to work together I wanted to first group these servers and tell tell to all the servers to work together means suddenly if something happened this server okay no worries I can bring the server to online already this hour is running okay but it will be it will be in stopper State and you can also balance the load here also you can also balance that technically we'll see one by one okay so Windows Pharaoh cluster is nothing but grouping of the multiple servers which are working together and each server technical you should call it as a notes each server you should technically call it as a notes now we'll see one by one sir first everyone must run should know about okay we we will configure clusters in two types one is Act 2 Act 2 cluster one is act two ASU cluster password cluster so we'll configure cluster in two types one is active Act 2 cluster one is active passive cluster one is active active cluster one is active passive cluster so first what is act 2 what is passive anyone extra you can tell in the last okay any answer so one server will be online and on other servers people will be stopped if anything goes wrong then it will fail over to other server and then SQL will be started on other server that is a secondary server okay very good but what is my question ma'am what is active actually means uh no my question is not what is active active my question is what is act two running I mean okay any other answer sir the application is connecting via active server right application is connecting via active server okay good good but any other answers what is active and the passive is like a standby no no forget about passive first let's see what is active the application running node we can call as active active node application node we'll call it as an okay okay everyone good sir now azer this is now you are done okay don't take negative Azure okay uh just I just want more of some more uh answers okay that's it yeah so sorry I have not referred to this you know topic it's okay no problem okay uh always that's what see uh what is active first okay the node where SQL is running wave SQL services are running that node you should call it as a active node fine everyone yes where your SQL services are running okay someone told that working someone told that running someone told that application is connecting okay I can agree with that one but what is actual content means the node where SQL services are running that node technically you should call it as a active node hope you understand no yes so the node where SQL services are running that node you should call it as a active node now what is passive node pasu SQL services are stopped okay you can you can tell if someone is asking in the interview what is passive node means the node where SQL is in the idle State means in the stopper State make a sense everyone the node weight SQL services are in idle settings nothing but stop so only one instance so for example I installed prod instance okay on both the server my prod instance is running only one server your SQL services will run sir in all servers your SQL services will be in the stopper state if you understand this logic you are almost good at the classes are please try to understand most of the people will confuse here itself okay this is okay node one okay this is node 2. this is node three now try to understand the Logics okay this is very important if you understand you're almost good at the cluster level okay now try to understand the logic sir now here prod I configured three node cluster this is completely three node cluster okay three node cluster where my currently this instance is running on node one it is acting as a active node and this is acting as a passive node this is acting as a passive node means idle nodes where your SQL services are in stopper state the node where SQL is running we'll call this active node the node where SQL services are in idle State we'll call it as a passive node that is what active and passive what is act two passive cluster what is active passive cluster means this is your active passive clusters only one node Waits your SQL is running rest all the nodes are acting as it just pass you no other nodes any SQL is running correct any node SQL is running sir except node one no sir no right so this when you see this sort of configuration assume sir in real world you will see two node cluster three node cluster four node cluster cluster maximum you may get four node or maximum you will get five node cluster okay whenever you open failure cluster manager whenever you open failure cluster manager you will see which node this instance is acting as a active means where my SQL is running that is very important sir and remaining nodes all are become the passive nodes only one node your SQL instance will run sir only at one node your SQL instance will run rest of the rest all the nodes will be in the idle node okay let me repeat same thing in Telugu ES that's it sir okay make a sense everyone okay so how many years before node or five node or three node only you go you don't see beyond that one you won't see beyond that one now sir for example This Server is having 64 cores and 250 GP of RAM This Server is also having 64 cores 250 GP of RAM 250 gpf Ram This Server is also having 64 cores and 250 GP of RAM now tell me my sequel is running only on node one node one right what about node 2 or node 3 there are just simply sitting idle not doing anything and you are wasting all your resources right 64 cores 250 GP of RAM simply wasting no one is using nothing sir until unless if something happened to node one either node 2 will come to online or Note 3 will come to online correct until something happened to node one your node 2 is sitting idle node 3 is also sitting idle you are simply wasting all your servers resources nothing they are not they're not doing anything right okay no yeah aggressor now they will come up with one strategy we we can also come up with one strategy so for example in the prod instance in the prod instance I am having 10 databases 10 DBS DB 10 DBS out of 10 DBS 5 databases are critical databases and five databases or so so databases social databases why we can keep all the 10 database in the same instance let's install one more instance let's install one more instance and I can keep that so-so databases file databases in that instance right agree not agree yes sir yeah what I'm doing I am going to install one more fraud one more fraud instance like prod one in all three servers and I am making to run that five databases in node 2 as acting as a primary now I am telling run the SQL services in node 2. this is acting as a active node and these two nodes as acting as a passive nodes magazines five databases are running in node one five databases are running in node two my performance obviously will improve right agree not agree yes you agree sorry if you're not understanding again I am repeat try to understand the logic I am having 10 databases all the 10 databases are critical assume all the tender databases are critical instead of keeping that 10 database in single instance why can't I keep that five databases one instance five databases another instance and one instance run in node one one instance let run in node two I can do it right yes you can so we have to install I mean yeah you can install two instances what what will happen nothing right so where your SQL is running that is very important where your SQL is running it is please be mute your SQL is running on node two I'm not worried MySQL is running on node 2 and my five database is running on node 2. okay it's okay then both to become actor accessible now it's become act two I am balancing the Lord I am Distributing the load so load balancers means simply uh right operations will go for this node read operations will go for not like this or okay technically we should understand little bit more okay so how you will improve the perform because sir if if you're not installing this instance if you are running 10 database in the server then whatever these two servers waste only right yeah for example your mom is having one car your dad is having one car and you are also maintaining one car okay but you you are maintaining three different cards the same cards only three cards and you are only using only one curve enter your family then what about the two cars no use right yes let's split the work then we are not wasting our resources we are improving the performance the performance will be too good okay but but again if something happened to to the to the node 2 your services will go to the node here right for example this is not available forget about this is not available if something happened to node 2 even Node 1 will become Prime will become active right yes or no and which need to handle 10 databases so that time obviously the performance will little bit impact rest the performance will be awesome pretty much good agree yes yes agree sir that's it sir what is active active cluster means if someone is asking what is active active we are okay uh both nodes SQL services are running means same instance no sir you never run same instance no difference instance you need to install one more instance okay here I mean so I'm running this instance here I'm running this instance now this is also acting as active this is also acting as active this configuration we'll call it as a Act 2 Act 2 cluster thank you sir Act 2 Act 2 only for you purpose not for SQL proposal okay for just your understanding purpose only active active coming to the picture not for sequel don't see from SQL point of view just you need to see where your SQL services are running that's it okay this instance is running on node 2 this instance is running on node one very simple answer sir now for example you got one more node now you got one more note sir okay you got one more node this node is also coming to the picture now this node is sitting pretty much idle no resources nothing just sitting Idols are this node is sitting idle now what you will decide okay let's install one more instance one more instance prod two sorry sorry let's install one more instance prod to instance and I can make this instance will run on node 3 and this acting as a passive note this acting as a passive note this is also acting as a passive node okay here also I am running couple of databases so that I I won't waste my resources at all I if something goes wrong here either this node will take responsibility or this node will take responsibility if this node goes down either this node will take responsibility this node will take responsibility how many active sorry how many passes you are maintaining how many actors you are maintaining that depends on your application configuration all that stuff so this is how real world will works so here we are not wasting any one of my resources every resource or running something running something hope you understand what is active active what is active passive passive is nothing but idle node which node for this instance this instance these two are passive for this instance this is passive this is passive for this instance this is passu this is passu you can add one more instance you can add one more server again subbu I am install I am I am maintaining three servers I need to install three SQL instance no sir you can maintain 50 instance how many instance you can install in one server how many instance OnePlus 49 total 50. here also 50 instance you can maintain sir because all these three computers are one computer you can maintain 50 instance in cluster with this SQL instance in cluster 50 instance in cluster I can install one more instance Pro 3. here it is acting as act two here it is acting as a passive here reading it is acting as a passive I am installing prod four here it is acting as act 2. here it is acting as a passive here it is acting as a passive broad file I'm installing here it is acting as act two here it is acting as a passive here it is acting as a passive total how many instance you can install 50 instance you can install on top of cluster on top of cluster one cluster maximum you can install 50 instance and depends on that you can install password sir pass you also 50 only same in which two notes are failed then node three will have a performance issue right and an impact obviously performance is so definitely will notice forget about performance issue I am not at all discussing performance levels sales moves to Note 3 right yes yes sir practical yeah okay logically if you understand what is active what is passive you are too good at clusters cluster any questions we'll see any questions if we have to do patching on servers on This Server first we will do that today today will today we'll eat vegetariani tomorrow we'll go for chicken biryani day after tomorrow we'll go for mutton Biryani man will give one by one okay forget about we'll see everything practical don't hurry let's stick with a concept you should understand the concept later on we'll we'll see okay we can install 50 servers node two we can also install the 50 instance right the cluster no all the three nodes you can install 50 either it can be active it can be passive only 50 you can install not 50 plus 50 plus 50 total 150 no sir yeah no okay 50 instance you can install either that can be passo or it can be active only 50 you can install where you are running SQL services that is very important on that respect to instance another important maximum only 50 instance foreign because all the servers are working together okay so in one cluster we can install only 50 instance right yes here each node is one server yes ma'am one server technically you should call it as a node map yeah okay how many nodes are going to part of cluster okay so two node cluster three node cluster four node cluster five node class dot six nuclear seven node cluster maximum you will see three to four node only in real world questions what is act two what is passive what is active active what is active passive first you need to clarify this any questions rajini the first time who are listening okay Prasad Shiva no no question sir okay good sir now no questions okay now let's so we'll discuss about what is act 2 Act 2 what is act two passive so how many types of clusters are there so two types of cluster one is active active cluster one is active passive cluster whatever the servers are going to part of okay that technical you should call it as a uh in this in in the other another terminology you can call it as a single instance multiple instance single instance is nothing but active Passover active passive multiple instances nothing but active active cluster in a simple for your understanding okay in other name what is the other name support to understand means if you go for active passive it's a single instance if you go for active Act 2 it's a multi instancer multiple instance correct otherwise yes or no yes multiple instances yes if you go for multiple instance only you can maintain active active if you go for single instance you can definitely should maintain only add to password that is what about active Act 2 and active pass user now you should know about little bit components okay components a little bit what are the major components everyone must and should know to Sir again Windows failure cluster if you wanted to build completely you need Windows in real world sir again special if you go to the real world maybe whatever we are doing from tomorrow tomorrow we are going to configure right tomorrow we'll complete the configuration sir tomorrow whatever we are conferring maybe you never get a chance maybe you you may not get a chance in real world okay because in real world we are having Windows team we are having network team we are having storage team but here no one is available we are doing everything sir to do the Practical right so it will be little bit complex whenever we see starting first time but you will get so confident if you do do from the scratch definitely nowadays more on the interview questions on always on cluster more questions you are getting from always on cluster Performance Tuning replication these are the major four Concepts okay so that's the reason I'm bringing multiple question question and answers always on deleted cluster related replication related performance related so that's the reason I am requesting everyone please be join at any cost okay any cost no so when you try to configure first time you will you will get little bit bored okay little bit bored because why we are doing all that stuff because here no one is available we are we are acting as a Windows stream we are acting as a network team we are acting as a security team yes I have this question then this Fitness failure cluster is like instance level high availability and as well as Windows yes right okay instance level instance level okay so simple because on top of cluster SQL is also one resource uh brush shaker like we can keep a number of resources you can keep stories you can keep Network you can keep IPS okay you can keep DNS you can keep gender scripts so you can keep a lot out of that SQL is also one resource SQL is also one resource it's a Windows Windows feature it's a Windows feature whenever you enable you will get one service that is nothing but cluster service if you if you open services.msc if you open services.msc if you wanted to understand okay whether my server contains wind whether my on my submission any Windows failure cluster feature is enabled or not you can see with the help of okay cluster so whenever you see the cluster service so you can search for clusters or visuals you will if you won't see any clustered service if you won't see any clustered service Miss This Server no cluster feature is enabled related feature is enabled when you see cluster related service then you will see okay something cluster related Services installed in this mission maybe that is for SQL maybe that is for something else hope you understand yes okay currently there is no SQL service cluster service not SQL service cluster service means nothing is installed now okay so before we we go and start installing Windows failure cluster conferring blah blah blah something you mustn't should know little build components are little bit about the all the components so let's go for here let's go for here in a simple terms I I what I mean to say okay if you go for uh single instance means you can call it as active passive cluster if you go for multiple instance means act to act to Cluster active actor cluster okay now technically technically every server you should call it as a notes node how many nodes are going to part of cluster how many nodes are going to part of cluster it's a two node class dot three node cluster four node cluster five node clusters okay that is a simple terminology sir what are the servers are going to part of this cluster configuration those servers technically you should call it as a nodes those serversy technically sorry you should call it as a notes now cluster services so once you configure cluster once you configured cluster so once you configure cluster okay you will get one servicer you will get one service that service is nothing but cluster service very very very very important very very important service when you especially working with cluster when you're specially working with always on availability group okay if something suddenly your age is not doing failover your cluster is not doing failover or not doing fail back or something is are happening you need to see whether cluster service is running or not okay we'll see all the question and answer is in the coming sessions first logo okay so whenever you install cluster feature whenever you install cluster feature you will get one service cluster Services the cluster service manages all the activities that is specific to the cluster specific to the cluster getting my point one server will maintain only one cluster service it sir how many instance you are installing I I can install two instance icon install three instance I can install four instance I can install five instance you will have only one cluster service that clustered service is going to take all the responsibility what are the responsibility it will take it's a it will manages cluster objects and configuration it it holds your cluster configuration information okay it holds okay policies policies restart policies okay the restart local restart we'll see all this one practically no worries just I am passing some hint what we are going to see in next two to three days two to three days in live practical it's not like a theoretical practical sir in live practical what we are learning that is very important just try to understand this clustered services will hold the configuration metadata information build holes will handle not holes are handled it's it's handle everything it's handled the managing the cluster objects and configuration is handle the local restart policies very very important I will see what is the restart policies okay it coordinates with other nodes it it will coordinate with other node node two node 3 node 4 node five node six okay hand is the event notification means writing all the cluster events information in the Event Viewer log in the cluster even logs okay that level and facelates the communication among other software components Okay so communication sir communication between other components it is going to handle perform the failure operation very very very very important failovering failover okay if if for example this is my two node cluster if suddenly something happened and this cluster Services down on node two suddenly something happened and cluster service is down on node two and same time Node 1 is also down due to some other reason will node 2 will fail over to node two sorry will Node 1 will fail out to node two no because node 2 already your cluster service is down if something happened and your cluster service is down and same time if node one is also down then gone then gone enter your services will downside because without cluster services your service won't come to online this service won't come to online so clustered service is very important service to make your services to run so please be careful if cluster service is down your it may also leads you what SQL is also down SQL is also down sir so please be careful cluster services will place one of the major role so these are all the things your clustered service is taking in the back end okay configuration information cluster objects information local restart policy information uh events handling information okay interacting with other node information especially failover information all this will be handling by your cluster Services you know right Master database Master database is hard for your Intel SQL later like same cluster service is very important cluster Services don't everything will goes wrong okay not okay yes yes sir okay that is one thing sir that is very one one most important concept everyone should remember one more sir okay so basically uh every every server there will be one public IP address correct which is using the communication purpose so here also same sir okay public IP address so public IP address is nothing but for communication purpose public IP address is nothing for communication purpose so specially if you go to the private iPad you need one more Link Card one more Nick card you need one more Nick card sir so every server whatever your server is going to part of cluster every server you need one more Nik card network interface card that is nothing but private IP address which especially working for heartbeat heartbeat heartbeat so private IP address so every server you need enable one more Nik card that is nothing but private Nik card to check the heartbeat of your cluster are you healthy as I'm healthy are you healthy as I'm healthy for example so that is how the art bit is keep on checking in the back end so private IP address further to check the heartbeat of your cluster hope you understand so here every server you need two IP address one is for public one is for private private for to checking the heartbeat public for two making the communication hope you understand heartbeat heartbeat is nothing but okay that's what I told you right are you healthy as I'm healthy are you healthy as I'm healthy that kind of information it is writing in the shade memory in the in the buffers in the buffer it it's writing the shade memory so heartbeat are the messages that clustered service regularly sending between the instance through cluster service via cluster Services via cluster Services your heartbeat message is passing between across the nose across the nodes so this is also very important terminology so notes is one of the important terminology cluster Services is one of the important terminology public network private Network heartbeat is also one of the important components all are these are components or components okay not okay okay sir no one of the most component here is storage and one of the major drawback is storage in entire Windows failure cluster the major one of the major drawback is storage part that is the major reason where Microsoft came up with the concept called always an availability group in the year SQL Server 2012 to overcome this major drawback with on Windows failure cluster SQL on failure cluster okay so basically if you go for SQL sir basically when you go for SQL on cluster when you go for C colon cluster okay what are the major thing is you can't store your data in the local disk local disk like in in take take your laptops or you you install the two instance or three instance or four instance on your laptop right everything you are installing C drive everything you are installing D drive correct you are keeping your databases backups everything in the in the in the local drives correct but when you go for SQL on cluster but when you go for SQL on cluster you can't store your data in the local disk so local disks are not possible nozer you need to create the share disks shared sandisks sand disk and you need to store your data in the Shader disks that can access node one can access no two can access so you need to create the shared disk and that shared disk can access node one can access node 2. but where did this disk can be visible wherever your SQL is running on that instance on that server this disks are visible this disks are visible so when you specially go to the cluster you can't store your data in the local disk you need to definitely go for the share disk that is a one of the major drawbacks because in case this disk goes down in case this disk goes down what will happen sir everything goes down cluster also down cluster wound down sir why cluster will down entire SQL will down right not cluster cluster Service never Downs up if sand goes sandbox goes on why cluster services will down no nothing SQL will goes wrong correct right yes yeah yes sir understanding not understanding so if suddenly something happened to the disk enter your SQL will down answer local disks are more secure than share disks correct because shade discounts completely working with the networks networks if suddenly there is a small Network glitch and that that due to that glitch you would sandbox is down enter will SQL will down on all the nodes right yes or no yes one of the major risk with the Clusters are so what finally you should understand see see okay a Windows failure cluster use the shared storage typically this shared storage is on Sand whenever SQL instance is installed on the cluster your system and user databases are required to be in the same shortest very very important sir okay so binary files whatever the binary files like uh your your bin folder all the binary files you can keep in the in the local disco Lister in the local local but system databases user databases you can't keep in the local list you need to keep in the sandbox only that is what okay that allows the cluster to move because okay whenever you are doing the failover it will also fail over the disks disks so currently So currently this node is acting as a active all the disk like a G Drive F Drive T Drive okay T for temporary f for log G for data these three disks are pointing to the node one because node one is acting as a Act 2 node in case if suddenly happened something happened to the node one even node one services will move to the node to right while it is moving the services it will also move the disk to the node 2. to the node 2. means G Drive F Drive D drive will point to the node 2 but if suddenly something happened to disk enter your SQL build on because without because all the data is in the disk your master databases your model msdb time DB user databases everything in the shared storage if if this go on and delivered SQL will goes down that is WhatsApp okay whenever you are doing failover along with your services it will also do the SQL so disks also none the failover means disk will also move to the node two so if suddenly something happened it will do the it will move the disc but unfortunately if disk goes down disk goes down then enter SQL will goes down sir enter SQL will goes down hope you understand so that is one of the major drawback to overcome this Microsoft came up with the concept called always on availability group where you can store your data in the local disk hope you understand not understand yeah understand sir any questions no questions are my end others okay so that is about the sandbox that is about public IP address private IP address heartbeat okay cluster resources node concept what is active active what is active passive what is active active what is active passive now there are a lot a lot many other Concepts tomorrow we'll discuss couple of things a day after tomorrow we'll discuss couple of things when we uh start conquering okay when we start confirming the windows failure cluster we'll see one by one okay so relax for 10 minutes relax for 10 minutes okay sharp uh 940 will start deploying the servers and basic steps are today okay Basics I will say today and tomorrow we'll go for actual config in the cluster that makes sense right everyone yes okay short 940 will meet sir okay okay foreign foreign foreign foreign foreign foreign foreign back to online yes yes okay yeah so uh let's do all the scrap work today let's go for tomorrow first three to configure Windows failure cluster okay everything's crap work will do it now it won't take more time it will just take uh 30 to 40 minutes to complete all the scrap work today we'll we'll see all that part okay tomorrow we'll go for the actual concept so what I am going to do first means let let me okay first I am creating okay uh three VMS 3 VMS one VM it is acting as a lot much okay here one VM so here I am going to keep node one node two okay where reward SQL is running on node one and node two here only this VM acting as a playing as a multiple roles one is it is acting as a active directory server it is acting as a domain controller server domain controller server it is acting as a cluster server okay it is acting as a San server send okay in real world this this in real world we will maintain one additional server only for cluster actually in real world This Server is just as a cluster server where your cluster resources you installed and cluster where you are open the fellow cluster manager where you are monitoring and everything you are doing from this Mission but here in in Azure we are having some restrict sensor maximum you can use only four cores four cores four core means maximum you can deploy only four VMS under free trial so I I we can't deploy multiple servers under free trial so what I'm going to do if this is too good for us we are having four VMS that is too good you can add one more VM for Dr server as well that we'll see later that that we'll see later as of now today what we are going to do we are going to create three VMS one VM you can call it as a cluster server okay two VMS are a SQL where you are going to install SQL part but this acting additional thing as well this is acting as a Sandbox this is acting as a domain controller this is also acting as a server as well everything this VM is handling here okay make a sense everyone but in real world all these three will be different different okay this server is just a cluster server the server is just like a cluster server in real world you will see this cluster server make a sense everyone yes no yes yes okay now this is what we are doing sir let's go and first create the Resource Group and now what I'm going to do now I am showing everything in a single subnet I will create one virtual Network and I will create just one subnet and I will deploy all these all these VMS under that subnet make a sense or we can do one thing I will create two subnets two subnets one subnet I will go for only for this cluster one subnet can I go for these two VMS yes make a sense that is also anything is fine sir okay first I need to create the resource Group I am just creating a resource Group as a WFC RG WFC SQL yes SQL RG Windows failure cluster SQL for resource code I am choosing East to base only East us only let's create one Resource Group once it is done let's create Network Network okay network is uh w e f C SQL v-net v-net win it okay and IP address I am selecting is one dot it's a 10.1.0.0.16. okay and subnet I am going for node one subnet here I am choosing 10.1 Dot 10.1.1 Dot any IP address or whatever you want any IP address okay but first two is C should be same sir first to do should be same letter two you can change it okay I'm creating one more subnet that this node 2 oh sorry sorry let me go for this one this is not two this is DC easy domain controller subnet okay let me go for node subnet submit let's go for 10.1.2.0 Slash 24. okay I just created two subnets and one virtual Network apart from nothing sir just click on review and create just click on review it is a single subnet only okay both nodes will belong to the same subnet both nodes belong to the save net it is a single subnet cluster single subnet cluster next demo next demo will see multi subnet cluster what are the advantages with multi subnet cluster how to deploy multi subnet clusters okay how to add the Dr servers how to fail over to the Dr all that stuff we'll see in the coming one by one day motion okay let's go and create the three VMS let's go and create the three VMS so let's choose a resource Group let's go for DC DC I don't want any availability Jones and let's go for Windows Server 2000 2016. Windows server 2016. and you need to serve whenever you are also doing practice okay uh I will use this this server all for three days yeah three days three to four days later on you can delete and you can start practicing on Friday Friday Saturday Sunday just you've done the practice later I will go for always on availability group okay yeah okay so that you you won't create one more you can do parallel practicer okay say it means and provide the password click on next click on next and choose DC DC subnet only click on next click on monitor disable Advance nothing sir nothing you need to select basic stuff only why oh let me Spencer password yeah okay just review and create go for duplicate sir parallely create the VMS parallely create the two more VMS so select Resource Group now select node one node one and I don't want any uh select SQL Server to the Windows Server 2016 why I am selecting Windows Server 2016. okay you will learn it sir next demo I will show you Windows Server 2019 okay then you will notice what is the difference before SQL before Windows Server 2016 from Windows server to the after Windows server 2016. that is what very important that you will you will learn it in the two different demos foreign default I don't want anything here you need to choose the node subnet apart from nothings are here you need to do just choose the node subnet click on review and create it create okay done this server is done let's create one more server sir so that three servers are ready DC server is ready node one is almost ready sir okay node 2 also we are creating node 2 also we are creating node 2. 02. so today we are we are seeing everything scrap work whatever you are doing today mostly mostly you never get a chance in real world sir you will have different teams they will take care all this responsibility but here no one is available right we are doing everything so three VMS are ready sir DC is ready sorry node one is almost ready sir node 2 is also getting ready okay now okay first thing let me open let me open multi-discal software so you can download from from Over the Nets are multi disk okay every time I I no need to copy and paste it and run it sir every time you can save all your IP address so that next time you can connect from directly from the multi disk okay just it's it's MB only you can directly download multitask go and search and download the multi-disc software okay now first what you once I created node one is also ready node 2 is almost ready sir okay once you create all the three VMS so what you need to do first to go to the DC Mission from the portal DC Mission from the portal and first make this public IP address into the static okay mostly nowadays you are getting static only but in the in the in the past you are getting Dynamics are actually dynamic means whenever you restart the server your public IP address will change every time now you are getting static no problem even you restart also it won't change the IP address the IP address will be common IP address will be common sir please make a note so first to go to the DC server and verify whether your public IP address is static or dynamic in case Dynamic you need to change to static okay so that even you restart this IP address won't change first thing second thing is okay only this is our version again don't get confused only DC server private IP address only DC server private IP address copy copy go to the network this is very important don't forget otherwise you can't add the servers to The Domain control to The Domain sir it's very very difficult go to the DC server copy the private IP address go to the network go to the network okay or go to the networks are directly go to the network whatever Network you created minimize the blade go to the DNS server go to the custom and provide your IP address sometimes whenever you do copy paste it won't pixel manually type it 10.1.1.4 done this is the one of the major thing you need to do if you wanted to add the servers to The Domain if you wanted to add the servers to The Domain so copy the DC private IP address go to the network go to the DNA server and add the private IP address and click on save this is the one of the major part you need to do before you do whatever the step you decided sir okay hope you understand yes no yes yes yeah so whenever Poonam is doing practice so for example I told you right don't create your free trial account until I will tell you okay whenever Poonam is doing the practice I will create the meeting everyone try to join and you people can do the practice with the Poonam account make a sense everyone please let me know I will create a meeting in white you can everyone can join and everyone can do practice okay I will open the presentation yeah okay that's it sir go to the again virtual Mission so almost my three VMS are ready apart from nothing sir now what you need to do copy the public IP address with the public IP address go to the various multi-disc oh here it is there oh sorry already there okay so first let me delete everything sir so that you will get better idea the people who are first time seeing okay right click on here add server provide the display names or what name you want to display and provide the password provide the IP address public IP address okay and just click on okay no need to change anything click on OK and go to here copy the node one IP address go to again here click on ADD server and provide node one and change the IP address click on OK and again go to here copy the IP address of your server go to here right click on here and add the server provide node 2 and click on okay here now go to the properties of the server a server and provide your login name and password so I noted enable the domains or till now so that's the reason I deleted the domain and by default I told you that all the Windows servers Azure Windows servers will listen double 318 port number I am allowing the double three input number and AC admin is my my username and I already provide the password just click on OK once you provide your username and password just click on here connect all the servers it will take RDP to all the servers at one shot you no need to go here mstac hyphen V provide your password connect provide your password connect provide your password connect instead of doing all this stuff I just we we can just install the multi-disc software or don't install multi-disc in real world sir okay for your practice I am showing in real world this is how you need to connect msdsu only msgsu only you should connect okay so I connected DC node one node all my three VMS are connected make a sense everyone yes yes no everyone will do one by one sir first okay so first first thing first come what you need to do means disable the firewalls enable the pores in all the three servers okay without any hiccup on your practice without any hiccup on your practice disable all the ports and enable so disable the firewalls and enabled all the ports so search for firewall so in Real World what are the ports you will enable sir double three eight nine port number one for double report number five zero five zero double to if you are enabling always on 50 double to port number for UDP 1434 port number if you want you can enable only those port numbers rest port number you will block sir but here I don't want any hiccups on our practice I am enabling all the ports in real world will enable only SQL related ports hope you understand who will enable not you your windows stream will enable your windows stream will enable so so first what you need to do disable all the firewalls go to the local server sir by default you will get the server manager in case if you buy mistakenly close here you can go and search here server manager again this window will comes into the picture so go to the local here okay internet enhance security configuration turn it off all your uh firewalls I am turning off sir and enable the ports enable the ports is very important okay new rule okay ports click on next so here I am choosing all but in real world what you will do sir you will enable one four one four double three one four three four five zero double two okay so these ports you will enable in real world because you are a SQL Engineers you will enable SQL related ports but as of now I am enabling all the ports I am enabling all the posts but in real world you will enable only SQL all okay SQL all I'm just making and enable output pools as well outbound processor SQL okay yeah that's it sir uh one more thing but when you're specially working with the uh azures are very specially working just enable this feature it won't make any harm file and printer share Echo uh icmp V4 output just enable this feature it won't make any harm it's a mandatory not as hard but but again in olden days it is blocking something else so that's the reason okay just enable this file and printer shade Echo request only for an Azure VM not for any on-premises VMS okay that that is only you need to do okay I disable the firewalls and let me I I want or where is let's go for firewalls let's turn it off all the firewalls or I don't want any firewalls hiccups okay that's it sir okay I disable the firewalls I enable the force go to the node to save algorithms are in node 2 also disable the firewalls disable the firewalls okay and enable the ports in all servers first you need to do this one sir turn it off sometimes we VMS will be little bit slow based on your network the VMS will be little bit slower please bear because we are using free trial right sometimes the network and the services are little bit slow just you should be patients okay okay that's it and let's enable the files here as well you're not a mandatory but still if you are enabling also it won't make any harm okay no two is little bit slow foreign okay let's click for firewall where is firewall okay I'll disable the firewalls find sir okay done so I disable the firewalls I enable the pores so once you connect to the servers the first thing is disable the firewalls and enable the ports I already shown you okay different different techniques to disable the firewalls and enable the force okay close everything sir we don't want now here okay now now go to the DC messenger first okay go to the DC mission go to the manage manage click on ADD rules and features click and add roles on future this is very important please be careful now click on next click on next role based access feature based okay no need to change anything click on next now here here you need to select to directory service because this server I am making as a active directory server okay so you need to select active directory service active directory service first thing you need to select and This Server I'm also making is a DNS server DNS okay DNS server so you need to select the DNS server as well I will explain you sir because that DNS is very very important okay in real world you never get Chance again this is this is you need to do everything uh because that's the reason we are telling everything you need to select the why we need to select all this you will come one by one two more as well sir two things DNS server you need to select back to directory service you need to select and one more is okay so expand the file and storage service expand files and service and select the ISC Target server why we'll see sir okay is Target server this is also very important so in This Server DC server you need to select active directory you need to select DNS server you need to select ISC Target server hope you understand yes no yes sir yes yes then click on next here you need to select the failover cluster failover cluster only that is the one thing sir no need to select anything in the Futures you need to select failover cluster manager in the server roles you need to select active directory DNS server and Isis Target server upward form nothing you need to select sir then click on next click on next click on next click on install click on install it will fail sometime again reinstall it will fail sometime again you need to reinstall until it gets success okay sometimes due to your network or due to something it will filter again you need to reinstall this one make sure that this four Services you need to install in the DC mission you'll need to install in the DC mission go to the node ones are now in the node one you need to install only two things you don't need any active directory service you no need any DNA service you no need any iscos initiator nothing sir just you need to install dotnet framework 3.5 and you need to install failure cluster manager hope you understand sir only two things because node one node 2 only SQL services are holding wherever you are installing SQL services on that node you need to install dotnet framework along with the failure cluster service failure cluster service apart from nothings are here you need to install okay nothing here you need to install only these two Services you need to install in respective nodes wherever you are installing SQL Server you need to install only dotnet framework and failure cluster manager I perform nothing sir apart from nothing make a sense everyone yes no yeah yes questions are now meanwhile sir for me that NET Framework 3.5 is not working like I can't able to install it so what I did you know that I have removed the node and I have installed the another node so in that it's working fine yeah sometimes sometimes I have tried like multiple times but still got it's throwing there like no maybe that VM something yeah okay okay uh questions any questions so that's the reasons as today we we are doing everything scrap work tomorrow is actual demo sir okay tomorrow we'll we'll complete cluster configuration we will complete Quorum configuration we will complete the active passive configuration we'll complete active active configuration for configuration will complete okay okay yeah done sir all four is good we installed active directory we installed DNS we installed uh Pisces initiator and we installed failure cluster manager that's it okay done sir now once you click close button see in the flag notification you are seeing on notifications or click on here now it is asking promote This Server to the domain controller server sir just now you install just active directory service once you install active directory service now it is asking to promote domain domain controller service you need to promote the domain so what do you sir for example see in real world in your laptop you are connecting just with your login name sir login name like for example subbu okay Poonam okay uh money okay just you are connecting with the login names login names and your passwords in real world every login every server should be part of domain should be part of domain in in when when I'm working so my domain is my my login name is n a slash S treaty B to connect to my laptop I will use this login to connect to the servers I will use this login in here okay DPA SQL httb this is my login to connect to the servers to connect to my laptop this is the login so every login there will be Domine so that domain you are creating now that domain we are creating so now it is asking to prom it is asking to promote This Server as a domain controller server now click on OK click on ok now it will ask what is your domain name that is nothing but Forest name nothing but Forest name domain name is nothing but Forest name sir what is your domain name so my domain I'm choosing as a n a is nothing but or you can choose as a nation North America North America okay every domain need to ends with.com every domain needs to end with.com sir so n a is my domain you can keep essay South America AP ASAP okay you can EA Europe Asia whatever domain you want you can keep it so so I am choosing n a as a North America in as a North America so North America is my domain name just click on next Okay click on next you need to choose New Forest and and you need to provide your domain name followed with.com followed with.com and you need to provide the password in case if something happened to this domain controller you can recover with help of this password but we we no need to worry sir all that stuff just provide the password just provide the password hope your understandings are everyone yes okay everything is done okay now what you need to do is I reset This Server sir okay restart this VM sorry we enable the firewalls we disable sorry we disable the firewalls we enable the ports right just restart once the VMS are restart not shut down so when you were restarting I'm sorry I forget I forget to highlight sir oh yeah now see okay this is asking password provide the password whatever password you remember provide the same password sir for all use the same password for Save sign click on next Okay click on this you need to do anything by default by default it will fetch your domain domain name domain name is name is nothing but any in a is my domain name so by default it will fetch scissor fetch then click on next apart from nothing sir provide the forest name provide the password click on next next next that's it it will create the domain for you it will create the domain for you meanwhile you can restart your VMS you can reset your VM whenever you are restarting specify it's the planet activity whenever you are applying patches you will restart right so go to here and choose uh what application maintenance operating system maintenance scroll down scroll down okay go for Hardware maintenance okay choose any maintenance sir you are doing some maintenance right choose any maintenance and just click on continue it will try to restart the VM don't shut down the servers you you need to just restart the VMS okay go to here let's see click on install now is it is installing domain controller it is installing domain controllers okay node one is restarted node 2 is also restarted let's connect this or node one let's connect to node 2 as well do if you want do side by side work sir if you want to do parallel work that is up to your ways okay first time doing a side by side uh not do parallels or do side by side first disable once you connect to the server disable the uh firewalls enable the ports okay and install all the services do one by one son don't get hurry I told you right if if one people anyone created account you people can share your screen I can grant the control okay now you can do practice whatever you want so that everyone can see multiple times whenever you are facing just ping me I will jump into the call to help you on the live okay yeah okay okay VM is ready and node 2 is also ready now go to the my computer so I want to show you something the differences okay let me open my computer on both servers network will be little closer tomorrow it will good because my internet plan is going to expire by today that's the reason little bit slow in the network okay go to my PC properties go to my PC property see sir now this is work group this is not part of any domain sir by default all the VMS will by default whenever you create any VM that will be in the work group by default okay until unless you should change to The Domain Then This Server belongs to the domain is a part of domain server currently this is a work group server means working as a independently independent Independence okay now this server should be part of domain server should be part of domain will add itself hey what happened what happened why that is disconnected okay see now this is a by default this is a work group we'll add the servers to the part of these domains or once this domain is done okay what happened almost scrap work is done sir I created the VMS I showed the network I disable the firewalls I enable the ports I install the Futures I configure active directory I I promoted domain controller almost scrap work is done only two parts are pendings are once this domain server come to online I will add these two servers to the part of domain okay then we will create the storage shared storage and will wind up today sir tomorrow we'll go for all the practice okay server is promoting to The Domain domain controller so it will take some time sir I have a question can I ask yeah yeah say when you're trying to connect from Node 1 to node 2 so does the DC has to be online all the time no need directly we can connect right no no you if you wanted to use domain login name definitely DC should be available so DC is like a brain your brain goes down you will go to the comma right this is plain major role okay so actually what I did you know that in the DC I have created the active directory uh so in that there were two logins so with the node one I have logged in with the first login and the the note I have tried to login with the second login so when I was trying to connect from login one to login to I mean like from node one to node two so the DC should be online sir it's I can't able to connect you know you got my question DC uh means you created two logins you connected node one with different login node two with different login yes so when I was trying to connect node one to node to the DC should always be online sir we thought if it's offline I can't able to connect from Node 1 to node two RDP to RDP you mean to say yes yes without DC that's what what login you are using see now I am connecting for example if I am go to here now this is my normal login this is my normal login there is no domain name I can connect any server with normal login you no need to worry you don't need any dcfm if I wanted to connect with the normal login but if you wanted to connect with the domain login the domain name definitely DC should be available correct yes or no I will show you no worries sir This Server the server I connected with my login This Server is also connected with my login right agree not agree yes or no yeah I agree hold on I will show you what is the differences okay let me first DC come to online wait sir hold on I will show you practical okay good almost my DC came to online yeah pretty much good sir now okay now my DC came to online okay let me close it I don't want this one so there is a shortcut sir if you want to open active directory okay if you wanted to open active directory dsa.msc okay search for dsa.msc it will open the shortcut of your active directory okay in real world if you are able to open dsr.msc that is well and good because you can validate lot of things but most of the organization will block the tsa.msu can't open dsl.msc okay you can't open this ATM machine but in case you are getting a chance to open dsl.mec that is well and good because we can get what is my service account and whether it is got locked out or someone forget to set the password never expired for that user what kind of uh email address it mapped everything you can get in the active directory sir everything so for example okay we'll see all that part tomorrow hold answer now to open active directory search for dsr.msc it will open active directory users and computers this is your domain currently I'm having only one domain so that's the reason you are able to see only one domain one domains are only one domain if you have multiple domains you will see multiple domains okay under this domain there is built-in computers domain controller okay foreign security principles Management Service users groups blah blah blah something you no need to worry you never get a chance to deal with these activities that will be managed by your active directory team in real world now here very important is computers so when you go to the computer currently no computers are mapped to this domain controller currently no computers are mapped to this domain controller nothing sir currently now let's go to the node one okay and let's change to to The Domain domain server sir see click on domain and provide your domain name in a click on OK ah why it is blocking let's see yeah okay provide any.com any.com okay now probably your username now this is my again normal name right but Caesar what is domain name this is your domain login name this is login and this is a domain in a domain so in in a simple shortcut you can provide like this domain name backward slash your login name if you wanted to connect if you wanted to connect to the server with the domain logins then this is how you will connect sir in real world every login every service account should be part of domain please make a note this is not like your laptop and when you go to the real world all your logins all your servers all your service accounts should be part of domain controller part of domain controller then click on ok now this server will be part of the domain This Server will be part of that domain and you can then why you are adding This Server to The Domain subbu why so I want some security policies I want some uh control on this server on This Server so you can apply the policies sir mostly when you go to the real world you can't connect to the USB port right agree not agree and you address so how they are controlling all the servers are how they are controlling all the servers in the active directory in the active directory they will apply all the policies they will apply all the policies they will create the groups they will create the users they will do a lot of software again this is like a version for them how the inter network is one version active directory is also one version where where you are having lot of subserve because that is nothing but a human brain how our human brain will works your active directory will also work same you can control everything from the active directory you can manage everything from the active directory now just refresher here refresh how many servers are part of this domain are either now sir see I connected to the server right now try to understand okay I connected to these two servers right I connected but not with my domain name with my local account if you if you have any doubts can you stop this VM can I shut down this VM for time being shut down shut down the diseases okay let's shut down the DC server anything happen to this node 102 no sir nothing happens [Music] because I connected with my local account that is a local account that is not a domain account that is not my domain account that is local account go and verify I'm not passing any domain name I just connected using local account now what I am going to do let me let me okay shut down the servers shut down those Awards I can connect Sir with the local account I can connect come on here very slow shut down okay and shut down all the servers you can shut down now change the domain name okay shut Downing and change to domains are my login name I am changing to the domain name now okay in a I am passing domain now let's start connect close go to the portals or I shut down those hours let's say these droppings are all the beams hold on hold on let me let's stop all the VMS okay now all the servers are part of domain right okay node 2 is also stopped let me start node two sir let me start node two now tell me whether This Server will start or not because I stopped the DC server right I I stopped the DC server right getting my point DC my DC mission is down but I am just starting only node two whether node 2 will come to online or not successfully started the Note 2 okay let's see okay starting your Note 2 is starting sir means or nothing will happen to the server agree or not agree running your VM is running your VM is running but sir in real world everything is work connected to the domains right you will face lots of challenges okay you will place lot of challenges okay but your VM will run but authentications connections policies all will gone because your DC is down your disease down now let let me go and connect to the server sir let me go and connect to the server msdsc hyphen V server name what I not copied okay so our name okay now let's provide the domain name slash sa admin parts of password now tell me whether I'm able to connect or not yes you can yeah this is from no sir how you can connect with the domain name sir domain server is down how you can connect with the domain name domain server is down so you can connect with local login local login means I can use only AC admin and provide the password provide the password now I can connect with the local login I can connect not with the domain login in case your domain is down sorry your DC never down if DC don't then gone okay please make a note then gone everything is gone okay so that's it sir I wanted to show you practically if if domain goes down okay hope you understand Azar sir actually uh my domain is you know it's offline but still I can able to connect with the domain log IC sorry wait wait wait say wait a second I've shown you everything as a practical I don't know how you configure how you are doing practice yeah yeah okay I got that is how the real world will work I don't want any confused to many people Okay so I'm just passing a knowledge a right knowledge so when if something happened to The Domain nothing will happen to the servers you can access the servers but the servers will run with the local accounts not with the domain accounts foreign s are ready now go to here now I pass the my domain name n a is my domain name now I can connect three servers at one shot okay yeah that's that is what sir I want to discuss I want to discuss storage as well it's been late okay let me stop here okay now what you what you need to do means now basically what you need to do means okay once you for example today you've done the basic part now what you need to do stop all the VMS Microsoft won't charge much price if your VMS are running Microsoft will charge a little bit more sir so better what you need to do right stop the VMS okay once again you are starting practice again start the VMS do the practice stop the VMS do the practice start stop the VM start the VMS do the practice stop the VM start the VM do the practice until your practice is done okay don't run your VMS continuously if you stop the VMS if you just kept for one or two days also micro Microsoft won't charge that much Microsoft won't charge that much if your VMS are ready running and you forget for one or two days Microsoft will charge too much Microsoft will charge too much sir please be practice Poonam when you are doing practice also don't waste that 15 000 rupees just stop the VMS assume you practice for one or two day one or two hours after that after you have some work stop the VMS do your work again you can come back start the VMS and do the practice okay make a sense yeah yeah so don't forget sir please don't forget to stop the VMS Microsoft will charge like anything okay tomorrow once we log in we'll we'll create this sandbox sandbox then we'll configure cluster then we'll configure Quorum then we'll install the SQL Server okay please be available at 7 45 8 o'clock shop will start it okay and inform to your group members join everyone make the sessions more Interactive okay that is only one request I'm requesting everyone but no one is following sir again there is one group for Azure data engineer a discussion group every day 200 to 300 messages I'm able to see from that group in our groups no messages nothing everyone is practicing individually individually okay I'm not sure sir that's okay that's it see you tomorrow thank you