Tagged articles

7 articles

Page 1 of 1

May 19, 2021 · Databases

Mastering SQL Server AlwaysOn: Enterprise‑Ready High Availability Architecture

This article explains SQL Server's evolution from legacy high‑availability solutions to the modern AlwaysOn architecture, detailing its data‑synchronization process, synchronous and asynchronous commit modes, failover scenarios, and practical deployment recommendations for enterprises handling both moderate and terabyte‑scale workloads.

AlwaysOnDatabase ReplicationSQL Server

0 likes · 8 min read

Mastering SQL Server AlwaysOn: Enterprise‑Ready High Availability Architecture

ITPUB

May 19, 2021 · Databases

Mastering SQL Server AlwaysOn: Enterprise‑Ready High‑Availability Architecture

This article explains the evolution of SQL Server high‑availability solutions, details the AlwaysOn availability‑group architecture, walks through its data‑synchronization workflow, compares synchronous and asynchronous commit modes, and offers practical guidance for deploying AlwaysOn in large‑scale enterprise environments.

AlwaysOnDatabase ArchitectureSQL Server

0 likes · 8 min read

Ctrip Technology

Nov 8, 2018 · Databases

Evolution of Ctrip's Database High‑Availability and Disaster‑Recovery Architecture (1999‑2018)

This article chronicles Ctrip's database high‑availability and disaster‑recovery evolution—from simple SQL Server mirroring in the early years, through SAN‑based clustering and AlwaysOn, to the adoption of MySQL, Redis, MHA, and a one‑click DR automation tool—highlighting architectural decisions, challenges, and operational lessons learned.

AlwaysOnDatabase HAMHA

0 likes · 10 min read

Evolution of Ctrip's Database High‑Availability and Disaster‑Recovery Architecture (1999‑2018)

dbaplus Community

Oct 7, 2018 · Databases

How Alibaba Cloud Scaled SQL Server with AlwaysOn for Read/Write Separation

This article details Alibaba Cloud's evolution of SQL Server RDS, covering product growth, the challenges of read/write separation, technical evaluations of AlwaysOn versus Transactional Replication, cloud architecture iterations, and the final productized solution for high‑availability database services.

Alibaba CloudAlwaysOnDatabase Replication

0 likes · 12 min read

How Alibaba Cloud Scaled SQL Server with AlwaysOn for Read/Write Separation

Tencent Cloud Developer

Feb 22, 2017 · Databases

Building a SQL Server Failover Cluster on QCloud – Final Guide

This guide walks through building a SQL Server Failover Cluster on QCloud, covering architecture choices, network layout, required roles like DTC, step‑by‑step installation on two nodes, configuration of virtual IPs, and recommendations to prefer AlwaysOn or PaaS solutions for production reliability.

AlwaysOnFailover ClusterQCloud

0 likes · 9 min read

Building a SQL Server Failover Cluster on QCloud – Final Guide

dbaplus Community

Sep 20, 2016 · Databases

Upgrading SQL Server 2008 R2 to 2014 with AlwaysOn: A Hands‑On High‑Availability Guide

This article walks through a real‑world upgrade from SQL Server 2008 R2 to 2014, detailing background analysis, data collection, solution design, detailed investigation, testing, performance baselines, side‑by‑side migration, cluster setup, application changes, and common pitfalls such as CDC issues, index‑rebuild logging, and query slowdowns.

AlwaysOnPerformance TestingSQL Server

0 likes · 13 min read

Upgrading SQL Server 2008 R2 to 2014 with AlwaysOn: A Hands‑On High‑Availability Guide

Architecture Digest

Sep 1, 2016 · Databases

Upgrading SQL Server 2008 R2 to 2014 and Implementing AlwaysOn High Availability: Process, Research, Testing, and Lessons Learned

This article shares a real-world case study of migrating a SQL Server 2008 R2 environment to SQL Server 2014, detailing the pre‑migration research, architecture redesign with AlwaysOn high‑availability, testing procedures, implementation steps, performance tuning, and common pitfalls encountered during the three‑month project.

AlwaysOnSQL Serverdatabase migration