DB2 pureScale use cases Dec 14 2012.pptVIP

DB2 pureScale 技术回顾和应用实例 薛洵, DB2 数据库专家 xun@ Dec 14, 2012 提纲 DB2 pureScale 技术回顾 DB2 pureScale 应用案例 2 提纲 DB2 pureScale 技术回顾 DB2 pureScale 应用案例 3 DB2 pureScale 的目标 无限扩展 随着需求的增长而增长 应用透明 不需要显著的程序修改 不需要复杂的管理工作 24*7的连续可用性 无论是针对计划内还是计划外 在分布式平台最接近 z/OS “黄金标准”的解决方案 基于 Z Sysplex 模型，使用 COTS 组件和竞争对手的区别在于超强的高可用性和可扩展性 DB2 DB2 DB2 Single Database View Cluster Interconnect Transactions CF 4 DB2 pureScale 的整体架构 Single Database View Clients Primary 2nd-ary 运行于 Power和Linux 服务器上的 DB2 成员集群 共享数据架构 Cluster caching facility (CF) 支持RDMA的高带宽低延迟网络 自动工作负载均衡 整合的 DB2 Cluster Services 借鉴 IBM’s System z Sysplex 设计方案 pureScale的关键通讯技术,有效解决扩展性难题 Deep RDMA exploitation over low latency fabric Enables round-trip response time ~10-15 microseconds  Silent Invalidation Informs members of page updates requires no CPU cycles on those members No interrupt or other message processing required Increasingly important as cluster grows Hot pages available without disk I/O from GBP memory RDMA and dedicated threads enable read page operations in ~10s of microseconds GBP GLM SCA Buffer Mgr Lock Mgr Lock Mgr Lock Mgr Lock Mgr New page image Members CFp AppMemory Receiver immediately receives msg Sending process or thread RDMA write recvmsg Adapter DMAs Into kernel buffer Receiver receives msg pureScale RDMA 模式 其他集群数据库所用的套接字模式 AppMemory Sending process or thread AppMem sendmsg RDMA adapter DMAs directly into app memory RDMA adapter DMAs directly from app memory Adapter DMAs from kernel buffer Krnl Mem Krnl Mem AppMem OS kernel interrupt handler copies data to app memory and makes receiving thread ‘ready’ OS kernel dispatcher will eventually dispatch target thread 数据库集群的通讯模式 spin Adapter raises interrupt 1 2 3 5 6 4 1 2 Receiver waits for msg OS IntHandler OSDispatcher 扩展性 : 客户数据 Relative Transactions per Second 20Gb/s IB HCAs 7874-024 IB Switch Heavy OLTP 50/50 R/W 0-100% affinity 4 2-core p7 members 8 GB, 5 GHz each DS5300 storagecontroller OLTP 负载 50/50 读写比; 大量修改交易 # Me