REP708: Combining Sybase Mirror Activator and EMC SRDF for better Disaster Recovery Solutions

1. REP708: Combining Sybase Mirror Activator and EMC SRDF for better Disaster Recovery Solutions Dick Wiss Sybase Director of Engineering Dick.Wiss@sybase.com KJ Bedard EMC Database Solutions Team Bedard_KJ@emc.com August 15-19, 2004

2. Agenda • Business problem • Sybase solution • Current alternatives • Mirror Activator • Mirror Activator with EMC SRDF • Summary

3. The Enterprise. Unwired.

4. The Enterprise. Unwired. Industry and Cross Platform Solutions Manage Information Unwire Information Unwire People • Adaptive Server Enterprise • Adaptive Server Anywhere • Sybase IQ • Dynamic Archive • Dynamic ODS • Replication Server • OpenSwitch • Mirror Activator • PowerDesigner • Connectivity Options • EAServer • Industry Warehouse Studio • Unwired Accelerator • Unwired Orchestrator • Unwired Toolkit • Enterprise Portal • Real Time Data Services • SQL Anywhere Studio • M-Business Anywhere • Pylon Family (Mobile Email) • Mobile Sales • XcelleNet Frontline Solutions • PocketBuilder • PowerBuilder Family • AvantGo Sybase Workspace

5. Storage Resources Compute Resources Redundant Resources Site-Link Disaster Recovery Site: Expensive Insurance Primary Site Business Challenge • Needed: • Fast, cost-effective way to protect database transactions • Currently, the resources spent on Disaster Recovery (Site, Storage, Networking, etc.) are viewed as “expensive insurance” • Your business can’t afford to lose any transactions or be unavailable • Your business needs a way to leverage the resources at the Disaster Recovery site for reporting/query

6. Storage Resources Compute Resources Mirrored Resources Site-Link • Disaster Recovery Site: • Strategic Investment Primary Site Sybase Solution – Mirror Activator • For years companies have mirrored their storage as a simple but expensive disaster recovery mechanism. In reality the expense may have little or no utility unless a disaster occurs. Now with Sybase Mirror Activator companies can reduce the cost of mirroring and at the same time make productive use of their mirrored database assets.

7. Current Alternatives Disaster recovery options • Unfortunately, traditional disaster recovery solutions are viewed as “expensive insurance” because of their considerable costs and low return on investment (ROI). • Tier-one disaster recovery solutions require a system that replicates mission-critical data from an active (or primary) site to a standby (or alternate) site synchronously. • The two viable alternatives for replication in a disaster recovery solution are: Disk Block Replication or Transaction Replication.

8. Traditional SolutionsTypes: Synchronous vs. Asynchronous

9. Traditional SolutionsMethods: Disk Block vs. Transaction Replication

10. What is Needed? • CIOs and IT Managers need a way to combine the best aspects of both traditional Disaster Recovery methods • Including: • Guaranteed no data loss • Cost effective due to decreased bandwidth requirements • Standby Database that is always available • Faster recovery time • Available for query/reporting, maintenance purposes • Guaranteed transactional integrity and protection against data corruption • Solution that is platform independent • Standby Database that is always available • Helps in migrations, upgrades, maintenance etc.

11. Sybase Solution – Mirror Activator • Sybase Mirror Activator is an innovative solution for business continuity that enhances traditional database replication methods. It virtually eliminates downtime for business-critical applications by providing a continuously-available standby system. • Works in conjunction with Disk Block Replication solutions • Lowers the Total Cost of Ownership by significantly reducing the network bandwidth required for Database disaster recovery • Protects against data corruption since the standby DBMS is maintained through logical replication • Guarantees transactional consistency of the standby DBMS at any time • Increases availability by minimizing loss of business in the event of Planned/Unplanned Downtime • Increases utilization of the standby database by making it available for reporting and decision support

12. Integrates with Block Replication Integrates with Block Replication • Sybase Mirror Activator works in conjunction with Disk Block Replication to provide a standby DBMS • Extensive testing with EMC SRDF (white paper available) • Works with EMC SRDF, IBM PPRC, Veritas Volume Replicator, NetApp SnapMirror, and Hitachi TrueCopy Data Device DBMS DBMS Mirrored Log Device Mirror Activator Log Device Block Replicator App Server App Server File System Storage File System Storage Web Server Web Server Primary Site Disaster Recovery Site

13. Reduces Network Bandwidth • Reduces TCO by significantly decreasing the required network bandwidth by up to 50% • Reduces the amount of memory cache needed for the storage replication, since it is only mirroring the log • Improves performance and response time for applications • Only the primary log-devices need to be mirrored

14. Reduces Risk • Ensures transactional integrity of secondary data and protects against data loss • Replication is performed logically – using SQL statements off the replicated log device • Provides transactions in the correct order – disk replication ensures that all log transactions are replicated • By using disk mirroring, synchronous replication guarantees zero data loss in the event of disruption during replication • Protected against data corruption

15. Increases Availability of Data • Minimizes loss of business by reducing failover time – since secondary site is always available, the failover of applications is achieved in seconds or minutes as opposed to hours • Increases Service Levels for the business • Designed to avoid any single point of failure and provide automatic and graceful recovery from system failure

16. Mirror Activator with EMC SRDF • Currently the only certified solution available today • Joint solution virtually eliminates downtime • drastically reduces RTO (recovery time objective) in the event of disaster • Target systems, applications and databases are online and running at all times • SRDF synchronously replicates to the target while Mirror Activator reads the SRDF R2 device and asynchronously applies the data to the standby database using SQL • Mirror Activator with SRDF value proposition • Zero data loss solution • Reduced recovery time for planned/unplanned downtime

17. SRDF/S Differential Knowledge Via Track Tables • Fully independent of host operating systems, DBMS, filesystems • Bi-directional source-to-target(s) architecture • Architecture uses delta technology (Track Tables) • Efficient synchronization activity while simple in concept • SRDF/S license includes Synchronous, Semi-Synchronous, and Adaptive Copy Modes of operations • Support for native Gigabit Ethernet Directors for lower TCO 010 010

18. Source Target I/O write received from host / server into cache of source I/O is transmitted to the cache of the target Receipt acknowledgment is provided by target back to cache of source Ending status is presented to host / server SRDF/S—Synchronous Mode SRDF links

19. PowerPath Features • Automatic path failover • Dynamic load balancing • Volume manager operations • Automatic recognition of LUN hardware growth • Seamless import of same-host BCV devices • User-selectable storage allocation policies • Automatic detect and restore of failed components • Online configuration and management • Common HBA driver support across Symmetrix and CLARiiON • Write throttling • Consistency Group support (Symmetrix only)

20. Interconnect Topology Path Fault without PowerPath Host Application(s) SCSI Driver SD SD SD SD SERVER Host Bus Adapter HBA HBA HBA HBA STORAGE Storage

21. Path Fault with PowerPath Host Application(s) PowerPath SERVER SD SD SD SCSI Driver Host Bus Adapter HBA HBA HBA Interconnect Topology STORAGE Symmetrix / CLARiiON

22. SD SD SD SD I/O without PowerPath Queues Out of Balance Host Application(s) Request Request Request Request Request Request Request Request SERVER SCSI Driver Host Bus Adapter HBA HBA HBA HBA Storage

23. Request Request Request Request Request Request Request Request SD SD SD SD HBA HBA HBA HBA Interconnect Topology I/O with PowerPath Queues in Balance Host Application(s) PowerPath SERVER SCSI Driver Host Bus Adapter STORAGE Symmetrix / CLARiiON

24. SE 3 New Integrated Volume Management Host Application(s) PowerPath SERVER Volume Group Volume 1 Volume 2 SE 1 SE 2 STORAGE LUN 1 LUN 2 LUN 3 SE = Storage Element Symmetrix / CLARiiON

25. (Offline) (Quiesced) Quiesce the PDB; ensure the SDB is offline 3 1 Define relationship between R1 & R2 Synchronize (Establish) the data & log devices 2 Sybase Mirror Activator - Materialization SDB PDB R2 R1 SDB DATA RS PDB DATA dev001 dev001 SDB LOG PDB LOG dev002 dev002 dev003 dev003 MRA Primary Site Standby Site

26. (Offline) (Quiesced) Bring the SDB online, quiesce release PDB 5 Split the devices after synch 4 Synchronize (Establish) the data & log devices 2 Sybase Mirror Activator - Materialization SDB PDB R2 R1 1 Define relationship between R1 & R2 SDB DATA RS PDB DATA dev001 dev001 SDB LOG PDB LOG dev002 dev002 dev003 dev003 3 Quiesce the PDB; ensure the SDB is offline MRA Primary Site Standby Site

27. 1 Define or redefine R1 to MRA log device (R2) MRA reads R2 and updates the RS RS distributes changes to SDB 3 4 Synchronize (Establish) R1 to R2 2 Sybase Mirror Activator - Replication SDB PDB R2 R1 SDB DATA RS PDB DATA dev001 dev001 SDB LOG PDB LOG dev002 dev002 dev003 dev003 PDB LOG MIRROR MRA Primary Site Standby Site

28. Summary Mirror Activator reduces the cost and increases the utility of your current disaster recovery solutions • Reduces Cost: • Significantly reduces cost of database synchronous mirroring • Decreases network bandwidth requirements by as much as 50% • Reduces risk of corrupted data • Improves ROA: • Provides faster recovery time after failure • Ensures database continuity for both planned and unplanned downtime • Provides a read-only copy of the data that can be used for reporting, queries and analytics without impacting operational data • With EMC SRDF • The only certified solution today • See Sybase.com for white paper titled “Sybase Mirror Activator with EMC Symmettrix Remote Data Facility”