Superdeporte deploys large scale DR for 150+ databases

Their situation

From its base in Quito, Ecuador, Superdeporte Cia Ltda distributes and retails sports brands, including Nike, Puma , Adidas and Reebok, throughout Ecuador. With over 150 stores, they are the largest sports retailer in Ecuador, and amongst the largest sporting goods chains in South America. Under their commercial brand, Marathon Sports, they are a major sponsor of the Ecuadorian, Peruvian and Bolivian national football teams.

One of Superdeporte’s requirements for their new Point of Sale solution, that was to be installed in their 150+ stores, was that it be disaster resilient. Superdeporte’s IT provider, Renovation IT, needed an architecture that ensured individual stores could recover their sales data in the event of any disaster.

Overview

Situation:

Required their new Point of Sale solution to be installed in their 150+ stores
Standby™ is installed at each store to maintain an exact copy of the POS system's sales database
For a second level of disaster resilience Standby™ is also used to maintain a central copy of each store’s valuable sales database.
Standby™ ensures the integrity of the sales database by continually verifying the standby databases so successful failover can be performed at any time.

Results:

Complete DR solution required alongside the new POS system for 150+ stores
Replication of individual store databases locally and centrally
Replication of 6500+ daily individual store transactions
Central configuration, monitoring and management of all database instances

How we helped the client

Superdeporte and Renovation IT chose Dbvisit Standby as it was a demonstrably proven solution, and met all their Disaster Recovery requirements.

Standby™ is implemented at each of the 150+ retail stores to maintain an exact copy of the POS system’s sales database. For a second level of disaster resilience Standby™ is also used to maintain a central copy of each store’s valuable sales database.

Standby™’s user interface enables easy configuration, monitoring and administration of the large number of distributed databases located across many sites.

Standby™ ensures the integrity of the sales database by continually verifying the standby databases so successful failover can be performed at any time. In combination with the new POS system this enabled Renovation IT to deliver a robust and reliable POS system to Superdeporte.

Dbvisit Standby provides the full disaster recovery capabilities, and the Central Console feature we need to successfully protect and monitor our new POS system. The fact that the Dbvisit implementation addressed our two vital requirements, means we are very pleased with the result.

Alba Lucía Torres IT Manager Superdeporte

The positive outcome

Standby™ provides Superdeporte a best-practice DR solution for the local and central replication of their in-store sales databases.

All of Superdeporte’s 150+ stores use Standby™, transferring up to 6,500 daily sales transactions each.
Superdeporte have been using Standby™ to protect their most critical and sensitive information.

Standby™’s Central Console provides a single unified view of all database instances and ongoing replication activity. Its intuitive web-based user interface enables easy central monitoring and management of the distributed Standby™ installations. Administrators can use the central console to perform one-click resynchronisation, graceful switchovers, and action a failover in the event of a disaster.

The Standby™ solution is delivered with Oracle Standard Edition licenses, contributing significantly to the cost effectiveness of the solution.

Tags: Case Study, Oracle SE, Retail, Point of Sale, Disaster resilience, Easy manageability, Large scale DR

Replication of individual store databases locally and centrally

In summary

Standby™ has provided Superdeporte with a best-practice DR solution for their in-store sales databases that can be easily centrally managed and monitored. DR copies of these sales databases are maintained locally and centrally in near real-time.

• Complete DR solution required alongside the new POS system for 150+ stores
• Replication of individual store databases locally and centrally
• Replication of 6500+ daily individual store transactions
• Central configuration, monitoring and management of all database instances