Fusion_Intro_Hana_Case_Study (v 2)

ioDriveCaseStudyDistributedbyNovember2008DistributedbyAuthorizedReseller•B2CApplicationoe-tailoInternetMessagingSecurity•FinancialApplication•HeavycomputationApplicationDistributedby•OraclefindingDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeWine.comÆThanksGiving~X-mas:$2Msalesper30minÆFAS3040$120K/eaDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeWine.comioDrivevs.NetAppFAS270PerformanceComparisonioDrivebasedconfiguration(RAID1)ioDrivebasedconfiguration(RAID1)Server:4x160GBioDriveonHPDL380G5($12K/ea+ioDrive)Mirror:6x160GBioDriveonHPDL380G5TwoNetAppmodelFAS270(2TB)with14x144GBFibreChannelharddrivesTwoNetAppmodelFAS270(2TB)with14x144GBFibreChannelharddrivesAlternative:2xFAS3040($120K/ea)Writespeed:12xWritespeed:12xReadspeed:14xReadspeed:14xWritelatency:4msWritelatency:4msÆÆ1ms1msReadlatencyReadlatency:12ms:12msÆÆ1ms1msInvestment:25%Investment:25%DistributedbyEnergyconsumption:20%Energyconsumption:20%DistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeCloudmarkDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeCloudmark•BasicApplicationSolutionSystemisdataaccessverificationbasedon–SystemisdataaccessverificationbasedonMySQL,INODB,Customprocess&script–SolutionisbasedonhightransactionDBmasterandslaves–PrevioussolutionwasusingSASbasedDASstoragefromHP•Problems•Problems–Rapidlyexpandingcustomerbase–1,000transactionspersecondfortheentiresystem–Maintenanceissue–Notscalabletodeliverhighperformance–Maintainsystemreliability(99999carrierclass)DistributedbyMaintainsystemreliability(99.999carrierclass)–Keepit“Green”systemDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeCloudmarkFusionIOBaseDesignDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeCloudmarkDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeCloudmarkDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeCloudmarkDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeUSDataworks•Majorcustomerincludes;Distributedby•Majorcustomerincludes;DistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeUSDataworksDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeUSDataworksDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeHeavyComputingcaseDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeSeismicMicroTechnology•SeismicdataprocessingusingaSeismicMicro-Technology,IncS/Wgy•DellWorkstationPrecision690–MSServerx64–2xIntelXeon5160@3GHz–8GBRAM•PerformanceImprovementsDistributedby•Simplefilecopy:3.8xfaster•3DSeismicsurveytimeline:1.6xfasterCrosslineDisplay:10xfasterDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistribute•CrosslineDisplay:10xfasterDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeWherearethehightransactions?•Index•Redo,TransactionlogsRedo,Transactionlogs•Temptablespace•DataRollbackDataRollback•ReferencedtablesioDrive:SuggestedPartitionsSwaptemplogsDBDistributedbytmptablespaeredologsTransactionslogsindexReferencedtablesSwaptemplogsDBDistributedbyAuthorizedResellergDatarollbackDatafilesOracleStandaloneProductionDatabasePhysicalStandbyRAID10RAID0Distributedby4ioDrives320GBeachTotalusable:640GB2ioDrives320GBeachTotalusable:640GBDistributedbyAuthorizedResellerOracleDATAGUARDDisasterRecoverDisasterRecoverHighAvailabilityHighAvailabilityPhysicalStandbyProductionDatabaseProductionDatabaseRAID0OrRedoApply–racleNeRedoApplyIdenticalDBschemaSYNCvalidationRdonlyqueriesandreportsLogicalStandbyetDistributedbyRAID10DistributedbyAuthorizedResellerRAID0SQLApply(Rd/Wr)–QueriesReportingOracleRACioDrives10GigEioDrives6cards300,000IOPS4.2GB/seciSCSItargetsEtargetsDistributedbyDistributedbyAuthorizedReseller7/7/2009Confidential—DoNotDistributeioDrivesRealDemonstratedResults(atInterop2008,LasVegas)DistributedbyDistributedbyAuthorizedReseller2609/12/08Confidential—DoNotDistributeOracle’sInternalResultsPublishedOracleWorld2008Setup•“Disks”80GBFusion-ioPCIecard•Workload:10,000actualqueriesissuedtooracle.comhkhd2lld(0G)•Benchmarkcorpushad2milliondocuments(40GB)•Textindexsizewas7.7GBResultsEldtifhlidbt35•Elapsedtimeforwholerunimprovedbyupto35x•I/Owaittimesimprovedbyupto56xI/Ospersecond(IOPS)improvedby37xDistributedby•I/Ospersecond(IOPS)improvedby37x•QueriesswitchedfrombeingcompletelyI/Oboundto50/50splitbetweenI/O&CPUDistributedbyAuthorizedReseller5050spltbetweeO&CU7/7/2009Confidential—DoNotDistributeOracle:MicrobenchmarkIndexScanResultsDistr