COVID-19 Update — We are available to assist you during these trying times. Please contact us for assistance.

Migrate to HPE NonStop for Higher Availability

Original Architecture

Situation

A large Japanese e-commerce company provides 24×7 shopping on a high-volume Java* cell phone application hosted by a four-node Oracle RAC in a Linux cluster. Oracle was used for the authorization system of a new digital money service with 300 tables.

Problem

  1. Scalability: An influx of new customers and their high volume of transactions created an Oracle RAC bottleneck. Users periodically experienced unacceptable wait times as a result.
  2. Availability: 90% of the end users experienced a system outage at least once per year.
  3. Recovery times: 25% of the end users experienced an outage lasting 10 hours or more. In some cases, the outage lasted more than 24 hours.

More Backstory

  1. The company approached Hewlett Packard Enterprise (HPE) for alternatives
  2. HPE introduced the NonStop X NS7 using the SQL/MX database
  3. The company performed an extensive Proof-of-Concept: Java app requirements tested on the NS7 with SQL/MX, proving the NonStop could satisfy the customer’s scalability, availability, and recovery time requirements
  4. The company decided to switch the application and database to the NonStop solution
  5. The company needed a Zero Downtime Migration approach:

HPE decided to use HPE Shadowbase to satisfy the ZDM requirements, and enlisted Gravic to assist.

Solution

In the original architecture, the provider used a custom tool to perform monthly batch backups from the production to the Cold DR system.  To facilitate the migration:

A. It started capturing the production database changes with HPE Shadowbase to an interim staging database.

B. It performed its normal monthly backup from the old production environment to the Cold DR site.

C. It used Ispirer for the initial load of the data from the Cold DR site to the new production environment.

D. It then started HPE Shadowbase replication of the change data from the staging database to the new production environment.

For subsequent synchronization of the data between the systems, the customer relied on HPE Shadowbase Oracle Log Source to continue to read the Oracle logs from the old production environment to push the database change data to the staging database server. It then replayed the changes from there to the new production environment.

F. During the project, HPE Shadowbase software was installed on the old production environment (to capture the database changes), the intermediate Linux staging database server (to store and forward the database changes), and the new NonStop production environment (to apply the database changes into the new production database).

When it came time to redeploy the payments application on NonStop X, HPE worked with the customer to convert all SQL statements using SQLWays from Ispirer – a company that specializes in providing tools to better facilitate database migrations converting database schema (DDL), data and server-side business logic from Oracle.

According to HPE, “After completing the data replication, the customer migrated the online application from old Oracle systems to new NonStop SQL in 15 minutes.”

Step 1

Step 1: Set up the NS7s and Staging Database

Step 2

Step 2: Copy the Production Database Changes to the Staging Database

 

 

 

Step 3

Step 3: Export the Data from the COLD DR System and Load the Data into the New Production Database

Step 4

Step 4: Copy the Change Data from the Staging Database to the New Production Database for Synchronization

 

 

 

 

 

 

 

 

 

 

Step 5

Step 5: Migrate the Users to the New Production System, Preserving the Old Environment (in Case of Fail-back)

 Outcomes

Final Architecture

Final Architecture

HPE Shadowbase Products of Interest


Contact us or your HPE Shadowbase representative, and learn how Shadowbase software will benefit you.

Further Reading

Case Study: Migration to SQL/MX from Oracle – detailed customer success stories from Japan

White Paper: Using HPE Shadowbase Software to Eliminate Planned Downtime via Zero Downtime Migration

Solution Brief: HPE Shadowbase Zero Downtime Migration

*Java is a registered trademark of Oracle and its affiliates

  • Copy to clipboard