您好,欢迎访问三七文档
当前位置:首页 > IT计算机/网络 > 数据库 > 企业级数据库云平台的建设与运维方案
,,、、,。,,、,。;;;PaaS,,(510623)1,、,、、、、、、、,,。·,。·。,,。·。,、SI,,,。·,。,,,“139”CPU60%,24h90%,,,。,5%,,。,,,、,。1。,50%,,“”,“”,。146201222322.1NIST:,(、、、),,。(gridcomputing)、(distributedcomputing)、(parallelcomputing)、(utilitycomputing)、(networkstoragetechnology)、(virtualization)、(loadbalance)。2.2IT。IaaS(infrastructureasaservice)、PaaS(platformasaservice)、SaaS(softwareasaservice),2。IaaS()、、,,(、),IaaS,。,,,,PaaS。IOUG3。PaaS(、),PaaS,:IaaS,PaaS;、、、。、,。()x8613IOUG147IaaS,Oracle,,40%,OracleRACVMWare,,、。PaaS,,,PaaS、,,。、、、,、、,。33.1PaaS,、、、,、PaaS,PaaS4。·、、;·、、;·、;·、。,。,、,,、CRM、;OLTP,CRM、,OLAP,、,OLTPOLAP,、、,,。。·,“”“”。·,“”OLTP,“”OLAP。·,。·,。·,。·、。·、、。PaaS,,,。3.1.1,,、,、CPU、。,x86,,x86、,,x86,,。,,,“”,,“”。,CPU、。3.1.2,,、,,;,,;,CPU,,。,,,,,,。3.1.3,,,1482012245,Infiniteband,4。,、。3.2PaaS,PaaS,OracleExadata。3.2.1Exadata,,Exadata。DB,Service,Service,、。Service“”“”。·RAC;·。,(instancecaging)CPU,,5。Exadata,,、、、License。3,3SalesApp、ERPAppHRApp,6。3(serverpool)(freepool),3Exadata。,,。ERP,,。HR,,。Exadata。Exadata,,,,(),,。3.2.2ExadataASM(),、、。OracleASM,,、。ASM,,,,,,149637。Exadata,DB。(SmartScan),、,,DB,7。3.2.3OracleExadataStorageInfiniband。Exadata4(QDR)Infiniband。Infiniband40GB,。Oracle(DMA),,,CPU。InfinibandLANSAN,InfiniBand,Oracle,Oracle。3.2.4、OracleExadataOracle(EM),Exadata。EMExadata,ExadataStorageServer,。EMExadata。·OracleExadata;·;·;·。OracleExadata。EMExadataOracle150201228SI。DBAEMExadataExadata。4PaaS4.1PaaS,,。,、,,。,10,30()。IT,IT。,,,。,/。,,SI,/,,。PaaS,SI。SI,,。,,SI,,SI/。,,SI4,8。SI,、。,。,,。,。,,,,,SI,,。,,,。,。4.2PaaS,,,、、,、SLA,。,9。1519104.2.1Exadata,OLTP、OLAP、,10,。4.2.2,,11。,。Exadata,,。4.2.3,,,12。,。55.1,,Exadata(OLTP+OLAP),446750。OLAP,,。+OLTP44127,1。5.2Exadata,SQL5(CPUSQL,SQL34KB)1/4(0:01:08)1/2(0:00:31),(68s31s),13。5.3,Exadata,Exadata710,2。5.4Service1、Service2,、。ora.gmsp,dm01db01、dm01db02。Srvctladdsrvpoolgora.gmspl0-u-1i0ndm01db01,dm01db02Oracle。152201221ExadataSQL150h0:01:471682SQL2193min0:01:31127SQL329min0:00:02870SQL417min0:00:011020SQL5,323min,0:01:08(285)SQL18min(),47min(6)00:00:1144SQL26750s0:00:016750SQL312h0:00:123600SQL1-23min,693,2000min0:01:164011121532()(MB)(/)(s)TFA_ALARM_CLR()57781593672560:00:53TFA_ALARM_CLR()57781593972270:01:26FACT_NCELLREL_IN()2813220430760:00:06FACT_NCELLREL_IN()28132204297100:00:08dbfsdg_mount。·Oracledm01-cluster。·:dbfsdg_mount。·:local_resource。·:。5.5,。CPU、、I/O。Oracle,,CPU,CPUCPU,。5.5.1CPUOLTP_GROUP、OLAP_GROUPOTHER_GROUP3,,CPU。·OLAP_GROUP:60%。·OLTP_GROUP:20%。·OTHER_GROUP:20%。,CPU,。5.5.2OLTP_GROUP、OLAP_GROUPOTHER_GROUP3,。·OLAP_GROUP:300。·OLTP_GROUP:50。·OTHER_GROUP:100。,。5.5.3I/OOLTP_GROUP、OLAP_GROUPOTHER_GROUP3,I/OI/O,I/O。·OLAP_GROUP:I/O10000MB,I/O100000。131542012214ConstructionandOperationProgramofEnterprise-ClassDatabaseCloudPlatformLiangYong,ZhangPanxiang,ChenQiuhua(ChinaMobileGroupGuangdongCo.,Ltd.,Guangzhou510623,China)AbstractInrecentyears,cloudcomputingisgainingmoreandmoreconcernespeciallyintelecommunicationcompany.Whentelecomcompanysearchesforalow-cost,centralized,thewholenetworkofoperationmethod,cloudcomputingisthemostappreciatedsolution.Inthispaper,wedescribecloudcomputingrelatedrequirementsoftelecommunicationsbusiness,especiallyindatabasecloudarea,thearchitectureofdatabasecloud,andthebestpracticetorealizethosedatabasecloudplatformandarchitecture.Wealsoanalysisthechangeofoperationandmaintenancethedatabasecloudbringtous.Keywordscloudcomputing,telecomcompany,clouddatabase,PaaS(:2012-02-03)·OLTP_GROUP:I/O100MB,I/O。·OTHER_GROUP:I/O1000MB,I/O。5.6,、、、,。Oracle,Exadata,CPU、、I/O,14。6,、。,、;、;;,、、,。、,,。155
本文标题:企业级数据库云平台的建设与运维方案
链接地址:https://www.777doc.com/doc-4285863 .html