Análisis e implementación para la creación de un clúster SQL server como solución centralizada de bases de datos satélites
The present project analyzes a viable and sustainable solution for companies that need to improve the availability, scalability, and security of their information by centralizing in a cluster a SQL Server database in SQL Server satellites. This will allow to decrease administrative time, increase...
| Autor Principal: | Estrella Izurieta, Johan Alexei |
|---|---|
| Formato: | bachelorThesis |
| Idioma: | spa |
| Publicado: |
2017
|
| Materias: | |
| Acceso en línea: |
http://dspace.ups.edu.ec/handle/123456789/13364 |
| Etiquetas: |
Agregar Etiqueta
Sin Etiquetas, Sea el primero en etiquetar este registro!
|
| Sumario: |
The present project analyzes a viable and sustainable solution for companies that
need to improve the availability, scalability, and security of their information by
centralizing in a cluster a SQL Server database in SQL Server satellites. This will
allow to decrease administrative time, increase high ability to information, and
improve performance. Consequently, it will release hardware resources that could be
reused on current requirements or in future projects, trying in this way to benefit
companies that require it. To achieve this goal, a virtual infrastructure is created on
which a SQL Server cluster consisting of two virtual nodes simulating an
infrastructure of a companywill bedeployed, this will feature a virtual machine to
handle the volumes of information presented to the cluster to storage the information,
an Active Directory server for control and safety of the own accounts of the cluster, a
computer that has SQL Management Studio for testing. Based on this
implementation, an implementation manual is generated, which will serve as a guide
for future implementations. |
|---|