Tips and Tricks to Growing Your SQL Server Estate from SMB to Enterprise Scale
Thursday, June 28, 2018 - click here to learn more
I have seen many of your tips on SQL Server Availability Groups and really see the value in the technology in terms of simple data replication, read-only secondaries, etc. The problem is that I need to manage Windows and Linux clusters across my organization, so my team not only needs to know SQL Server but also numerous versions of Windows and Linux. I also face constraints with both Windows and Linux in terms of setup and deployment. For example, the configuration and management for each cluster is different, which is a steep learning curve for my team. We are also looking into options where our business can get value from the public cloud for short term needs, for testing and for particular applications. I cannot put my team in a situation where they need to be experts on each server, I need to make sure everyone on my team is able to confidently manage all of the servers if they are on-call, a team member is on vacation or we are bogged down with new initiatives. How can I simplify the management of my SQL Server Availability Groups?
Traditionally, SQL Server Availability Groups (AG) have been an Enterprise Edition only SQL Server feature. With SQL Server 2016 and newer, Microsoft has extended the functionality with a single database per Availability Group on Standard Edition. The reality is AGs are not highly available on their own. AGs replicate data between instances and rely on operating system level clustering below the AG to provide a complete high availability solution.
Windows Server Failover Clustering (WSFC) is fairly consistent between operating system versions, but each version still has its nuances. On Linux, Pacemaker has been the long-standing clustering option. Unfortunately, Pacemaker is ecosystem bound, requires the distributions match, deployment is difficult and day to day management is challenging. In an environment with multiple versions of SQL Server, Windows and Linux, managing the high availability solution becomes far more complex and requires your team to be well versed in numerous technologies to support the environment.
As a team of SQL Server DBAs and Infrastructure Engineers, how can you most efficiently manage a heterogenous environment of SQL Server, Windows and Linux clusters on-premises as well as in the cloud? One solution that I would like to recommend is DxAG from DH2i. DH2i has been delivering reliable high availability and disaster recovery solutions for numerous years for on-premises and cloud solutions. With SQL Server 2017, Microsoft has introduced a Cluster Type of External, which has enabled partners to provide solutions to help the SQL Server community. DH2i has recently introduced DxAG to simplify and extend the functionality of SQL Server Availability Groups including:
- Fault detection and automated failover solution for SQL Server Availability Groups
- Standardized clustering solution for Windows and Linux across the enterprise
- Straightforward cluster deployment, configuration and 24x7 support
- Reduce the learning curve to manage clustering
- Ability to deploy a single cluster across different versions of Windows and Linux
- Solution for physical, virtual and cloud servers including Windows Server 2012 or newer, RedHat 7.0 or newer, CentOS 7.0 or newer, Ubuntu 16.0 or newer and SQL Server 2017
- Cross platform failover Windows to Linux or vice versa
- Enable migrations from Windows to Linux (or vice versa) and maintain high availability for the application
DxAG is a clustering solution for SQL Server AGs and is easier to setup than WSFC and Pacemaker. DxAG is the cluster manager enabling cross-platform clustering and failover between various Windows and Linux distributions. This enables organizations to have the choice and flexibility when deploying their SQL Server infrastructure. Let’s dive into how DxAG works.
How does DxAG work?
DxAG has a simple process to install and manage the product. Start off by installing DxAG on each instance by copying and running a short wizard-based application. This will install the clustering solution on each instance which are a set of services. Once completed, navigate to the DxAG management console where you will setup the cluster. The first step is to configure the Vhost Properties, which includes the process of adding the nodes to the cluster. In this example, there are three nodes (Windows, Red Hat and Ubuntu) and they are configured in priority order.
Once configured, then it is time to add the SQL Server Availability Group by right clicking on the Vhost that was just created and select the “Add availability group” as shown below.
The AGS Management interface is where each server, instance name, port, synchronization method and credentials are configured.
At this point the SQL Server Availability Group configuration is partially completed as shown below. The instance configuration is complete, but databases still need to be added.
The next step is to connect to the primary instance in the SQL Server Availability Group and add databases as shown below.
At this point the SQL Server Availability Group configuration is complete and the databases are syncing up between the instances.
By default, the SQL Server Availability Group will failover from the primary to secondary instance if a failure occurs. However, if you have a need to failover between instances, you can do so by right clicking on the node and selecting the “Start hosting on Node” option as shown below.
What are the DxAG licensing options?
There are two licensing options for DxAG:
- Perpetual License - $1000 USD per server and $240 USD per server per year for support
- Subscription - $600 USD per server per year which includes support
How do I get started with DxAG?
- Take time to learn more about DxAG and register for a free trial.
- Schedule a demo with the DH2i team to see just how easy it is to setup DxAG and simplify your SQL Server management.
- Setup a test environment with physical or virtual SQL Servers and install DxAG.
- Put DxAG through its paces and outline the benefits to your organization:
- High availability solution for SQL Server 2017 on Windows, Linux and in the cloud – All in 1 tool
- Significant time savings to install and manage for SQL Server Availability Groups
- Low learning curve for your team to manage clustering
- And more…
- Share the results with your team and determine your next steps.
- Get started with DxAG today to simplify SQL Server clustering across Windows, Linux and the cloud
- Need more? Are you looking for an enterprise solution with coordination among dependent resources? Learn more about DxEnterprise from DH2i.
- Check out: DxEnterprise - When You Need Zero Downtime for SQL Server
MSSQLTips.com Product Editorial sponsored by DH2i, makers of DxAG.
Last Update: 2018-06-08
About the author
View all my tips