|July 12, 2018||
If you are planning to implement a high availability cluster to protect SQL Server, you need to understand your Windows Server cluster quorum options. I explained these options in a recently recorded webinar which is available here. You may also be interested in a free white paper, “Understanding Windows Server Quorum Options for SQL Server Clustering” Here are some Q&As from the session.
Q: if we have a three node on premises cluster running Windows 2012 R2 is it possible to put another node in the Azure cloud and failover to it? Azure node?
Q: If you failover from an on-premises SAN-based cluster to a node in the cloud, is the SAN storage just for the local machines? Do they have a separate set of storage in the cloud, or is the cloud server actually able to access the SAN storage?
Q: Can you failover and failback when you have a cluster with both on-premises nodes such as SAN and nodes the cloud?
Q: If you have multiple nodes in a cluster, are there limitations with clustering as far as what can be accessed in terms of the RAM and CPU limitations – or is it based on the Windows operating system and the version of SQL Server?
– Dave Bermingham, SIOS Technology Corp. Technical Evangelist; Microsoft Cloud and Datacenter Management MVP
|May 18, 2018||
SIOS DataKeeper™, an AWS Customer Ready Solution: High Availability and Disaster Recovery for Microsoft SQL Server
More and more companies are looking to run SQL Server in the cloud to take advantage of the flexibility and cost-savings that it delivers. However, many cloud migration projects have been plagued by confusion about high availability protection options in the cloud where the shared storage needed for traditional failover clusters is not available. IT teams are understandably cautious. Downtime for these databases and the applications running on them can have costly consequences, including interruption of essential business operations, reduced end-user productivity, and poor customer satisfaction.
High Availability Options in AWS
But, good news! IT teams have more high availability (HA) and disaster recovery (DR) protection options in the cloud than many realize. You can even save thousands of dollars while still delivering comprehensive HA failover clustering protection for Microsoft SQL Server in AWS.
To simplify and accelerate the deployment of high availability SQL Server clusters in the cloud, Amazon Web Services is offering SIOS DataKeeper™ Cluster Edition on AWS Marketplace and can be deployed automatically using an AWS Quick Start. The AWS Quick Start deployment is perfect for organizations starting their venture into high availability clusters in the cloud.
With the AWS Quick Start program, system administrators and managers can use the SIOS Amazon Machine Images (AMIs) on AWS Marketplace to see firsthand how easy it is to deploy a two-node SQL Server cluster in AWS with SIOS DataKeeper™. The SIOS AMIs on AWS Marketplace provide a customer-ready solution to protect business-critical applications in AWS.
SIOS DataKeeper™ Cluster Edition for HA & DR in AWS
SIOS DataKeeper™ Cluster Edition is the first high availability and disaster recovery solution to combine fully automated, application-centric clustering and efficient data replication. SIOS DataKeeper™ integrates seamlessly into Windows Server Failover Clustering environments, enabling them to work in a cloud where shared storage is not possible.
SIOS, an APN Standard Technology Partner, solves the problem of HA and DR by replicating your SQL Server data between availability zones and/or Regions on AWS and integrates with failover clusters to allow you to build SANless clusters on AWS. SIOS DataKeeper™ overcomes the lack of a SAN on AWS, enabling you to build failover cluster instances just using local attached storage.
Leverage the AWS Quick Start to set up an AWS environment for SIOS DataKeeper™ Cluster Edition and deploy it to your AWS account. This Quick Start uses AWS CloudFormation templates to deploy SIOS DataKeeper™ into a new or existing virtual private cloud (VPC).
|February 15, 2018||
2017 was a remarkable year at SIOS with the ground shifting all over our industry and that was reflected both in what we saw in own business and what customers and partners told us.
SQL and SAP Moving to the Public Cloud
It’s all been about cloud – surprise? Not really. But the speed in which this has happened for the critical apps that SIOS protects is what IS surprising. A few short years ago, we saw a few adventurous souls taking their SQL applications to the public cloud and thought “this is not for the faint of heart”. But, 2017 established the trend and now I can safely say this is the future. The majority of our new customers are racing to the cloud with their most important treasures – database applications that run their businesses. They’re moving whole datacenters. We’re helping them. And SAP, the most critical of critical applications for businesses are being migrated in a significant way, and SIOS is providing the linchpin HA services they need to protect it. This trend is clearly a litmus test and indicator of a serious appetite for serving up mission-critical assets in public cloud. It’s just the start.
PASS Summit Confirms Cloud Migration Projections
And then there was PASS Summit 2017. Amazon and SIOS co-sponsored an amazing breakfast panel with industry luminaries Joey D’Antoni, Allen Hirt, Geoff Hiten, and David Klee to discuss running SQL Server in the cloud. We attracted a record-breaking attendance at 6:30 AM in the morning! And 80% of the attendees told us (as they munched bacon) that they would be moving to the cloud in 2018. Certainly, nothing like that was in the air in 2016.
Machine Learning for High Availability
Machine Learning has arrived – It’s hard to pick up a tech article that doesn’t mention AI or machine learning (ML) these days. And we’ve been building out a very sophisticated ML product, SIOS iQ, for a number of years – well before this hype cycle overtook us. It was tough in the early days explaining how machine learning works to simplify, save time and save money. Certainly, there’s been interest and appreciation. But 2017 was a game changer. The conversations have changed. The audience is more educated. They’re more appreciative of the true uniqueness and value of what we’ve done and it shows – we were named a finalist at VMworld Best of Show. Leading industry analysts have taken note of the innovation that our IT analytics platform delivers.
What’s up for 2018 – So, here we are now. Delivering HA for critical database apps in all the three major public clouds – Amazon, Azure, and Google. Operations in these will be the new normal. Now, the real excitement will build across this year as you see us marry our machine learning technology to our availability offerings. We’ll be setting the standard for machine learning powered availability and a breakthrough to help you reach those SLAs you’ve promised in the cloud –
stay tuned . . .
|August 28, 2017||
|August 18, 2017||