Data Synchronization

1
Data Synchronization

• by
• Dennis Sparrow

2
Infrastructure

• New York Board of Trade (NYBOT) maintains 3 sites
• Primary Trading Floor
• Primary Data Center
• Backup Facility / Disaster Recovery Site

3
Infrastructure - Continued

• Self-Healing SONET Ring
• T1 connection between Primary Data Center and
  Primary Trading floor
• T1 connection between Primary Trading floor and
  Backup facility
• T3 connection between Primary Data Center and
  Backup facility

4
Primary Data Center
Trading Floor
50 MB per Connection
50 MB per Connection
650MB Self-Healing SONET Ring
T3
50 MB per Connection
BackUp Facility
5
Hardware

• IBM AIX P-Series Systems
• HP NonStop S Series Systems
• Sun Unix Systems
• Storage Area Network (SAN)
• Tivoli Storage Manager (TSM)
• Windows Servers

6
Databases

• Oracle
• DB2
• Sybase
• HP NonStop SQL and Enscribe files
• SQL Server

7
Data Synchronization

• Data synchronization for disaster recovery
  purposes
• Data Synchronization to bridge the mainframe and
  open platforms

8
Synchronization of Mainframes

• NonStop RDF/IMP
• Backup / Restores Tivoli Storage Manager

9
Synchronization Between Mainframe and Open Systems

• HP NonStop SQL/MP database to Sybase database
• HP NonStop SQL/MP database to Oracle database
• DB2 database to HP NonStop SQL/MP database

10
Data Synchronization forDisaster Recovery

• DB2 to DB2
• Oracle to Oracle
• Sybase to Sybase
• Back Office Replication
• File Servers
• Mail Servers
• Tivoli Storage Manager

11
Monitoring

• Vendor based monitoring tools
• In-house developed monitoring

12
Thank You!!