Framework Model for Database Replication within the Availability Zones

TL;DR

This paper proposes an enhanced database replication model for private cloud availability zones, improving performance and failover handling by utilizing primary and secondary servers with synchronous and semi-synchronous replication.

Contribution

It introduces a novel database replication framework tailored for private cloud regions, extending Microsoft's SQL Server AlwaysOn model with detailed processes and failover management.

Findings

Improved read/write performance with secondary servers

Enhanced failover handling in private cloud environments

Detailed process descriptions for replication scenarios

Abstract

This paper presents a proposed model for database replication model in private cloud availability regions, which is an enhancement of the SQL Server AlwaysOn Layers of Protection Model presents by Microsoft in 2012. The enhancement concentrates in the database replication for private cloud availability regions through the use of primary and secondary servers. The processes of proposed model during the client send Write/Read Request to the server, in synchronous and semi synchronous replication level has been described in details also the processes of proposed model when the client send Write/Read Request to the Primary Server presented in details. All the types of automatic failover situations are presented in this thesis. Using the proposed models will increase the performance because each one of the secondary servers will open for Read / Write and allow the clients to connect to the nearby secondary and less loading on each server. Keywords: Availability Regions, Cloud Computing, Database Replication, SQL Server AlwaysOn, Synchronization.