Title: Warm-standby and disaster recovery
1(No Transcript)
2(No Transcript)
3Why should you care about Database Downtime?
- Downtime Means Down Revenue
- Downtime Damages Relationships
- Downtime Disrupts Supply Chains
- Downtime Erodes brand and share value
- Downtime has Legal Repercussions
4Framework for Database Availability Strategies
Severity of Database Downtime
Latency of Database Recovery
5Severity of Database Downtime
Catastrophic
Unplanned
Severity of Database Downtime
Planned
No Downtime
Latency of Database Recovery
6Latency of Database Recovery
DisasterRecovery
Catastrophic
HighAvailability
Unplanned
Severity of Database Downtime
Planned
No Downtime
ContinuousAvailability
Latency of Database Recovery
7Strategies for Database Availability
Switchingand WarmStandbyReplication
ColdStandby
DisasterRecovery
Catastrophic
HighAvailabilityClusters
HighAvailability
Unplanned
Severity of Database Downtime
OfflineMaintenance
Planned
OnlineMaintenance
No Downtime
ContinuousAvailability
Latency of Database Recovery
8Online and Offline Maintenance
Switchingand WarmStandbyReplication
ColdStandby
DisasterRecovery
Catastrophic
HighAvailabilityClusters
HighAvailability
Unplanned
Severity of Database Downtime
OfflineMaintenance
Planned
OnlineMaintenance
No Downtime
ContinuousAvailability
Latency of Database Recovery
9High Availability Clusters
Switchingand WarmStandbyReplication
ColdStandby
DisasterRecovery
Catastrophic
HighAvailabilityClusters
HighAvailability
Unplanned
Severity of Database Downtime
OfflineMaintenance
Planned
OnlineMaintenance
No Downtime
ContinuousAvailability
Latency of Database Recovery
10Switching and Warm Standby Replication
Switchingand WarmStandbyReplication
ColdStandby
DisasterRecovery
Catastrophic
HighAvailabilityClusters
HighAvailability
Unplanned
Severity of Database Downtime
OfflineMaintenance
Planned
OnlineMaintenance
No Downtime
ContinuousAvailability
Latency of Database Recovery
11Cold Standby
Switchingand WarmStandbyReplication
ColdStandby
DisasterRecovery
Catastrophic
HighAvailabilityClusters
HighAvailability
Unplanned
Severity of Database Downtime
OfflineMaintenance
Planned
OnlineMaintenance
No Downtime
ContinuousAvailability
Latency of Database Recovery
12Combining Strategies for Database Availability
Switchingand WarmStandbyReplication
ColdStandby
DisasterRecovery
Catastrophic
HighAvailabilityClusters
HighAvailability
Unplanned
Severity of Database Downtime
OfflineMaintenance
Planned
OnlineMaintenance
No Downtime
ContinuousAvailability
Latency of Database Recovery
13(No Transcript)
14Online and Offline Maintenance
Switchingand WarmStandbyReplication
ColdStandby
DisasterRecovery
Catastrophic
HighAvailabilityClusters
HighAvailability
Unplanned
Severity of Database Downtime
OfflineMaintenance
Planned
OnlineMaintenance
No Downtime
ContinuousAvailability
Latency of Database Recovery
15Online maintenance
- Compressed Back-ups
- Quiesce Database
- Online index rebuild for DOL tables,
- Online update statistics,
- Online dbcc checkstorage
- Dynamic Reconfiguration
16Dynamic Reconfiguration Solution in ASE 12.5
Self-Tuning assisted by Dynamic Re-configuration
- Dynamic Reconfig params
- Total memory
- Number of user connections
- Number of locks
- Number of open objects
- Procedure Cache (absolute)
- Disk I/O structures
- Online index
- Monitoring agent will assess the health of ASE
using Systems Mgm API and automatically apply
configuration changes
Load
SM
ASE
DynamicRe-configuration
Monitoring Agent
17Quiesce Database
Primary
Secondary
200 AMquiesce database holdltcopy database
usingexternal commandgtquiesce database
release 700 AMdump tran with
standby_access 900 AMdump tran with
standby_access 1000 AMdump tran with
standby_access Repeat each houruntil activity
tapers off then lengthen intervals accordingly
210 AMdataserver-q .. 705 AMload
tranonline database for standby_access 907
AMload tranonline database for standby_access
1010 AMload tranonline database for
standby_access
Warm Stand by Model using Quiesce Database
18High Availability Clusters
Switchingand WarmStandbyReplication
ColdStandby
DisasterRecovery
Catastrophic
HighAvailabilityClusters
HighAvailability
Unplanned
Severity of Database Downtime
OfflineMaintenance
Planned
OnlineMaintenance
No Downtime
ContinuousAvailability
Latency of Database Recovery
19Cluster Availability
HA System
Establish
S2
S1
Companion
Node 2
Node 1
Disk
Disk
Local or Shared dual ported Storage
20Cluster Availability
HA System
Transparent Fail Over
S1
S2
S1
S1
Node 2
Disk
Disk
Local or Shared dual ported Storage
21Cluster Availability
HA System
Transparent Fail Back
S2
S1
Node 2
Disk
Disk
Local or Shared dual ported Storage
22Cluster Availability
HA System
Transparent Fail Back
S2
S1
Node 2
Disk
Disk
Local or Shared dual ported Storage
23Cluster Availability
HA System
Establish
S2
S1
Companion
Node 2
Node 1
Disk
Disk
Local or Shared dual ported Storage
24Summary
- Dynamic Re-Configuration
- Online maintenance
- Quiesce Database
- Sybase HA addressed Planned and unplanned
downtime - No client disconnects during HA failover
- No data loss
- Transparent client fail over
25(No Transcript)
26Warm Standby Replication and Switching
Switchingand WarmStandbyReplication
ColdStandby
DisasterRecovery
Catastrophic
HighAvailabilityClusters
HighAvailability
Unplanned
Severity of Database Downtime
OfflineMaintenance
Planned
OnlineMaintenance
No Downtime
ContinuousAvailability
Latency of Database Recovery
27Warm Standby Replication Value Proposition
- The only solution that addresses all areas of HA
- Key Benefits
- Works across the LAN and WAN - no geographic
restrictions - Database Integrity is guaranteed
- Redundant hardware can be leveraged for DSS or
load balancing - Automates the failover switch
28Disaster Recovery Solution
- Physical separation needed for Disasters/Site
failure - No geographic limitation
- Database integrity maintained
- Automatic switch of DBs regardless of locale
- Leverage secondary resources for DSS
Chicago Operations
ASE
PRIMARY DATACENTER
London Operations
ASE
SECONDARY DATACENTER
29Unplanned Downtime Solution
- Automated Failover and synchronization of client
connections - Synchronized Failback with no loss of data
ASE
PRIMARY DATACENTER
ASE
SECONDARY DATACENTER
SECONDARY DATACENTER
30Planned Downtime Solution
- Provide secondary copy for
- maintenance
- critical tasks, such as hardware/software
upgrades
ASE
PRIMARY DATACENTER
ASE
SECONDARY DATACENTER
SECONDARY DATACENTER
31Warm Standby with Open Switch
OpenSwitch
Replication Server
Active DB
Standby DB
Queue
32Warm Standby with Open Switch
OpenSwitch
Replication Server
Active DB
Standby DB
Queue
33Warm Standby with Open Switch
OpenSwitch
Replication Server
Active DB
Standby DB
Queue
34Warm Standby with Open Switch
OpenSwitch
Replication Server
Active DB
Standby DB
New Active
Queue
35Warm Standby with Open Switch
OpenSwitch
Replication Server
Active DB
Standby DB
New Active
Queue
36Warm Standby with Open Switch
OpenSwitch
Replication Server
Active DB
Standby DB
New Active
Queue
37Warm Standby with Open Switch
OpenSwitch
Replication Server
Active DB
Standby DB
New Active
Queue
38Warm Standby with Open Switch
OpenSwitch
Replication Server
Active DB
Standby DB
Queue
39Warm Standby Replication Summary
- The only solution that covers all areas of HA
- No geographic limitation
- Database integrity maintained
- Leverage secondary resources for DSS
- Automatic Failover and synchronized Failback
40(No Transcript)
41Case StudyMajor Credit Card Issuer
- Obvious purchase approval application needs HA
- Not so obvious the call center needs DB
availability - Customers seek immediate assistance when
requesting new cards, increasing credit limits,
and applying for loans. - Database availability required for service rep to
handle request - Also, requires data replicated from back-
front-office systems - Sybase Replication Server synchs customer data
- Collects data from heterogeneous sources
- Stores customer info in Sybase ASE, warm standby
for HA - Achieved 99.95 database availability
- Which contributed to customer acquisition and
retention
42Case StudyOnline Bond Trading Firm
- Incentive to avoid costs of Database Downtime
- Hundreds of millions in lost sales opportunities
each hour - Key benefit to customers is liquidity, which
requires HA - Frequent downtime is a violation of regulations
- Started with clean slate, but chose Sybase ASE
- Reasonable licenses, ease of finding Sybase DBAs
- Leading database for both financial apps and
availability - Sybase HA Option for fastest failover possible
- Building the business vs Protecting the Business
- For some companies, its time for HA phase
43Conclusion
- Data access is key to any availability strategy
- Databases require availability, same as network,
hardware, etc - Nows the time to re-evaluate your database
availability - As you do more business online, your need for HA
increases - Customers, partners, investors--expectations for
HA grow daily - Some companies have availability plans that are
years old - Rationalizing Return on Investment (ROI)
- Database availability solutions are more
affordable than ever - Avoid cost of business losses due to database
downtime - Reap benefits of business stability with database
availability