Many organizations are considering the cloud for enhancing SQL application availability and business continuity. This is especially true for those small to medium sized businesses that don’t have the budgets to implement redundant data center infrastructure to support high availability for their most critical SQL business systems. But the challenge is many application clustering technologies are not capable of integrating with cloud infrastructure. As a result, IT may be left holding the bag by having to separately manage local and remote SQL clustered application infrastructure.
Click to register for the webinar “HA and DR Must Haves for Cloud Based MS-SQL”
There are no shortage of clustering solutions for MS-SQL. Many of these technologies have been around for years and are proven, however, some of these offerings were not designed to interoperate in a private or hybrid cloud environment. In fact, many of these solutions require the use of local shared storage like SANs, to enable application failover across local hosts. And since cloud storage is not “SAN-like”, it cannot be recognized by these clustering products as an application failover storage target.
To get around this issue, IT administrators need to manage the local failover cluster separately, replicate data to a secondary data center for DR purposes and then migrate VMs to the second site when a failure occurs. Alternatively, they could stand-up a totally redundant “cold stand-by” server infrastructure in their secondary site or rent server CPU resources from a cloud provider. In any of these scenarios, the business is going to incur added costs, added complexity and added business risk.
On the other hand, clustering solutions that can be used in a SAN or SANless environment and support local and remote application failover, regardless of the DR topology, (Private, Public or Hybrid Cloud) give businesses the opportunity to protect their critical systems, simplify operations and avoid overspending on infrastructure.
By taking a software-defined approach to SQL application clustering, IT organizations can use low-cost commodity storage in their primary data center location and replicate their critical data to cost-effective cloud storage resources to lower their DR total cost of ownership. The key, however, is for these solutions to fully automate the application failover process, regardless of the underlying storage infrastructure, to help ensure application uptime and help maintain application service levels.
To learn how to attain enterprise class SQL application availability with low-cost commodity cloud infrastructure, join us for a webinar on October 29th, “HA and DR Must Haves for Cloud Based MS-SQL”.