1 / 10

BID208: Sybase IQ Multiplex Disaster/Recovery

BID208: Sybase IQ Multiplex Disaster/Recovery. Samuel Foster President, FosterSoft, Inc sam@fostersoft.com August 15-19, 2004. Sybase IQ Multiplex - Disaster Recovery. Sybase IQ Multiplex The driving force behind Multiplex is disaster/recovery

brody
Download Presentation

BID208: Sybase IQ Multiplex Disaster/Recovery

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. BID208: Sybase IQ Multiplex Disaster/Recovery Samuel Foster President, FosterSoft, Inc sam@fostersoft.com August 15-19, 2004

  2. Sybase IQ Multiplex - Disaster Recovery • Sybase IQ Multiplex • The driving force behind Multiplex is disaster/recovery • Managing systems across multiple sites for maximum availability • An automated enterprise architecture with advanced management and administrative functions

  3. Sybase IQ Multiplex – Disaster Recovery • Business Challenge • Provide business continuous operations for the TB data warehouse • Solution • Sybase IQ Multiplex, Sun Microsystems Sun Fire hardware, EMC Symmetrix SAN • Results • Provided a near fault-tolerant environment • Accommodated future growth • Reduced “off-hours” data loads by 25% • Improved query response time by 35%

  4. Sybase IQ Multiplex – Disaster Recovery • Why is the Data Warehouse Considered Mission Critical? • Why Disaster/Recovery? • Data Corruption • Loss of Hardware • Loss of Facilities • How Much is Down Time Going to Cost Us?

  5. Writer Writer Catalog Catalog Reader Reader Catalog Catalog IQ IQ IQ IQ Sybase IQ Multiplex – Disaster Recovery Sun V880 – Solaris 2.8 32 GB RAM (8 x 900 MHZ) Sun V880 – Solaris 2.8 8 GB RAM (4 x 900 MHZ) Primary Site Data Recovery Site Bi-directional SRDF Replication EMC Storage EMC Storage

  6. Sybase IQ Multiplex – Disaster Recovery • Stop Servers at primary site, if necessary • Start the standby reader server at the D/R site • Promote the standby query server to a write server • Build the new reader server at the D/R site • Permit users to connect to new IQ Reader at the D/R site • Configure administrative functions • Activate BCV scripts to become operable at D/R site

  7. Sybase IQ Multiplex – Disaster Recovery • Sybase IQ Multiplex • Fault Tolerance Enterprise Data Warehouse • Point-in-Time Copies of Data • Local BCVs • SRDF to D/R site • Remote BCVs • Reliable • Flexible • Scalable

  8. Sybase IQ Multiplex – Disaster Recovery • How It Works • Primary Host • Main Copy • New Data Loads occur nightly • Multiplex is synchronized after loads, before BCV • Local Copy (BCV) • Synchronized with Main Copy • If problems occur with Primary Copy, switch to BCV • T-x used only for long term operation from D/R site

  9. Sybase IQ Multiplex – Disaster Recovery • How It Works (cont’d) • Secondary Host • Main Copy • Synchronized with Primary Host Daily • T-1 BCV • T-1 is a previous day copy, used for failover in case disaster affects Main Copy • T-2 BCV • T-2 is a variable, (typical 1 week out)

  10. Sybase IQ Multiplex – Disaster Recovery • Advantages • Multiple copies of data to accommodate media failures, corruption, and/or catastrophic disasters • Replicate copy of the IQ Data warehouse • Near instant recoverability for database and/or device failures • No tapes or dumps required • Minimum Down Time • Approximately 30 minutes to utilize BCVs on local host • Approximately 60 minutes to failover to D/R site

More Related