Transcript Dbvisit Software - Partner Presentation Template

Dbvisit Software Ltd.
Dbvisit Overview
1
Agenda
•
•
•
•
•
Dbvisit Software Ltd. Overview
Dbvisit Standby
Dbvisit Replicate
Customer Successes
Q&A
www.dbvisit.com
2
Dbvisit Software Ltd.
• Oracle Gold Partner
• Product engineers and technical support are Oracle database
gurus
• Regular presenters at Oracle events, User Groups, etc.
• Developer of the Dbvisit Standby product
• The global leader in disaster recovery solutions for Oracle SE
• 300+ Customers in 60+ Countries
• First product shipped in 2006
www.dbvisit.com
3
Representative Client List
4
Dbvisit Standby
•
•
•
•
•
•
A fully featured disaster recovery solution
Failover
Graceful switchover
Automatic creation of standby instance
RAC, ASM, OMF
Compression, secure, monitoring, encryption
5
Dbvisit Standby - Overview Diagram
www.dbvisit.com
6
What is a standby database?
• Primary database - Contains production data
that must be protected against any kind of loss
• Standby database - Copy of production
database that can be brought online to become
the production database
7
Standby database purpose
• Users can be transferred to the standby database (with
limited downtime) when main database has a major
outage
End Goal: Business Continuity
8
Dbvisit
Standby
Dbvisit Standby
Architecture - Detail Diagram
Primary Server
Standby Server
Archive log
transfer
Redo
Production
Database
Archive log
Archive log
Archive log
Archive log
Archive log
Archive log
Archive log
Standby
Database
Redo
Redo
Dbvisit Standby consists of 2
independent processes:
⁃
On the primary server
⁃
On the standby server
Dbvisit Standby process
on primary server
www.dbvisit.com
Dbvisit Standby process
on standby server
9
Command Line or GUI
www.dbvisit.com
10
Databases Supported
•
•
•
•
•
•
•
Enterprise Edition to Standard Edition (no EE Options)
Standard Edition
Standard Edition One
Standard Edition with RAC
Cloud deployment (e.g., Oracle on Amazon EC2)
Workgroup Server
XE
11
Dbvisit Standby Supported Systems
• Oracle database
+
+
8i to 11gR2
32 and 64 bit
• OS and storage
+
+
+
+
+
+
+
+
Windows: NT4, 2000-2008, XP, Vista, Windows 7
Linux: Intel, AMD, Itanium, and PPC
Unix: AIX, HP-UX, Solaris
Oracle ASM
Oracle Fail Safe
Oracle OMF
Oracle RAC
Microsoft Cluster Server
12
Additional Uses for
Dbvisit Standby
•
Reporting Database: offset load from primary
•
Shadow environment: bug investigation, etc.
•
Capturing snapshots: rollback overnight batch
•
Test environments: capture snapshots for testing
•
Offload backups: move backups to standbåy
•
Planned outages: minimize downtime during maintenance
13
Competitive Systems
• Manual Scripting
• Lacks documentation, support, upgrades
• No guarantee all contingencies considered
• Not user friendly, no reports,
• Double Take
• Copies data blocks – not transaction aware
• No protection against database corruption
• No reporting of time delay
• Ok for file systems, could be used with Dbvisit
• Oracle Data Guard – Requires Enterprise Edition
14
Case Study: Pythian
“We chose Dbvisit because we could
trust it to perform every time.”
• Oracle Platinum
provider of services
for database and
application software
• 140 worldwide
customers
• Recognized experts
in Oracle database
operations and
management
• 2011 Oracle Titan
Award winner
- Alex Gorbachev
Chief Technology Officer
www.dbvisit.com
15
Dbvisit Replicate
•
•
•
•
Comprehensive, high performance Oracle data replication
Real time alternative to GoldenGate and Streams
Uses wizards to install and configure
Share, migrate, and offload data
+
+
+
Designed for both Standard Edition and Enterprise Edition
Complete documentation and customer support
Ongoing upgrades
www.dbvisit.com
16
Dbvisit Replicate
• Replicates both:
+
+
DML (data changes)
DDL* (structure changes)
* Not all DDL is supported (ie create tablespace is not supported)
•
•
•
•
•
•
•
•
Low latency, low overhead, low cost
2- and 3-tier architecture
1-way and 2-way replication
Very simple to very complex replication topologies supported
Uses efficient redo log-based Change Data Capture
Uses its own internal redo log mining technology
Full error capture and conflict resolution built-in
Robust notification capabilities
www.dbvisit.com
17
Dbvisit Replicate Comparison
FEATURE
DBVISIT REPLICATE
GOLDEN GATE
STREAMS
COMMIT TYPE
Optimistic commit.
Does not wait for
commit before
applying
Waits for commit
before applying
ENTERPRISE EDITION NEEDED
No
No
Yes
MYSQL and SQL SERVER TARGET
Yes
Yes
No
ORACLE CROSS PLATFORM
Yes
Yes
Yes
LOB support
Coming end Nov11
Yes
Yes
SETUP WIZARD
Yes
No
No
OFFLOAD/DOWNSTREAM MINE
Yes
No
Yes
CONFLICT RESOLUTION
Yes
Yes
Yes
SCALABLE/ROBUST
Yes
Yes
No
COST EFFECTIVE
Yes
No
No
www.dbvisit.com
Optimistic commit.
Does not wait for
commit before
applying
18
Dbvisit Replicate Architecture
• Mine
+
+
Converts Oracle redo log data into PLOG data
One or many Mine processes per each Replicate process
• Apply
+
+
Converts PLOG data into target DB native SQL
One or many Apply processes per each Replicate process
• Fetcher (optional)
+
+
Offloads Mine process from primary onto intermediary server
One or many Fetcher processes per each Replicate process
• PLOG
+
+
Parsed logs – binary files specific to Dbvisit Replicate
Platform independent
www.dbvisit.com
19
SQL
Dbvisit Replicate Flow: 2-Tier
PLOG
www.dbvisit.com
20
SQL
Dbvisit Replicate Flow: 3-Tier
(Fetcher process added)
FETCHER
PROCESS
PLOG
www.dbvisit.com
21
Dbvisit Replicate Value Proposition
• Significantly lower Oracle technology costs
+
No need for additional Oracle technology licenses and ongoing support bills
• Shortened project timelines
+
Installation and configuration wizards make this possible
• Avoid more expensive alternatives
+
Lower overall TCO due to faster installations, setups, and changes
• Responsive software company
+
We listen to our customers and enhance the software to fit best practices
• Continuity of business operations
+
Data is current, accurate
• Less stress on IT
+
+
More time for proactive measures
Less time needed for rework and bandaiding
www.dbvisit.com
22
Suggested Evaluation Steps
• Plan in-house test for Dbvisit Replicate
+
+
Schedule resources
Involve Dbvisit and Partners from start to finish
• Download software
+
+
+
Full use version of software
Includes all documentation
Includes full customer and technical support
• Complete test
• Summarize findings collaboratively with Dbvisit
development staff and Dbvisit Partner
• Purchase software and support
• Run
www.dbvisit.com
23
www.dbvisit.com
www.dbvisit.com
24