SIOS SANless clusters

SIOS SANless clusters High-availability Machine Learning monitoring

  • Home
  • Products
    • SIOS DataKeeper for Windows
    • SIOS Protection Suite for Linux
  • News and Events
  • Clustering Simplified
  • Success Stories
  • Contact Us
  • English
  • 中文 (中国)
  • 中文 (台灣)
  • 한국어
  • Bahasa Indonesia
  • ไทย

SIOS Product Update: What’s New in SIOS Protection Suite and DataKeeper Cluster Edition – Windows

March 26, 2020 by Jason Aw Leave a Comment

SIOS Product Update: What’s New in SIOS Protection Suite and DataKeeper Cluster Edition – Windows

SIOS is pleased to announce the release of version 8.7.1 of our SIOS Protection Suite-Windows and DataKeeper Cluster Edition-Windows products. The new release broadens support and adds new features to meet our customers’ needs for easy, cost-optimized high availability.

The following features and additional support are being introduced as part of this update for DataKeeper and SIOS Protection Suite:

  • Public Cloud:

    • In Azure:
      • Additional support for multiple virtual IP addresses using the Azure Load Balancer Multiple Frontends function, allows easier configuration and management of SIOS Protection Suite.
    • In AWS:
      • A wide range of instance types are now supported, including AWS Nitro System instances that enable high performance, high availability, high security, and bare metal capabilities to eliminate virtualization overhead.
  • Database:

    • EDB Postgres Advanced Server
      • Continuing our expansion of key databases, we can now protect EDB Postgres Advanced Server, an open-source database management system used as an alternative to Oracle.
    • SQL Server 2019
      • Now tested and supported on both SIOS Protection Suite – Windows and DataKeeper Cluster Edition – Windows on all Windows Server platforms 2016 and later (Released to the market in November 2019)

What’s next? Let us know what you’d like to see and check back for more updates!

Reproduced from SIOS

Filed Under: Blog posts Tagged With: DataKeeper Cluster Edition, sios protection suite

DataKeeper Cluster Edition for SQL Server High Availability In AWS Cloud

February 9, 2018 by Jason Aw Leave a Comment

The potential cost savings of moving to the cloud is nearly impossible not to consider. However, after you stop counting the money you are going to save, you start thinking about things like security and availability and wonder whether the cloud is for you. But fear not, we’ve got just the right solution – SIOS Datakeeper Cluster Edition.

In a traditional data center, you have the control and can deploy whatever security and high availability solution you like. However, once you decide to move your servers to the cloud your choices can become much more limited. It doesn’t matter whether you’re with Amazon, Google or Microsoft, outages in the cloud can and do occur and you need to do whatever you can to mitigate such risks.

Amazon Web Services

Let’s take a closer look at Amazon Web Services (AWS) for instance. What are the options you have to ensure that your SQL Server database can survive an unexpected outage? While some applications can be deployed in a load balanced configuration across multiple availability zones, SQL Server is generally not deployed in a load balanced configuration. What this means is that SQL Server itself resides in a single availability zone and if that zone should become unavailable, your whole application stack can come to a grinding halt.

SQL Server 2008 R2 and its limitations

If you read this article by Miles Ward, you will see that with SQL Server 2008 R2, your availability options are pretty limited. In that article on page 11, there is a nice chart that lays out your HA options. As you will see, the options are severely limited and mostly fall outside of the category which would be described as HA. Log shipping, mirroring and transactional replication are pretty much the only options you have, and they are more of a data protection options rather than HA options. If you want Microsoft failover clustering, you will find yourself out of luck due to some network limitations (clients can’t connect to a clustered IP address) in AWS and the lack of a shared disk resource required for traditional SQL clusters.

AWS

If you are looking to deploy SQL Server 2012, your options get a little better. As described by Jeremy Peschka, with a little manual intervention you can deploy AlwaysOn Availability Groups in AWS to do asynchronous replication from your data center to AWS, or even between AWS availability groups. Of course this assumes you have the SQL 2012 Enterprise license required for AlwaysOn Availability Groups. The only “issue” is that AWS really doesn’t support moving cluster IP address from one server to another, so client redirection has to be done manually using the ec2-unassign-private-ip-addresses and ec2-assign-private-ip-addresses commands after switchover that Peschka describes in his article. All-in-all this is a very manual process, which again does not really fit the description of a highly available system.

A Solution To The Limitations

If you can live without automated recovery and with the limitations of AlwaysOn Availability Groups that I described in a previous blog post, then you might just want to go ahead and try the AlwaysOn Availability Group deployment in AWS. However, if you are looking for an easier, more affordable, more robust HA solution, I have some really good news. SIOS Technology Corp has been looking at this problem and has developed a solution that overcomes all of the limitations previously described and will be available as an AMI for easy deployment. This solution is currently in private beta, but will be widely available later this year.

SIOS DataKeeper Cluster Edition

The SIOS solution is based on SQL server in a Microsoft Failover Clustering using DataKeeper Cluster Edition host based replication. By using hosted based replication they have overcome the first obstacle of clustering in EC2 – lack of shared storage. The second obstacle that SIOS had to overcome was the issue of client redirection described by Peschka; the client access point needs to be manipulated from within EC2, not failover clustering. SIOS has built intelligence into their AMI solution such that the reassigning of the IP address is automated as part of the cluster failover process, effectively simulating the behavior you would normally expect from a cluster.

And because all of this is built on top of failover clustering, this can be deployed using SQL 2008/2008 R2 or 2012. Even the Standard Edition of SQL Server will support a 2-node cluster so the cost savings vs. deploying SQL 2012 AlwaysOn Availability groups could be substantial.

Let me know what you think. Does SIOS Datakeeper Cluster Edition sound interesting? What are you doing today to ensure the availability of your SQL Server EC2 instances?

Reproduced with permission from https://clusteringformeremortals.com/2013/01/11/sql-server-high-availability-in-aws-cloud/

Filed Under: Clustering Simplified, Datakeeper Tagged With: Amazon AWS, Cloud, DataKeeper Cluster Edition, High Availability, SQL Server, SQL Server 2008 R2

Datakeeper Cluster Edition 7.5 Now Support Windows Server 2012

February 7, 2018 by Jason Aw Leave a Comment

Benefits Of Using DataKeeper Cluster Edition

Great news for you Windows Server 2012 early adopters – you can now use DataKeeper Cluster Edition with Windows Server 2012. I’ll be posting some Windows Server 2012 Step-by-Step articles before the end of the year and will be sure to include some multisite cluster examples as well. In the meantime, if you want to build clusters based on Windows Server 2012 and want to eliminate shared storage as a single point of failure or you want to stretch your cluster across geographic locations you can do that with DataKeeper Cluster Edition v7.5.

Reproduced with permission from https://clusteringformeremortals.com/2012/12/19/datakeeper-cluster-edition-7-5-now-support-windows-server-2012/

Filed Under: Clustering Simplified, Datakeeper Tagged With: DataKeeper, DataKeeper Cluster Edition, Windows Server 2012

SQL Server 2012 Multi-site Failover Cluster For Disaster Recovery

February 1, 2018 by Jason Aw Leave a Comment

SQL Server 2012 Multi-site Failover Cluster for Disaster Recovery using SteelEye DataKeeper Cluster Edition

Microsoft just released a great white paper on new support for SQL Server 2012 Multi-site Failover Cluster for Disaster Recovery. If you’re interested, you can download a copy here.

In fact, don’t forget that I blogged about this feature back in an earlier post. I included a video demonstration. It shows a SQL Server 2012 multisite failover cluster for disaster recovery using SteelEye DataKeeper Cluster Edition. SQL Server 2012 and cross subnet failover capabilities will open up a whole new world of possibilities for people looking for disaster recovery options.

Reproduced with permission from https://clusteringformeremortals.com/2012/01/03/sql-server-2012-disaster-recovery-multisite-clusters/

Filed Under: Clustering Simplified, Datakeeper Tagged With: clusters, DataKeeper Cluster Edition, disaster recovery, multi-site, SQL Server 2012, sql server 2012 multi site failover cluster

SQL Server Denali And Hadron

January 24, 2018 by Jason Aw Leave a Comment

Microsoft’s latest version of SQL, code named Denali, is currently in CTP. One of the most anticipated feature is something called HADRON. Basically, it is has been described as mirroring 2.0. The best features of HADRON as I can see compared to mirroring as it is in 2005/2008 are as follows:

  • You can query the mirror (now known as a replica)
  • You can have more than one replica
  • Database are grouped into availability groups to ensure related databases always fail over together
  • Support for replicating more than 10 databases

If you want a great preview, check out fellow MVP Brent Ozar’s post, SQL Server Denali Rocks!

From reading Brent’s post I gather Microsoft only plans to include this in the Enterprise version of SQL. That is too bad for the many customers running SQL Server Standard as traditionally there is a significant price jump to go from Standard to Enterprise. However, that is good news for the 3rd party replication vendors out there who are providing similar functionality today on SQL 2005/2008 on Standard and Enterprise Editions.

SteelEye DataKeeper Cluster Edition for SQL Server

While it is not an exact duplicate of HADRON, a multi-site cluster using SteelEye DataKeeper Cluster Edition for SQL Server gives you a great solution for HA/DR without requiring shared storage. So while we wait for Denali and all the application vendors to start supporting Denali you might want to have a look at what SteelEye DataKeeper Cluster Edition can do for you today!

Reproduced with permission from https://clusteringformeremortals.com/2010/12/10/sql-server-denali-and-hadron/

Filed Under: Clustering Simplified, Datakeeper Tagged With: DataKeeper, DataKeeper Cluster Edition, disaster recovery, Hadron, High Availability, SQL

  • 1
  • 2
  • 3
  • …
  • 5
  • Next Page »

Recent Posts

  • Why Does High Availability Have To Be So Complicated?
  • How to Fix Inherited Application Availability Problems
  • Quick Start Guide to High Availability for SQL Server Using SIOS Protection Suite for Linux
  • Version 8.7.2 SIOS Protection Suite-Windows and DataKeeper Cluster Edition
  • About Using Amazon FSX for SQL Server Failover Cluster Instance

Most Popular Posts

Maximise replication performance for Linux Clustering with Fusion-io
Failover Clustering with VMware High Availability
create A 2-Node MySQL Cluster Without Shared Storage
create A 2-Node MySQL Cluster Without Shared Storage
SAP for High Availability Solutions For Linux
Bandwidth To Support Real-Time Replication
The Availability Equation – High Availability Solutions.jpg
Choosing Platforms To Replicate Data - Host-Based Or Storage-Based?
Guide To Connect To An iSCSI Target Using Open-iSCSI Initiator Software
Best Practices to Eliminate SPoF In Cluster Architecture
Step-By-Step How To Configure A Linux Failover Cluster In Microsoft Azure IaaS Without Shared Storage azure sanless
Take Action Before SQL Server 20082008 R2 Support Expires
How To Cluster MaxDB On Windows In The Cloud

Join Our Mailing List

Copyright © 2021 · Enterprise Pro Theme on Genesis Framework · WordPress · Log in