Alta Disponibilidade com SQL Server no Linux
-
Upload
erickson-ricci -
Category
Technology
-
view
127 -
download
0
Transcript of Alta Disponibilidade com SQL Server no Linux
![Page 1: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/1.jpg)
GDG Campinas | DataFest 2017
![Page 2: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/2.jpg)
Alta Disponibilidade com SQL Server no Linux
![Page 3: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/3.jpg)
Erickson Ricci
- MCITP Database Administrator; - MCITP Database Developer; - +10 anos de experiência com Bancos de Dados SQL Server
[email protected] www.sqlcore.com.br
![Page 4: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/4.jpg)
• Alta Disponibilidade (HA) e Disaster Recovery (DR) • SQL Server no Linux • Opções de HADR no SQL Server • AlwaysOn Availability Groups • Limitações do ambiente Linux • Passo a passo de criação do AG • Demo ***
Agenda
![Page 5: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/5.jpg)
• Alta Disponibilidade (HA) • Continuamente operacional • “Nunca falha” • “100% no ar” • 9's
• Disaster Recovery (DR) • Coloca a empresa em risco • Corrupção, falhas em atualizações, erros humanos, etc…
• RPO (Recovery Point Objective) • RTO (Recovery Time Objective)
Alta Disponibilidade (HA)Disaster Recovery (DR)
![Page 6: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/6.jpg)
SQL Server no Linux
![Page 7: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/7.jpg)
SQL Server no Linux
![Page 8: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/8.jpg)
SQL Server no Linux
![Page 9: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/9.jpg)
SQL Server no Linux
![Page 10: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/10.jpg)
Opções de HADR no SQL Server
• Log Shipping • Database Mirroring • AlwaysOn Failover Clustering Instances • AlwaysOn Availability Groups • Replication ***
![Page 11: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/11.jpg)
Log Shipping
![Page 12: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/12.jpg)
Database Mirroring
![Page 13: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/13.jpg)
AlwaysOn Failover Cluster Instances
![Page 14: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/14.jpg)
AlwaysOn Failover Cluster Instances
![Page 15: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/15.jpg)
AlwaysOn Availability Group
![Page 16: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/16.jpg)
Limitações do ambiente Linux• Pacemaker <> Cluster Manager • Failover via S.O. (Pacemaker) • Linha de comando • Cross-Plataforma ainda não é suportado • Sem autenticação integrada (ainda)
![Page 17: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/17.jpg)
Limitações do ambiente Linux
![Page 18: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/18.jpg)
Passo a Passo de criação do AG• Instalar o SQL Server; • Configurar o arquivos de hosts dos servidores envolvidas; • Habilitar o AG no SQL Server; • Criar o certificado para autenticação entre os endpoints; • Criar os endpoints em todos os servidores envolvidos; • Criar o AG (CLUSTER_MODE = EXTERNAL); • Adicionar as réplicas no AG; • Incluir os databases desejados no AG;
Ref.: https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-availability-group-configure-ha
![Page 19: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/19.jpg)
Demonstração (Lei de Murphy)
![Page 20: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/20.jpg)
Alta Disponibilidade com SQL Server no Linux
Dúvidas???
![Page 21: Alta Disponibilidade com SQL Server no Linux](https://reader031.fdocument.pub/reader031/viewer/2022021503/5a651e947f8b9af3398b575d/html5/thumbnails/21.jpg)
Alta Disponibilidade com SQL Server no Linux
Muito Obrigado!!!