Configurando AlwaysOn Availability Groups – Parte 3
Post Series: AlwaysOn Availability Groups
- 1.Configurando AlwaysOn Availability Groups – Parte 1
- 2.Configurando AlwaysOn Availability Groups – Parte 2
- 3.Configurando AlwaysOn Availability Groups – Parte 3
- 4.Monitorando AlwaysOn
- 5.SQL Server AlwaysOn Configurando Replica Somente Leitura
Seguindo com a série de posts Configurando AlwaysOn Availability Groups, estando o cluster do Windows instalado e configurado, agora vamos habilitar e configurar o AlwaysOn no SQL Server.
Configuração do AlwaysOn no SQL Server
Para habilitar o AlwaysOn no SQL Server abra o SQL Server Configuration Manager, selecione SQL Server Services e clique com o botão direito no serviço do SQL Server e entre em Properties.
Configurar em todos os Nós do Cluster, habilitando o AlwaysOn no SQL Server e reiniciando o serviço.
O restante da configuração é feito no SQL Server Management Studio. No Object Explorer expandir Always On High Availability e clique com o botão direito do mouse em Avaialability Groups e selecione New Availability Group Wizard.
Atribua o nome do grupo seguindo ao padrão recomendado <nome cluster>-AG1.
Na tela seguinte vamos selecionar os Bancos de Dados que farão parte deste Availability Group, apenas aqueles com Recovery Full estarão disponíveis!
Na tela Specify Replicas vou selecionar as opções de Failover automático e Replica com consulta disponível.
Em Backup Preferences selecione Primary, pois os outros modos não suportam Backup Diferencial.
Para definir um Listener, defina nome similar ao do Avaiabilitity Group com “L” no final: SRVSQL-AGL, porta 1433.
Para realizar a sincronia inicial (Backup / Restore) de modo automático selecione Automatic seeding. Eu particularmente prefiro realizar antes a sincronia manual executando Backup FULL e LOG no Primário, em seguida restaurando nas Réplicas utilizando a cláusula NORECOVERY, neste caso selecione Join only.
Finalizando a configuração o Wizard irá configurar o AlwaysOn em ambos os Nós e criar o grupo de recursos no Cluster.
Abra o Cluster Manager para verificar a configuração, Nó ativo em Owner Node.
Para monitorar o AlwaysOn basta acessar o Dashboard no Management Studio.
Finalizamos a série de posts sobre AlwaysOn Availability Groups no SQL Server 2017.
Saudações Tricolores,
Landry
This Post Has 5 Comments
I like it when people come together and share thoughts. Great
site, continue the good work!
Nice post. Ӏ was checking continuously tһis blog ɑnd I’m impressed!
Veгy uѕeful info рarticularly tһe finasl phase 🙂 I handle such
іnformation a lߋt. Ι was seeking this сertain info fօr a ery lengthy time.
Thabk үou and best оf luck.
Wonderful goods from you, man. I have understand your stuff previous to and you’re just extremely
fantastic. I actually like what you’ve acquired here, really like
what you’re saying and the way in which you say it. You make it
enjoyable and you still care for to keep it wise.
I cant wait to read much more from you. This is actually
a great website.
P.S. If you have a minute, would love your feedback on my new website
re-design. You can find it by searching for “royal cbd” – no sweat if you can’t.
Keep up the good work!
Thanks for your marvelous posting! I definitely enjoyed reading
it, you could be a great author.I will be sure to bookmark your blog and definitely will come back sometime soon. I want to
encourage you to continue your great posts, have a nice afternoon!
Hey! This post couldn’t be written any better!
Reading through this post reminds me of my good old room mate!
He always kept chatting about this. I will forward this page
to him. Fairly certain he will have a good read.
Thanks for sharing!