Transcript VERITAS Corporate Launch

VERITAS Confidential
Copyright © 2003 VERITAS Software Corporation. All rights reserved. VERITAS, the VERITAS Logo and all other VERITAS product names and slogans are trademarks or registered trademarks of VERITAS Software Corporation.
VERITAS, the VERITAS Logo Reg. U.S. Pat. & Tm. Off. Other product names and/or slogans mentioned herein may be trademarks or registered trademarks of their respective companies. Specifications and product offerings
subject to change without notice.
VERITAS Database
Edition
for Sybase
Technical Overview Presentation
VERITAS Confidential
Agenda
•
•
•
•
•
Why do business with VERITAS?
Storage Management challenges
Database Edition for Sybase Overview
Higher Availability
Interoperability
VERITAS Confidential
Total Value Proposition
The Intelligent Storage Software Company …
Enabling business to operate without loss of revenue
due to IT related downtime!
VERITAS Solutions
Designed to enable business
processes to be more highly
available without requiring change
to the original business process
VERITAS Confidential
Who is VERITAS?
• VERITAS is the #1 worldwide provider of core storage
management software
• Founded in 1989
• Based in Mountain View, CA
• Over 5,700 employees in 36 countries
• Over $1.5B in revenue in 2001
• One of the Top 5 software companies in the world!!
VERITAS Confidential
VERITAS Software
• The most comprehensive Data
Availability solution suite in the
industry
• Best of Breed individual products
in key areas (Backup, Volume
Mgmt., File Systems, Clustering,
SANs, Replication, and more)
• Industry leader in worldwide,
enterprise-class service and
support
The only dedicated
storage management
• The only company that can offer
software company
the complete line of software
projected to invest $4B in
products necessary to implement
R&D over the next 5 yrs
storage area networks (SAN)
VERITAS Confidential
IT Storage Challenges
•
•
•
•
•
•
•
•
Do More With Less!
Performance
Failover
Backup Window Problems
Difficulty Managing Growth
Data Availability
Storage Vendor Independence
Tight Staffing Resources
VERITAS Confidential
Database Administrators’
Challenges
• Optimal database performance
• 24x7 availability of mission-critical databases
• Increasing management complexity
– High growth in data volume
• Complex data types (e.g., video, sound)
– Increasing number of users
– Diverse database server configurations
(e.g. replication servers)
VERITAS Confidential
VERITAS Database Edition
for Sybase
• Enhanced Performance
– Raw disk performance with ease of file system management
– Extent-based allocation
– Online performance monitoring and tuning
• High Availability
– Comprehensive fault monitoring and recovery
– Increased data integrity and availability for mission-critical
databases
– Online administration
• Improved Management
– Flexible storage configuration management
– JAVA-based Storage Administrator
VERITAS Confidential
VERITAS Solution:
Database Edition for Sybase
Sybase
Database Edition for Sybase
VCS
Agent for Sybase
Volume Manager Storage Administrator
Building
Blocks
VERITAS File System with (Cached) Quick I/O
VERITAS Volume Manager
VERITAS Confidential
HA Edition
Enhanced
Performance &
Manageability
VERITAS Confidential
Raw I/O Performance with
Ease of File System Management
Unique, total storage foundation solution to deliver the best of both worlds
Database Edition for Sybase
Raw Disks
Conventional File Systems
Advantages Disadvantages
Performance Manageability

Best OLTP
performance
Data
Reliability

VERITAS Confidential
No potential
for data loss
with data
written to
disks directly
“Invisible”
locations for
segments
 Difficult to
grow
segments

Advantages
Disadvantages
Manageability
Performance



Segment
organization
System-wide
backup and
restore
policies
Easy to create
and add
devices
for Sybase


Lower database
throughput
(30-90% of
raw disk)
Higher CPU
overhead
Data Integrity
Potential
data loss
Database Edition for Sybase
Performance
• Raw disk performance
– OLTP throughput for Database Edition at least equal to
raw disk configurations
– Achieves raw partition performance without sacrificing
data integrity
• Large I/O optimization
– Accelerated I/O performance for large files
(e.g., video, images) because of extent-based allocation
• Database application-specific storage layouts
– Striping and mirroring configurations for parallel data
transfers
• Online performance tuning
– I/O balancing and tuning without database downtime
VERITAS Confidential
Database Performance Issues
with Conventional File Systems
• Redundant data buffering
– System buffer cache
 Redundant buffer copying
 Inefficient use of memory
Database buffer cache
• Single writer lock per file at UNIX file system level
– UNIX file-level lock
Sybase page or row-level
lock
 Serialized write operations
 Impact on performance in multi-user client/server
environments
• Kernelized asynchronous I/O (KAIO)
– Supported only on raw devices, not on regular files
VERITAS Confidential
Raw Disk Performance
Quick I/O Database Accelerator
• Break-through VERITAS File System interface technology
• Presents regular VERITAS File System files to Sybase as
raw character devices (Sybase certified)
Quick I/O
regular raw
file device
Sybase
Server
– Allows parallel updates to database files for increased
throughput
– Takes advantage of kernel async I/O (Solaris’ KAIO)
– Sybase handles locking for data integrity
• Eliminates traditional UNIX file system overhead
– Removes single-writer lock at file level
– Bypasses redundant data buffering
VERITAS Confidential
Database Edition Performance
• Database Edition 1.4 with Cached Quick I/O delivers up
to 145% better OLTP performance than UFS Direct I/O
80%
Raw I/O
Quick I/O
60%
VxFS Buffered I/O
VxFS Direct I/O
40%
UFS Buffered I/O
UFS Direct I/O
Sybase Cache Size
VERITAS Confidential
6GB
4GB
0%
3GB
20%
2GB
•Sun E4500 (8 CPUs
and 8 GB of RAM) ;
Solaris 8 (64-bit)
•DB Edition 2.2 for
Oracle
•Sybase ASE 12.0
(64-bit)
•TPC-C scale factor
of 480 warehouses
100%
1GB
Tested
configuration
included:
Percentage of Raw Device Performance
Raw = 100%
120%
Large I/O Optimization
• VERITAS File System allocates disk space in
groups of contiguous blocks or “extents”
• Extent-based allocation can accelerate I/O by
increasing the I/O transfer size in the File
System
• Optimal for large files
– Large Sybase segments
– Binary Large Objects (BLOBs)
(e.g., images, sounds)
VERITAS Confidential
VERITAS File System
Extent-based Allocation
Veritas File Systm Inode
Extent Addresses
Disk Block
Disk Block
Disk Block
Disk Block
Disk Block
Disk Block
Disk Block
Disk Block
Disk Block
Disk Block
Disk Block
Disk Block
Disk Block
Disk Block
Disk Block
Disk Block
Direct Address 0 / Length
Direct Address 1 / Length
Direct Address 2 / Length
Direct Address 3 / Length
Direct Address 4 / Length
Direct Address 5 / Length
Direct Address 6 / Length
Direct Address 7 / Length
Direct Address 8 / Length
Direct Address 9 / Length
Single Indirect Block
Double Indirect Block
VERITAS Confidential
•Extent-based allocation is faster than
block-at-a-time based operations.
•Metadata overhead is reduced, and less
overhead is necessary with sequential reads.
Logical Volumes as a Highly
Performing Platform for Databases
• Resolving hot spots can be:
– Time and resource consuming
– Analysis not guaranteed to work
• Past behavior doesn’t predict future behavior
– May not be possible
• Creating logical volumes of physical disks can
balance I/O loads
– Through data striping
VERITAS Confidential
Online Performance Tuning
• Flexible I/O throughput analysis
– Disk-based (not limited to database schemas)
– Command line and graphical performance analysis tools
• Online reconfiguration with JAVA-based VERITAS
Storage AdministratorTM
–
–
–
–
Balance I/O loads without any database downtime
Easy navigation of entire storage environment
One step process in creating Volume with a File System
Ability to shrink/grow volumes without loss of data availability
VERITAS Confidential
Improved Manageability
VERITAS Confidential
Database Edition for Sybase
Manageability
• Familiar file system administration for Sybase
databases
– Combines raw I/O performance and ease of file system
management
• Large database configuration support
– Supports large file systems to simplify management
• Simplified administration of physical storage
configurations
• Easy-to-use, JAVA-based graphical user interface
• Guide for setting up and tuning databases
VERITAS Confidential
Large Database Configuration
Support
• Database Edition can support file systems up to
1 TB in size
• File system sizes are not limited to underlying
device sizes
– No need to manage multiple file systems per
database
– Online resizing further simplifies database device
expansion and retraction
VERITAS Confidential
Free Space Management
• Dynamically allocates required storage from a free
space pool
• Provides flexible storage allocation options
– Goal-directed approach without any visibility to physical
space allocation
• 3-way mirror, striped 6 ways with a capacity of 12 GB and
stripe unit size of 32K
or
– Explicit configuration of volume layout
– Configuration utility relies on rules for safety and
performance
• Two mirrors in the same volume will never be on the
same disk
VERITAS Confidential
VERITAS Storage Administrator
• Visual configuration management and
performance analysis
– Visual representation of physical to virtual relationships
– Allows one-step graphical execution
of common configuration
management steps
– Supports performance
analysis and tuning
VERITAS Confidential
Database Administrator’s Guide
• Cookbook for setting up and tuning database
environments
• Tailored for DBAs to optimize database storage
layouts
– Presents various storage configuration options
– Recommends optimal configurations specific to
database application workloads
VERITAS Confidential
High Availability
VERITAS Confidential
Causes of Downtime
Planned
Software
30 %
40 %
Other
5%
15 %
10 %
People
Hardware
VERITAS Confidential
Source: Gartner, Oct. 2000
Availability Index
Fault Tolerant
Business Continuance Site
4-Node Cluster
Windows Data Center Server
Replication
High
Availability
Application Data Management
2-Node Cluster
Volume Management
RAID-5
Enhanced
Mirrored Set
IDR
Basic
Backup
VERITAS Confidential
Cost
Database Edition for Sybase
Availability
• RAID redundancy techniques
– Various storage configuration options to protect mission-critical
data from disk failures
• Hot relocation
– Additional level of protection from disk failures
• Online administration
– Storage reconfiguration and maintenance without downtime
• File System Snapshot Backup
– Protects critical Sybase data from logical and media errors
• Automatic monitoring and recovery of Sybase
dataservers
– Protection from system and application failures with Database
Edition/HA for Sybase
VERITAS Confidential
Online Administration
• Enables DBAs and system administrators to
meet changing database storage requirements
without database downtime
– Supports online file system growth
• Online resizing of file systems and underlying volumes
• Easily create new segments or extend existing ones once file
system is expanded
– Allows database storage reconfiguration
• Moving data between physical devices
• Defragmenting mounted file systems
• Changing RAID level
VERITAS Confidential
Database Edition/HA for Sybase
• Integrates comprehensive fault management
system
– VERITAS Cluster Server
– VERITAS Cluster Server Agent for Sybase
• Automatically detects and recovers from a
system failure
• Monitors and restarts Sybase instance after
detecting Sybase dataserver failure
VERITAS Confidential
Database Edition/HA
VERITAS Cluster Server
• Sophisticated availability
configuration management
• Clustered HA solution allowing
2-32 server scalability
• 1:1, Any:1 and 1:Any policybased failover
• Application level cascading
failover
• Fast Kernel-to-Kernel
communication & failover
• Certified 3rd party support for
SCSI, SAN & NAS storage
• Centralized Cluster Manager
console for HP-UX, Solaris and
Windows NT
VERITAS Confidential
Optimizing
Performance & Availability
VERITAS FlashSnap
VERITAS Confidential
Benefits of FlashSnap
•
•
•
•
•
•
Increase revenue
Simplify environment maintenance
Simplified data warehousing
Simplified application testing
Simplify batch processing
Cost savings
VERITAS Confidential
VERITAS FlashSnap Option
•
•
•
•
•
•
Point in time copy of data
Used on-host or off-host
Supports multiple copies of data
Enables off-host analysis and reporting
Fast Resynchronization of Volume Snapshots
Hardware independent
VERITAS Confidential
Dynamic Group Split and Join
•
•
•
•
•
Feature of FlashSnap
Allows split of a dynamic disk group
Allows 2 dynamic disk groups to be joined
Enables easy re-organization of data
Enables off-host processing
VERITAS Confidential
Off-Host Processing
• Why ?
– Reduce the load on the production host
– A more consistent I/O pattern for tuning
• Operations
–
–
–
–
–
–
Backup
Reporting
Decision Support
Training/Testing
CRM
….
VERITAS Confidential
Off-Host Processing in SAN
Environment
Two node cluster - production
Departmental
switches
Decision support server
SAN switch
Storage array
VERITAS Confidential
Storage array
Storage array
Off-host Processing
App A
App B
App A
App B
Sybase
Quiesce
Sybase
Sybase
Sybase
File System
File System
Volume Manager
Volume Manager
Driver Stack
Driver Stack
Import Disk Group
Snapshot
Take Volume Snapshot
Break off Mirror
VERITAS Confidential
Why resync the whole mirror?
Mirror 1
Mirror 2
/fs/OracleDB
Mirrored Volume
VERITAS Confidential
Fast Resync
Data Change Map
Mirror 1
Snapshot
/fs/…
/fs/….
Split Volume
VERITAS Confidential
Fast Resync
Data Change Map
Mirror 2
Mirror 1
/fs/……
FastResync Volume
VERITAS Confidential
Storage Checkpoints
• A consistent, point-in-time image of file system
• Identifies and maintains modified file system
blocks
• Mountable: Read-only or R/W
– All file system functions can be performed
• For performing certain tasks when storage
capacity is an issue
VERITAS Confidential
Summary
• Taking storage virtualization to a new level
• Enable on-host and off-host processing
• Fast Mirror Resynchronization
• Delivers point-in-time copies of data with
minimal storage overhead
• Commitment to HA
• Hardware independent
VERITAS Confidential
Support
Sybase Certified!
NEW
VERITAS Confidential
DBE Version
ASE Version
Solaris Support
DBE 1.5 for
Sybase
and DBE/HA 1.5
for Sybase
ASE 11.5, 11.9.2,
12.0, 12.5*
Solaris 2.6, 7, 8
DBE 1.4 for
Sybase and
DBE/HA 1.4 for
Sybase
ASE 11.5, 11.9.2,
11.9.3, 12.0
Solaris 2.6, 7, 8
DBE 1.3 for
Sybase and
DBE/HA 1.3 for
Sybase
ASE 11.5, 11.9.2,
11.9.3, 12.0
Solaris 2.5.1, 2.6, 7
DBE 1.2.3 for
Sybase and
DBE/HA 1.2.3 for
Sybase
SQL Server 11.0.3,
ASE 11.5
Solaris 2.5.1, 2.6
* Note: ASE 12.5 only supports Solaris 8. Customers running DBE
1.5 on ASE 12.5 can only operate on Solaris 8.
Thank You
Questions?
VERITAS Confidential
VERITAS Confidential
Copyright © 2003 VERITAS Software Corporation. All rights reserved. VERITAS, the VERITAS Logo and all other VERITAS product names and slogans are trademarks or registered trademarks of VERITAS Software Corporation.
VERITAS, the VERITAS Logo Reg. U.S. Pat. & Tm. Off. Other product names and/or slogans mentioned herein may be trademarks or registered trademarks of their respective companies. Specifications and product offerings
subject to change without notice.