熊军 - 百倍加速 - 电信和移动客户基于分布式存储的最佳实践

所需积分/C币:9 2015-11-26 16:06:59 14.8MB PDF

2015 Oracle 技术嘉年华(OTN)分会场1熊军 - 百倍加速 - 电信和移动客户基于分布式存储的最佳实践
目录 分布式存储一 How Fast? 分布式存储一— Why Fast? 什么是分布式存储 最佳实践一一案例分享 Oracle技术嘉年华 Oracle Technology Carnival 2015 How Fast--Throughput Run status groupo (all jobs) READ: io=718598MB, aggrb=11975MB/s, min=11975MBs, maxb=11975MB/s, mint=60009 msec, maxt=60009msec Run status groupo all jobs READ: io=741407MB, agar=12355MB/s, minb=12355MB/s maxb=12355MB/ s, mint=60010msec, maxt=60010msec 单个数据库节点12GB/s Oracle技术嘉年华 Oracle Technology Carnival 2015 How Fast--IOPS read: io=541129MB, bw=90187MB/s, iops=1154.4K, runt= 60001msec slat (usec): min=2, max=1443. 9K, avg=1827, stdev=334. 60 clat usec): min=0, max=1444.9K, avg=322. 69, stdev=1124.99 lat (usec): min=46, max=1444.9K, avg=341. 19, stdev=1174.25 read: io=441140MB, bw=7352 1MB/s, iops=941068, runt=60002msec slat(usec): min=2, max=521414, avg=22. 55, stdev=279. 10 clat usec): min=0, max=522272, avg=395.87, stdev=949. 56 lat(usec: min=44, max=522301, avg=418.69, stdev=991.48 单节点IOPS100万,IO延迟03-0.4ms Oracle技术嘉年华 Oracle Technology Carnival 2015 How Fast-Query Table SQL> select bytes/1024/1024/ 1024 gb from dba segments where segment name=XJTEST1 GB 127.389771 SQL> select * parallel(a 32)*/count(*)from xjtest 1 a COUNT( 25020643 E| apsed:00:00:12.90 查询时IO吞吐量:10GB/s Oracle技术嘉年华 Oracle Technology Carnival 2015 How Fast- -Create Table SQL> create table XJTEST2 nologging paralle 32 tablespace TT FLASH03 2 as 3 select /*+ parallel(a 32 )*/* from XJTEST1 a a ble created E| apsed:00:01:0633 IO吞吐量:5.7GB/s(1份读+2份写) Oracle技术嘉年华 Oracle Technology Carnival 2015 How Fast SAs Disk SQL> create table XJTEST3 nologging parallel tablespace TBAS WTDaTA as select /* parallel(a 60)*/* from XJTEST1 a a ble created E| apsed:00:01:1543IO吞吐量:5GB/s(1份读+2份写),4存储节点 SQL> select parallel(a 64)/count() from xjtest 3 a COUNT( 25020643 E| apsed:00:00:21.72IO读吞吐量:5.8GB/s,4存储节点 Oracle技术嘉年华 Oracle Technology Carnival 2015 Why Fast-基础设施 存储设备 SAS磁盘 SSD PCIe Flash IOPS 100~150 50,000+ 200,000+ Throughput 150MB/s 500MB/s 4.OGB/s Latency 10ms 100us 30us e 互联设备 Ethernet SAN Infiniband Bandwidth 1~100Gb/s2~16Gb/s40~100Gb/s Latency ouR 2us 200ns Oracle技术嘉年华 Oracle Technology Carnival 2015 Why Fast-分布式存储 计算节点 RAC节点1 RAC节点2 56Gb 1B交换机 闪存卡 闪存卡 闪存卡1 存储节 X86PC X86 PC Servel 86 PC Server i Server 1 2 3 Oracle技术嘉年华 Oracle Technology Carnival 2015

...展开详情
img
-空白式

关注 私信 TA的资源

上传资源赚积分,得勋章
相关内容推荐
  • 下载 -

    -