高性能OLTP数据库方案介绍.pptx

Fusion-io高性能数据库方案介绍方案一 : 单实例Oracle复制X86 serverX86 serverAccording to HP whitepaper:(vs Exadata half rack):4x performance? acquisition cost? operational cost70% less space usage(基于ioDrive 第一代卡的数据ioDrive2性能及容量翻倍)Data GuardHost-based Fusion-ioHost-based Fusion-io 高性能多路服务器, 大容量内存, 提供计算能力 高性能Flash存储卡, 消除I/O瓶颈 本地做ASM, 采用Data Guard或GoldenGate作为HA方案Fusion-io Confidential方案二: Oracle RACX86 serverX86 serverRAC Interconnect性能:- 高性能多路服务器集群- 采用全Flash存储消除I/O瓶颈- RAC互联, 存储连接采用Infiniband, 提供高带宽低延迟互联高可用:- 企业级的Flash闪存方案, 确保数据可靠性.- 采用RAC做HA, 提供秒级切换- ION做为JBOD提供给Oracle ASM- ION之间可做HA, 提供mirror, failoverInfinibandION storage nodeFusion-io ConfidentialDL980 Specs – CPU and MemoryUp to 4TB MemoryFusion-io ConfidentialION 软件定义闪存存储方案ION存储软件, 提供高性能共享存储提供数据同步及HA, 确保数据安全Software稳定可靠的Flash存储数千家客户应用ioMemory可靠的开放平台帮您解除供应商绑定Open PlatformsFusion-io ConfidentialION规格参数举例 – DL370 SpecsFusion-io Confidential与Exadata对比Fusion-io ConfidentialPerformanceTCO - X3-2 CPU核数增加, 软件License - 功耗 - 机房空间 - 成熟度, 迁移/维护成本及风险Vendor Lock-in选择合适的OLTP解决方案Fusion-io Confidential数据可靠性, 方案可信度 - 数据可靠性机制保证 - 广泛的企业级客户大规模验证 - 产品及方案发展路线图业务可持续性, 可恢复性 - 业务可用性, RTO, RPO - 备份恢复速度 - 备份恢复复杂度最后才是性能全球最大云存储提供商 用户数据库Before Exadata (? rack) –Bundled servers –Bundled SSDs Output –9,000 TPSResult –Complex setup and administer –Insufficient performance –VERY EXPENSIVE AfterTwo HP DL 580 G7 servers 10 ioDrives per server ：1.28TB each, 12.8TB total Output –Over 39,000 TPS/server–2nd server for failover Result –Best-in-class performance –Best-in-class price T H A N K Y O UFusion-io ConfidentialioMemory数据访问架构简化的数据访问架构摒弃RAID控制器, SATA协议等智能化I/O子系统Host内存ioMemory Virtualization TablesCPU and coresVirtual Storage Layer (VSL)DATA TRANSFERSCommandsPCIeApplications/DatabasesioMemoryData-PathControllerioDriveFile SystemKernelVirtual Storage Layer (VSL)BanksioMemoryChannels WideFlash memory evolution: Native API Access|Native AccessLegacy SSDsioMemory asioDriveioMemory asTransparent CacheioMemory with direct access I/OioMemory with memory semantics Applic