ARS consigue una pérdida de datos casi nula con Standby en la nube

Su situación

Con sede en Fort Collins (Colorado), Air Resource Specialists (ARS) ayuda a sus clientes a controlar y modelizar la calidad del aire y el cumplimiento de las normas medioambientales. ARS explota sistemas que captan y registran continuamente datos medioambientales de todo Estados Unidos, incluidas mediciones de la calidad del aire y datos meteorológicos.

Con el aumento constante de los requisitos de información y cumplimiento de la normativa por parte de los clientes, la disponibilidad de los datos en tiempo casi real de ARS es fundamental. Además, para mantener el crecimiento del negocio, sobre todo con clientes gubernamentales clave, el servicio requería un funcionamiento 24x7 los 365 días del año. ARS tenía 400 GB de datos recopilados de cientos de dispositivos en todo el país, algunos de los cuales se remontaban a 1980.

En 2017, ARS necesitaba una nueva y moderna solución de recuperación ante desastres para sus bases de datos, ya que su solución de 2013 estaba llegando al final de su vida útil. Esta solución de DR consistía en un servidor en espera replicado físicamente en el mismo campus. Los requisitos clave para la nueva solución eran una mayor resiliencia mediante la separación geográfica, la capacidad de ampliación futura y un bajo coste total de propiedad (TCO).

Overview

Solution:

The on-premise to cloud architecture enabled geographically distant replication and provides ARS with the ability to increase storage at any time
Installation and testing was simple requiring 12 hours of one DBA’s time
ARS calculated that the total cost of ownership of a hybrid solution was similar to that of a replacement server, but with the added benefit of an off-site DR location for their standby database improving resilience.

Results:

The standby has already been utilised in a hardware failure event, which delivered recovery in less than 15 minutes of downtime with near zero data loss
Standby™ was chosen to enable an on-premise to cloud standby architecture. This incorporated Standby™, Oracle Standard Edition, and the Oracle Cloud.

How we helped the client

An on-premises to cloud architecture using Standby™ was chosen as the disaster recovery solution due to low total cost of ownership, future expandability, and geographic separation. By using Standby™’s cloud replication feature, they were able to maintain and exceed the performance of their on-premises primary database, with the added resilience, security, and ease of deployment of a cloud-based server.

ARS calculated that the total cost of ownership of a hybrid solution was similar to that of a replacement server, but with the added benefit of an off-site DR location for their standby database improving resilience. It also gave them the flexibility to easily increase the solution’s capacity if required.

We have found Dbvisit Standby to be particularly easy to implement,
monitor and test, and the Dbvisit support team are always very quick to
respond when we need them. Overall, we’ve found Dbvisit Standby to be an
extremely cost-effective solution, based as it is on Oracle Standard Edition.

Besty Davis-Noland IT Manager Air Resource Specialists, Inc.

The positive outcome

The implementation of the hybrid DR solution incorporating Standby™, Oracle Standard Edition and Oracle Cloud was very quick and economical. The entire project took two weeks from start to finish, with a total of 12 hours effort from one DBA. This included the creation of the target Oracle Cloud environment as well as the testing of the standby database.

Standby™ regularly replicates up to 5.5GB of data daily for the 385GB database, demonstrating the ability for a cloud-based standby database to be deployed at scale.

This hybrid solution has provided extra resilience to ARS. The standby database is in a different geographic location to the primary database, providing added resilience in the event of a local disaster. ARS are content knowing that their DR strategy and tools are adaptable, proven and supported.

Another benefit of the hybrid solution has been the ability to quickly and easily add storage and compute resources to the standby database. This has enabled ARS to rapidly increase the capacity of the standby database without the need to purchase and install additional hardware.

The new DR solution has already been successfully implemented in a recent primary hardware failure. Rather than allow the primary server to continue to run and risk further degradation of the hardware, ARS performed a graceful switchover (planned switchover) to their standby database while they repaired the primary. The result was a downtime of less than 15 minutes and almost zero data loss.

Tags: spanish

RTO of 15 minutes

In summary

ARS’s current standby had reached end-of-life and required replacement that provided greater resilience, future expandability, and a low TCO.
Standby™ was chosen to enable a on-premise to cloud standby architecture. This incorporated Standby™, Oracle Standard Edition, and the Oracle Cloud.
The on-premise to cloud architecture enabled geographically distant replication and provides ARS with the ability to increase storage at any time.
RTO of 15 minutes
Near zero data loss