Oracle数据库平台架构介绍
Oracle架构介绍
典型案例介绍 URS相关数据库架构探讨
Copyright © 1997-2014 NetEase. All Rights Reserved.
基本架构
Copyright © 1997-2014 NetEase. All Rights Reserved.
Oracle Data Guard 常用于站点故障
Copyright © 1997-2014 NetEase. All Rights Reserved.
Oracle Data Guard Oracle Active Data Guard
Copyright © 1997-2014 NetEase. All Rights Reserved.
VPLEX WITNES S
生产中心二
LAN
WebLogic 应用服务 器 WebLogic 应用服务 器 Oracle RAC 数据库
LAN
WebLogic 应用服务 器 WebLogic 应用服务 器
Oracle RAC 数据库
Oracle RAC 数据库
Oracle RAC 数据库
VPLEX存储双活 虚拟化设备 VPLEX存储双 活 虚拟化设备 2*RecoverPoint 连续数据保护装 置 2*DS6510 核心SAN交换 机 双活链路交换 机 2*DS6510 2*DS6510 核心SAN交换 机
Oracle Data Guard Oracle Active Data Guard
Copyright © 1997-2014 NetEase. All Rights Reserved.
Oracle GoldenGate 基本原理
Copyright © 1997-2014 NetEase. All Rights Reserved.
Oracle Automatic Storage Management
Copyright © 1997-2014 NetEase. All Rights Reserved.
Oracle Automatic Storage Management
Copyright © 1997-2014 NetEase. All Rights Reserved.
Oracle Recovery Manager
Copyright © 1997-2014 NetEase. All Rights Reserved.
Oracle Automatic Storage Management
Copyright © 1997-2014 NetEase. All Rights Reserved.
Oracle架构介绍
典型案例介绍 URS相关数据库架构探讨
Copyright © 1997-2014 NetEase. All Rights Reserved.
Oracle Real Application Clusters
XX社保双活数据中心架构
生产中心一 2层网络扩 展 网络互 联 VPLEX 双活仲裁机
用于解决的问题： --站点故障 --服务器故障 --存储故障 --数据坏块 --人为误操作
Copyright © 1997-2014 NetEase. All Rights Reserved.
Oracle 最高可用架构
Copyright © 1997-2014 NetEase. All Rights Reserved.
Redo Apply Rates in MB/sec
700 600 500 400 300 200 100 0 30 80 200 OLTP Batch 615
network latency
Trad. Exadata V2 Hardware
Oracle Data Guard ADG模式下的性能提升
Oracle Real Application Clusters常用于解决服务器单点故障
Copyright © 1997-2014 NetEase. All Rights Reserved.
Oracle Real Application Clusters
Copyright © 1997-2014 NetEase. All Rights Reserved.
3000
2,610
2500
Transactions / sec
2000
1,530
1500
1000
630
500
+ 117% Read-write service + 70%
290
Read-only service
0
All services run on primary database
Read-only offloaded to standby
Oracle Data Guard DG 保护模式
Read-write transactions
Maximum Availability Maximum Performance Maximum Protection SYNC/ASYNC
Read-only transactions
Active Data Guard
Oracle GoldenGate 适用场景 高可用节点保护、升级迁移、报表系统、ETL挖掘、BI
Copyright © 1997-2014 NetEase. All Rights Reserved.
Oracle Recovery Manager
Copyright © 1997-2014 NetEase. All Rights Reserved.
基本架构
Copyright © 1997-2014 NetEase. All Rights Reserved.
Oracle 最高可用架构
产品： --Oracle Data Guard --Oracle GoldenGate and Oracle Streams --Oracle Real Application Clusters --Recovery Manager Oracle Secure Backup --Oracle Automatic Storage Management --LogMiner --Flashback