move your database to the cloud with almost zero downtime€¦ · move w/o history – start fresh...

www.rmoug.orgFebruary 20-22, 2018 | Westin Westminster Hotel | Westminster, CO

Move Your Database to the Cloud

with Almost Zero Downtime


Agenda

• Clear the clouds (pun intended)What’s “The Cloud”?

Why Should I Move to The Cloud?

How Do I Move to The Cloud?

• Wrap Up/Q & A


Attendee Survey


What’s “The Cloud”?


Confidential5

http://cioresearchcenter.com/2011/03/the-nist-definition-of-cloud-computing/


Confidential6

Broad Network Access - If you can’t get to it, you can’t use it

Rapid Elasticity- Scalability – Up AND Down

Resource Pooling- Share the load

On-Demand - I want it NOW, not next week

Self-Service- No IT bottleneck

Measured- Pay as You Go

Essential Cloud Characteristics


Confidential7

Private

✓ All mine!

Community

✓ Shared, but only among a

community (Intelligence)

Public

✓ Wide Open

Hybrid

✓ Some combination – usually at

least partially “on-premise”

Cloud Deployment Models

NONE of these define WHERE the hardware lives!


Confidential8

Software as a Service (SaaS)

– Applications

✓ SalesForce

Platform as a Service(PaaS)

– Databases

✓ RDS

✓ SQL Azure

Infrastructure as a Service (IaaS)

– EC2

– Azure

– S3 (storage only)

Cloud Service Models


Why Should I Move to

the Cloud?


Confidential10

Executives Told Us To…

✓ “Everyone” is Moving

Cost

✓ Infrastructure, People, Process

✓ Not always cheaper

Reliability

✓ Cloud is generally more reliable

✓ Look for single points of failure, like the network

Flexibility

✓ Time to Market

✓ Scale up/down

Security

✓ How Large is you internal security team?

Why Should I Move to the Cloud?


How Do I Move to

Cloud?


Confidential12

Conversions

– Don’t migrate, convert

– Convert OnPremise Application to SaaS

Move w/o History

– Start fresh with same software but no

historical data

Just Do It (Big Bang)

– Take the downtime and risk

– Use Backup and Restore

– Long downtimes for large databases

Options for Migration to The Cloud

The Alternative… Use a Replication Solution


Confidential13

• Redo Log Based Database Replication

✓ Read the redo log for changes

✓ Ship the changes from old to new in near-real time

✓ Biggest latency is the network

• Requires source and target have identical data to start

✓ Backup/copy consistent to an SCN

Remove the risk/downtime associated with migration

Maintain synchronization between databases

✓ On-Premise to Cloud

✓ Cloud to On-Premise

What Is SharePlex?


Confidential14

SharePlex Use Cases with Oracle Replication


Confidential15

SharePlex Architecture With Oracle Databases


SharePlex Cloud Support

Source Target Source Target Source Target Source Target

Oracle

SQLServer

PostgreSQL

(community

edition)

EnterpriseDB

Fujitsu

AWS RDS AWS EC2 Azure Marketplace Azure SQLService

Source Target Source Target Source Target Source Target

Oracle

SQLServer

PostgreSQL

(community

edition)

EnterpriseDB

Fujitsu

AWS RDS AWS EC2 Azure Marketplace Azure SQLService


SharePlex migration steps using a physical copy

Replication

Backup from Prod - RMAN, Export, Datapump, etc.

Restore to Cloud(Recover to SCN or LOG Number)

Capture queue

Exportqueue Post

queue

Reconcile

Current production

Cloud

Post


Questions


To learn more about SharePlex™

visit www.SharePlex.com

Download full eBook “Moving Your Databases to the Cloud” at: www.quest.com/cloudmigration

move your database to the cloud with almost zero downtime€¦ · move w/o history – start fresh...

Documents