Redintelxeon

MariaDBServerbenefitsfroma78percentincreaseinthroughputandan18percentcutinresponsetimewhenrunningontheIntelXeonPlatinum8180processor1IntelXeonPlatinumProcessorAcceleratesMariaDBServer*andMyRocks*SolutionBriefIntelXeonPlatinum8180processorServerPerformance"MyRocks*isastorageenginethataddstheRocksDBflash-storage-optimizeddatabasetoMariaDBServer.
Evenwhileunderdevelopment,itshowsgoodperformanceandscalability,closetomaturestorageengineslikeInnoDB.
Weranourpre-releaseMariaDBServer10.
2.
9withthebuilt-inMyRocksengineundertheSysbenchread-onlymulti-tabletestonthenewestIntelXeonPlatinum8180processors.
Theydeliveredupto1.
78xmorethroughputwith1.
18xreductionoftheaverageresponsetimecomparedtothepreviousgenerationIntelXeonprocessorsE5-2699v4"—MichaelWideniusCTO,MariaDBCorporationMariaDBServerisoneofthemostpopulardatabaseserversintheworld.
It'smadebytheoriginalfoundersofMySQLandnotableusersincludeWikipedia,WordPress.
comandGoogle.
Asbusinessesbecomemoreandmoredataintensive,thecostpertransactionbecomesanimportantmetric.
Therearetwowaystolowercostpertransaction.
Thefirstistolowerthecostofdatainfrastructure;andthesecondistoincreasehardwareefficiency.
WithMariaDBandIntel,organizationscandobothbyusinganenterprisesubscriptiontoreducedatabasecostsandmulti-coreprocessorstoincreaseperformancewithexistingservers.
IntroducingMariaDBServerMariaDBServerisanopensourcedatabase,andthefoundationofMariaDBTX,anenterpriseopensourcesolutionfortransactionalworkloads.
MariaDBServerisengineeredforflexibility,efficiency,andreliability.
Byimplementinganextensiblearchitectureandsupportingcontributionsfromleadinginternetandtechnologycompanies,includingAlibaba,Facebook,GoogleandTencent,MariaDBServermeetsmodernenterpriserequirementswithcommunityinnovation.
MariaDBServer,engineeredtoscaleonstandardmodernhardware,canbedeployedonbaremetalservers,virtualmachines,cloudinstances,and/orcontainers.
MariaDBServerisnowthedefaultdatabaseonleadingLinuxdistributions,includingRedHatEnterpriseLinux*andSUSEEnterpriseLinux*,aswellasleadinginfrastructureplatforms,includingOpenStack.
Inaddition,MariaDBServerusesIntelAdvancedEncryptionStandardNewInstructions(IntelAES-NI)toimproveencryptionperformance,bothinmotionandatrest.
ThemodernandextensiblearchitectureofMariaDBServerprovidesthefoundationforbusinessestocontinuouslyinnovatewithnewapplicationsandmodernizelegacysystems.
OneofthestrengthsofMariaDBServeristhatitallowsuserstochoosetheirownstorageengine.
InnoDBisthedefault.
Itwasdesignedprimarilytoworkwithharddisks,butnewstoragemediahavesinceemergedincludingnon-volatilememory(NVM)andsolidstatedrives(SSDs).
MyRocks*,developedbyFacebook,isastorageenginethatisoptimizedfornewermedia,andaimstooffergreatercompressionandfasterperformance.
Whilecurrentlyavailableasapreview,MyRockswillbefullysupportedinthenextmajorreleaseofMariaDBServer.
SolutionBrief|IntelXeonPlatinumProcessorAcceleratesMariaDBServer*andMyRocks*2LearnmoreMariaDB:mariadb.
comIntelXeonPlatinumprocessors:https://www.
intel.
com/content/www/us/en/products/processors/xeon/scalable/platinum-processors.
htmlTestingthenewprocessorInadvanceoftheofficialsupportforMyRocks,MariaDBandIntelworkedtogethertoassessthepossibleperformancegainsusingthelatestgenerationIntelprocessor.
IntelengineerscomparedtheperformanceofMariaDBServer10.
2.
9runningontwoIntelXeonprocessorsE5-2699v4againstMariaDBServer10.
2.
9runningontwoIntelXeonPlatinum8180processors.
Inbothcases,MyRockswaschosenasthestorageengine.
TheteamusedtheSysbenchOLTPbenchmark,1amulti-threadedbenchmarktoolforevaluatingdatabaseperformanceunderintensiveload.
Toconfirmtherewerenobottlenecksintheperformance,IntelVTuneAmplifier2017andamodifiedversionoftheopensourceProcessorCounterMonitorwereused.
Theresultsshoweda78percentincreaseinread-onlythroughputwiththeIntelXeonPlatinumprocessorswhencomparedtothepreviousgenerationv4processors.
1Inaddition,averageresponsetimesatpeakthroughputwerecutby18percent.
1OptimizingthesoftwareAcollaborationwithIntel,usingIntelVTuneAmplifier2017,partoftheIntelParallelStudioXE2017suite,ledMariaDBtoidentifyperformanceoptimizationsforIntelprocessors.
TheresultisMariaDBServertakingadvantageoftheadditionalcoresinIntelXeonPlatinumprocessors,scalingtotwosocketsand112hardwarethreadsinthisperformancecomparison.
1Findthesolutionthatisrightforyourorganization.
ContactyourIntelrepresentativeorvisitwww.
intel.
com.
SolutionBrief|IntelXeonPlatinumProcessorAcceleratesMariaDBServer*andMyRocks*3SolutionProvidedBy:Allinformationprovidedhereissubjecttochangewithoutnotice.
ContactyourIntelrepresentativetoobtainthelatestIntelproductspecificationsandroadmaps.
Inteltechnologies'featuresandbenefitsdependonsystemconfigurationandmayrequireenabledhardware,software,orserviceactivation.
Performancevariesdependingonsystemconfiguration.
Nocomputersystemcanbeabsolutelysecure.
Checkwithyoursystemmanufacturerorretailer,orlearnmoreathttps://www.
intel.
com/content/www/us/en/products/processors/xeon.
html.
SoftwareandworkloadsusedinperformancetestsmayhavebeenoptimizedforperformanceonlyonIntelmicroprocessors.
Performancetests,suchasSYSmarkandMobileMark,aremeasuredusingspecificcomputersystems,components,software,operationsandfunctions.
Anychangetoanyofthosefactorsmaycausetheresultstovary.
Youshouldconsultotherinformationandperformanceteststoassistyouinfullyevaluatingyourcontemplatedpurchases,includingtheperformanceofthatproductwhencombinedwithotherproducts.
Formoreinformationgotowww.
intel.
com/performanceInteldoesnotcontrolorauditthedesignorimplementationofthirdpartybenchmarkdataorWebsitesreferencedinthisdocument.
IntelencouragesallofitscustomerstovisitthereferencedWebsitesorotherswheresimilarperformancebenchmarkdataarereportedandconfirmwhetherthereferencedbenchmarkdataareaccurateandreflectperformanceofsystemsavailableforpurchase.
Inteltechnologies'featuresandbenefitsdependonsystemconfigurationandmayrequireenabledhardware,softwareorserviceactivation.
Performancevariesdependingonsystemconfiguration.
Checkwithyoursystemmanufacturerorretailerorlearnmoreathttp://www.
intel.
comTestingbyIntel,September2017.
Softwareconfiguration:MariaDB*:SysbenchOLTPworkload.
OS:Ubuntu*Server17.
04x64.
Sysbench0.
4.
12,MariaDB10.
2.
9GITsnapshot2017-09-12.
TheworkloadisnotI/Oboundandisnotmemorysizebound.
Baseline:2SIntelXeonE5-2699v4,2.
2GHz,22cores,IntelTurboBoostTechnologyandIntelHyper-ThreadingTechnologyenabled,BIOS63.
R00,64GBtotalmemory,1600MT/s/DDR4LRDIMM,1TBSATAHDD,IntelSSDDCP3700Series2TB.
New:2SIntelXeonPlatinumprocessor8180,2.
5GHz,28cores,IntelTurboBoostTechnologyandIntelHyper-ThreadingTechnologyenabled,BIOS1.
00.
0412,192GBtotalmemory,12slots/16GB/2666MT/s/DDR4LRDIMM,1TBSATAHDD,IntelSSDDCP3700Series2TB.
PerformanceresultsarebasedontestingasofSeptember2017andmaynotreflectallpubliclyavailablesecurityupdates.
Seeconfigurationdisclosurefordetails.
Noproductcanbeabsolutelysecure.
IntelAES-NIrequiresacomputersystemwithanAES-NI-enabledprocessor,aswellasnon-Intelsoftwaretoexecutetheinstructionsinthecorrectsequence.
AES-NIisavailableonIntelprocessors.
Foravailability,consultyourresellerorsystemmanufacturer.
Formoreinformation,seehttp://software.
intel.
com/en-us/articles/intel-advanced-encryption-standard-instructions-aes-ni/.