SIOS Datakeeper Archives - SIOS SANless clusters

MailHippo Protects Email Encryption Application on SQL Server with SIOS DataKeeper Cluster Edition

November 2, 2023 by Jason Aw Leave a Comment

MailHippo Protects Email Encryption Application on SQL Server with SIOS DataKeeper Cluster Edition

“SIOS DataKeeper saved us from becoming non-operational.” – Chris Almond, CEO, MailHippo

Secure information transmission is essential to today’s healthcare providers. From accessing patient test results and medical images to sharing doctor’s notes and health records, quality healthcare requires the ability to manage and transmit health information securely and efficiently. However, many organizations face the challenges of doing so while complying with the Health Insurance Portability and Accountability Act (HIPAA), which requires them to ensure confidentiality, integrity and security of any electronically stored, protected health information (known as “ePHI”). MailHippo (https://www.MailHippo.com) is an innovative company that enables healthcare providers to send and receive encrypted HIPAA-compliant emails and to collect medical data using HIPAA compliant Web forms. When MailHippo needed a way to protect their critical secure email platform from downtime and disasters, they turned to SIOS Technology.

The Environment

The company’s business-critical encrypted email platform runs on SQL Server 2016 instances in two geographically separated, on-premises data centers.

The Challenge: Cost-effective High Availability for SQL Server

MailHippo needed a robust high availability and disaster recovery (HA/DR) solution to protect the SQL Server database that their mission-critical applications run on. “Our medical provider customers expect their HIPAA compliant email to be available 24/7,” said Chris Almond, CEO, MailHippo. “Their information is essential to their ability to provide vital health services to their patients.”

The company considered using Windows Server Failover Clustering (WSFC) and SQL Server Enterprise Edition with Always On Availability Groups to add HA protection. However, they did not want the cost and complexity of purchasing and managing the shared storage required by this solution, which would also introduce the risk of a single point of failure. “We needed an affordable, reliable solution that would allow us to use SQL Server Standard Edition,” said Almond. They also wanted to leverage their two on-premises data centers running across different geographic regions to provide disaster recovery protection.

The Solution: SANless High Availability & Disaster Recovery

After rigorous research of HA/DR products, MailHippo decided to build a two-node cluster using SQL Server Standard Edition Always On Failover clustering in one data center and a third node in their second data center for disaster recovery. By simply adding SIOS DataKeeper Cluster Edition to their WSFC, the company could replicate local storage on the primary cluster node synchronously to the second node and asynchronously to the third node.

With this cluster configuration, if a SQL Server failure on the primary cluster node is detected, operation is automatically moved to the secondary node and operation continues. Since DataKeeper synchronizes local storage on both primary and secondary nodes, operation can continue with an RPO of zero. In the event of a site-wide disaster, operation can be switched to the DR site.

“The tight integration with WSFC was one of the key reasons we chose SIOS,” said Almond. “We used WSFC to create the clusters for our SQL Server environment just like a traditional cluster, and we simply added SIOS DataKeeper Cluster Edition. This lets us use local storage without the need for a costly SAN.”

SIOS software uses performance-optimized host-based, block-level replication to synchronize local storage on the primary and standby nodes in the cluster, creating storage that appears to the WSFC as a SAN.

The Results: Fast & Reliable Failover

MailHippo has been using SIOS SANless clusters and achieving high availability and disaster protection. By using SANless clusters, MailHippo also eliminated the single point of failure risk of a shared storage cluster. “SIOS DataKeeper is a great fit for a rapidly growing company like ours. It’s easy to use, cost-efficient and most of all, reliable,” added Almond.

The SIOS system was put to the test in a recent downtime incident. “We lost our primary SQL Server when both power supplies failed,” said Almond. “But thanks to SIOS, we were able to get the platform back online quickly. Without DataKeeper, we would have required many hours and a mountain of manual work to recover everything. SIOS DataKeeper saved us from becoming non-operational.”

Reproduced with permission from SIOS

Hitachi Moves Leading Insurance Company’s Mission Critical System to Azure Ensuring High Availability

May 9, 2023 by Jason Aw Leave a Comment

Hitachi Moves Leading Insurance Company’s Mission Critical System to Azure Ensuring High Availability

SIOS DataKeeper chosen for its ability to enable data replication on Azure

A major insurance company wanted to migrate its mission-critical system called ‘channel system’ to the cloud. Channel system included both an in-house system, used by its employees and call centers, and a third-party system used by its sales agencies. The system is positioned as the core system of the company’s business – even a short system failure and downtime would impact the business largely.

The channel system operated in an on-premises, virtualized platform provided by Hitachi. However, the hardware was aging and support for the middleware was ending. This led the insurance company to launch a project to update the infrastructure and move the system to the public cloud to cut running costs. Hitachi took on the responsibility for configuring the system for this project.

The Environment

The channel system’s architecture mostly consisted of Windows software. “We decided to adopt Azure as the cloud platform as we could confirm that there was a high affinity between the system architecture and Microsoft Azure, and it would be the most cost-effective option. There were some things that cannot be changed, but we focused on placing first priority on the customer’s needs,” said Takuro Nishino, System Engineer at Hitachi.

The Challenge

One of the company’s requirements for the new infrastructure was to build a cluster configuration. Additionally, the database, which was built with a cluster configuration using DBMS, along with the job management middleware ‘JP1’ had to be configured in a cluster node in order to secure high availability (HA) even after the cloud migration. The existing system used WSFC (Windows Server Failover Clustering) to configure the HA cluster using Windows Server functions with a shared storage (SAN).

However, as of 2019, it was not possible to have a SAN-based configuration in Azure. Changing the HA software was considered as an option, but, “Considering the impact on the system, the priority was to move the system to the cloud while maintaining the application and infrastructure architecture as much as possible.” said Nishino. Hitachi decided to look for a solution that will both maintain the WSFC cluster configuration and replicate data without the SAN, while using the same HA software.

The Evaluation

After some research, Hitachi found SIOS DataKeeper, a data replication software that can build a cluster and integrate with WSFC on Azure. DataKeeper is an Azure-certified product, which enables you to synchronously replicate data from the active node to the standby node. By using DataKeeper with WSFC, the company would be able to make JP1 redundant. Hitachi also officially supported and had experience with this configuration. “DataKeeper was the only solution that made our project feasible – migrating to the cloud while maintaining the cluster configuration, without changing the HA software,” Nishino recalled.

Along with Hitachi, Hitachi Solutions, having a track record of implementing DataKeeper, took part in this project by creating detailed design documents and construction procedure manuals. The actual work of implementing DataKeeper was done by members of the Insurance company’s IT department.

The Solution

Hitachi Solutions created the basic designs and detailed designs after defining the requirements, and also provided templates to make it easier for the insurance company to implement the system. During this process, thanks to DataKeeper’s easy-to-understand features such as the parameter settings. Hitachi Solutions was able to create a procedure manual without any difficulty by simply customizing the default values to suit the customer environment. Hitachi Solutions also created a DataKeeper testing environment within its own local environment to identify any issues in advance – this process helped them create accurate procedure manuals and configure the production environment smoothly.

The Results

In October 2022, the insurance company’s system migration to Azure was completed. Since the migration, the HA cluster configuration – DataKeeper and WSFC – has been operating steadily. The company agrees that achieving an HA cluster configuration this way, without changing the system architecture or HA software, was the best way to migrate the system to Azure.

Hitachi and Hitachi Solutions were able to succeed in the insurance company’s cloud migration project by integrating DataKeeper within the HA cluster configuration. “The fact that we were able to introduce DataKeeper in our customer’s project was a great achievement. We’d like to apply our knowledge and achievements gained from this project in other Azure projects as well,” said Kenta Otsuka, Sales at Hitachi. “In fact, we have proposed DataKeeper to other clients who are also considering a migration of their systems to Azure. The experience of working with SIOS Technology through Hitachi Solutions and the skills and knowledge we gained will definitely contribute to our business in the future.”

“When the project began, Azure didn’t have a shared disk function, so DataKeeper was the only option. Even though SAN-based configuration is currently available in Azure, based on the fact that we were able to achieve a smooth migration and stable operation in this project by implementing DataKeeper, DataKeeper will continue to be a solution when redundancy is required in Azure migration and configuration projects,” said Satoshi Noguchi, System Engineer at Hitachi.

Download case study here

Reproduced with permission from SIOS

Epicure Protects Business Critical SQL Server with Amazon EC2 and SIOS SANLess Clustering Software

January 13, 2023 by Jason Aw Leave a Comment

Epicure Protects Business Critical SQL Server with Amazon EC2 and SIOS SANLess Clustering Software

SIOS DataKeeper Cluster Edition Software Provides High Availability and Disaster Protection.

Epicure, Canada’s leading direct sales company, sells healthy, easy-to-prepare food products through a network of over 16,000 consultants. The company relies on two websites for its critical business operations. Their public website provides company and product information, recipes, blogs, and enrollment information to its customers and to people interested in becoming a consultant. Their internal website provides consultants with important information about products and enables them to place all of their orders. “Our websites are vital to our business,” said Russell Born, Senior Network Infrastructure Administrator at Epicure.

The Environment

Both of Epicure’s websites run on a single server using two instances of SQL Server Standard Edition—one for each website. As the company expanded its products and services, the Epicure IT department needed to update and to ensure both of its business-critical websites would continue to operate in the event of failures or disasters. They decided to move both websites from a third-party hosted facility to its on-premises data center and to use Amazon Web Services EC2 cloud for disaster recovery. “By bringing the sites in-house, we could ensure that our websites would deliver excellent user experiences for both our customers and consultants as our business continues to grow,” said Born.

The Challenge

As part of this website update process, Epicure IT staff wanted an efficient, cost- effective way to provide high availability and disaster protection for both websites while continuing to run them on two instances of SQL Server Standard Edition.

“We didn’t want the added expense of moving to SQL Server Enterprise Edition if we could provide HA and DR with the more cost- effective Standard Edition,” Born said.

The Solution

Using SIOS DataKeeper Cluster Edition software, Epicure IT staff created a two-node SANLess cluster in an active-passive failover configuration that enables each SQL instance to failover independently. One cluster node is in the Epicure on-premises data center and the second node is in an instance of the AWS EC2 cloud. Epicure IT staff created the SIOS SANLess clusters and configured them using the software’s intuitive graphical user interface.

The Results

The SIOS software provided Epicure with an easy, cost-efficient way to provide HA and DR protection for its business-critical SQL Server applications without the cost and complexity of building out a remote DR site or purchasing costly SAN storage or SQL Server Enterprise Edition licenses. “The SIOS software has allowed us to create a hybrid solution that provides the cost savings of running on-premises and the reliability and flexibility of running in the cloud,” said Born. “Because we know that if there is a website outage, it will failover automatically, our IT team can now focus their attention on other priorities to strengthen our business.”

Reproduced with permission from SIOS