Webinar: Mastering Disaster Recovery for SQL Server in BMS

Webinar: Mastering Disaster Recovery for SQL Server in BMS

Register for the On-Demand Webinar

Whether you’re an experienced IT professional or new to BMS, this on-demand Symposium session provides insights to establish an unshakable SQL Server environment, ensuring system uptime in any scenario, and keeping your BMS applications always within reach. Todd Doane, SIOS Solution Architect discusses real-world success stories and tangible advantages gained from embracing high availability solutions tailored specifically to the challenges of Building Management Systems (BMS).

How Manufacturers Can Use Failover Clustering to Avoid Downtime

How Manufacturers Can Use Failover Clustering to Avoid Downtime

In manufacturing, ERP systems and databases like SAP, SAP HANA, Oracle Database, and SQL Server manage various processes throughout their operations. One of the challenges with this is downtime of any of these operations can be disruptive, even if only for a few minutes, not only for that particular operation but for others too. One of the most common ways to protect these workloads is using failover clustering.

In this video interview with TFiR, SIOS’ Ian Allton discusses high availability considerations for the manufacturing industry. He explains that one of the reasons why ‘failover clustering’ is the most common way to protect workloads is because it is cost-efficient and delivers upwards of 99.99% availability. Failover clustering software works by configuring a second server with the same specifications as the primary server, and then the failover clustering software monitors the operating system and the application. Should it detect an error or issue, it will failover the software from the primary server to the secondary server, avoiding an outage. Contact us for more information.

Tune in to this episode to learn more about how to avoid downtime.

Reproduced with permission from SIOS

Webinar: Handling Single Points of Failure – SAP High Availability

Webinar: Handling Single Points of Failure – SAP High Availability

Moving SAP workloads to the cloud can help improve availability – but is it enough to meet your SLAs? Will it add complexity? Learn how to understand your cloud availability SLAs, options for maintaining SAP availability in the cloud, and how to ensure best practices for HA and disaster recovery of SAP and SAP HANA.

Reproduced with permission from SIOS

Webinar: Understanding SQL Server Storage Options in Cloud

Webinar: Understanding SQL Server Storage Options in Cloud

One of the most complex aspects of cloud computing, specifically as it relates to database servers, is choosing the right storage options. Sure, you can get sub-millisecond latency, but how much does that cost, and does your application really need it? In this on-demand Symposium session, presented by Joey D’Antoni SQL Server MVP and Principal Consultant, you will learn about all of the options available to you for cloud storage, like SIOS DataKeeper, Amazon FSx, FSx OnTap, and others, how they work in conjunction with your favorite high availability solutions, and how to make those hard storage decisions.

Reproduced with permission from SIOS

Video: You Still Need A Backup & Disaster Recovery Strategy In The Cloud

Video: You Still Need A Backup & Disaster Recovery Strategy In The Cloud

In this video, Dave Bermingham, Director of Customer Success at SIOS Technology, talks about high availability in the cloud and how companies can best prepare themselves for failures.

How do you define high availability in the cloud?

• High availability and disaster recovery are key aspects of system management that aim to ensure services are not disrupted and data is not lost in the event of a problem.
• HA is achieved through redundancy and failover mechanisms with services running on multiple instances in the cloud. DR typically involves backing up systems and data, with plans in place to restore systems from the backups in the case of a disaster.
• While cloud providers do provide some tooling around high availability and disaster recovery, the onus ultimately falls on the customer to utilize these tools in their architecture.

Misconceptions about moving to cloud:

• Many people moving to the cloud tend to think you do not need to do anything to ensure resiliency or backups. Yet they need to be able to keep their data in sync ensuring there is no data loss across multiple cloud zones. However, you still need a robust backup and disaster recovery strategy in case of major outages.
• SIOS Technology can do real-time asynchronous replication between regions, giving customers a lower RPO.

What are the differences between HA/DR on-prem compared to in the cloud?

• Cloud platforms provide native tools and services for HA and DR, which can make it easier to implement in the cloud compared to on-prem since all the tools, utilities, and infrastructure are already in place.
• In the cloud, the cloud provider takes care of availability for things like hardware redundancy, network redundancy, and storage redundancy but the customer is responsible for everything else.
• This is where SIOS LifeKeeper comes in, monitoring the application tier and enabling you to take recovery actions. SIOS DataKeeper uses synchronized block-level replication or asynchronized between regions, and even enables a hybrid-cloud model.

Challenges for HA/DR in the cloud:

• Understanding and properly using all the high availability and disaster recovery tools is a key challenge. Each cloud vendor has its own unique set of tools and services, making it even more challenging in a multi-cloud environment.
• Data sovereignty and compliance is another key consideration since some regions have specific laws on where your data can be stored and transferred.
• Managing costs on an ongoing basis can be another challenge.

How does SIOS Technology help companies migrating to the cloud?

• SIOS DataKeeper moves data to the cloud, doing real-time block level replication from one server to another, from on-prem to the cloud, or between instances in different availability zones in the same region or even between regions with our asynchronous replication.
• SIOS helps manage the egress data cost by enabling data compression before the data leaves the region or availability zone achieving 3:1 or even 5:1 compression ratios.

Advice for customers:

• Understanding your needs is key, since not every application or service may require the same level of availability. It is crucial to prioritize according to the business needs.
• You need to assume that every component can fail and design the architecture so that any failures have a minimal impact on the overall service availability.
• Utilize automation where possible as it can significantly reduce the risk of human error and increase the efficiency and speed up recovery time.
• Make sure you are regularly testing to ensure your plan works as expected.