Configure SQL Server Always ON Availability Groups between Two Synchronous Replicas. Part 2

We already covered some theory about configuring Always ON Availability Groups for Linux-based SQL Servers. The current article will focus on practice.

We are going to present the step-by-step process of configuring the SQL Server Always ON Availability Groups between two synchronous replicas. Also, we’ll highlight the usage of the configuration-only replica to perform automatic failover.

Before we start, I would recommend you to refer to that previous article and refresh your knowledge.

CodingSight - Configure Two Node Synchronous Replicas and a Configuration-Only Replica on PACEMAKER Cluster between 3-Node Ubuntu Linux Systems. Part 2
Read More

Understanding Always ON Availability Group between Linux-Based SQL Server Instances. Part 1

SQL Server Always ON Availability Group is a solution meant to achieve high availability and disaster recovery for SQL Server databases. We can configure this functionality between the Windows-based SQL Server installations, Linux-based SQL Server installations, and even between Linux and Windows-based SQL Server installations together.

CodingSight - Understanding Always ON Availability Group between Linux-Based SQL Server Instances
Read More

Transparent Data Encryption (TDE) in SQL Server in an AlwaysOn Availability Group on Example

Availability Groups are fantastic for High Availability/Disaster Recovery solutions, and I’m sure that fellow DBAs will agree with me. However, there will be times when we must consider certain precautions and extra steps carefully to avoid unwanted surprises. For instance, any Secondary Replica becomes the current Primary Replica for whatever reason, and our goal is to not let it happen.

CodingSight-Dealing with encryption of databases in an AlwaysOn availability group scenario
Read More

How to Install Ubuntu 18.04 and SQL Server 2019 on Linux

The previous article explained the creation of a virtual machine using Oracle VM Virtual machine. Now, we will learn how to install Ubuntu 18.04 and SQL Server 2019 on Linux.

Install Ubuntu Linux

First, we need an operating system ISO file. Once the file is downloaded, we mount it on a virtual disk drive:

Launch Oracle VM Virtual Machine Manager and right-click on LinuxSQL01. Then click Settings.

Read More

Сreating a Virtual Machine With Oracle VM Virtual Box

Microsoft announced cross-platform support of SQL Server – the SQL Server 2017 and SQL Server 2019 work on Microsoft Windows and Linux. We can install SQL Server 2017 and higher on Red Hat Enterprise Linux, Ubuntu, and SUSE Enterprise Server. We can also set up high availability and disaster recovery mechanism for SQL Server on Linux like SQL Server Log shipping and AlwaysOn Availability Group.

CodingSight - Сreating a Virtual Machine With Oracle VM Virtual Box
Read More