Active-Active Data Replication in Real-Time for a Natural Gas Operator

Using Oracle GoldenGate

Gaz System is a designated natural gas transmission system operator in Poland. They decided to work with Goldenore to ensure business continuity and uninterrupted functioning of systems during upgrades.

The project challenge was to build high availability infrastructure to provide two-way data synchronization between data centers with critical metering databases.

ORACLE PLATINUM LEVEL

of data security

NO COLLISION

of incoming data between databases 

BUSINESS CONTINUITY

throughout the migration process 

Business Perspective

Challenges

  • The billing system is business critical, and its performance can impact revenue. ​The system was highly vulnerable due to relying on a single database.
  • Possible negative consequences included:​ loss of vital information necessary for billing clients​, financial losses caused by unavailability of the billing system, security non-compliance ​

Benefits

  • The risk of losing data from the billing system was instantly eliminated. The highest and most advanced level of security was achieved with a two-way exchange of data between redundant databases (Oracle Platinum)​.
  • Business continuity is ensured in case of database failure with an active replica​ keeping the billing system always online.

The Architecture

Implementing real-time data replication can solve current business continuity and data access problems, and be a starting point in a journey to an entirely data-driven enterprise.

Whether your business goal is optimizing infrastructure cost or transitioning to a more efficient data mesh architecture based on data fabric solutions, contact us for a free consultation, and let’s discuss different options.

Tech Perspective

Project Goals

  • All databases are mirrored with Active-Active real-time replication
  • Completely seamless switchover of applications between databases that does not require any administrative tasks
  • Validation and consistency of replicated data
  • Continuous monitoring of data replication

Outcomes

  • Databases and applications run continuously in multi-master mode
  • Actively used Disaster Recovery Center
  • Switching applications/databases doesn’t require any actions
  • Untinterupted future upgrades of databases and applications
  • Audit tables: monitoring of every action performed

Technology Partners

Oracle

Oracle is the company that has created the world’s first – and only – autonomous database that helps to organise and secure client data. Oracle Cloud Infrastructure provides increased efficiency, security and cost savings.

Schedule a free consultation

We’d love to learn about your business goals and guide you through optimal technology options.