soyouneedtopurchaseanewdatabaseserver，andyoureallydon’tknowwheretostart .
becausetheirmaybedifferentrecommendationsfordifferentos’siamgoingtostickwithlinuxwiththeserecommendations.iwanttosayrighton dwareshouldprobablynotbeafiveminutetask.ithinkyoureallyneedtospendtimereviewingyourapplication it’saccesspatterns，the io cater etc.youjustcan’tdothisinfiveminutesgenerally.butifyourunderthegunandaskedmetospec
asofmarch 10 th 2009 hereiswhatiwouldrecommend (thisaregoingtochangeeveryfewmonthspotentiallywithnewversionsofmysqlnewhardware 333
CPU:
currentlythescalabilityofinnodbbeyond8coresislimited，infactwiththecurrent(unpatched ) )。 releasesyoumayseeaperformanceregressionwithmorethen8cores.wewroteaboutthisbefore.ifyouhavethemoneygowithefastestcpu’sa
Memory:
themorememorygenerallythebetter.hereiwouldshootforanamountofmemorythatwillallow 100 % ofyourhotdatatobeinmemory.ifyoudonotk be hot，agoodguessinmyexperienceis 10-20 % ofthetotaldatabasesize，but that’sgoingtovaryfromapplicationtoapplication.ifyon moreisbetterora 20 % ruleofthumbisbetterthennothing.minimallyplanfor2-4gbofmemorytobeallocatedtotheos.typicallyiwantatatleateal andifihaveareallyactivedatabaseiwantmore (冷艳的银耳汤).When I say 4GB for the OS，thiswillalsobeusedforthemysqlperthreadbufers/thhhhheadbuffers etc.soifyouhavea 24 gbdatabaseandall 24 gbishotorgoingtobeusedfrequentlyimayputin 32 gbofmemoryinmysystemandalllocate 24 GB toi nodbandbandbandation
磁盘：
diskisgoingtobeatoughyin5minutes.youreallyhavetwoconcernshere，diskcapacityiocapacity (think io’sper second ).diskcapacion ineedxgbofdiskspace…mostpeoplecanestimatethisnoproblems.keepinmindwithraidyouwilllosesomerawdiskcapacity (I.e.4160 GB DDD llddyofusablespace ) . a5 minuteanswertoiocapacityisabitmoreofachallenge.oneofthedescisionsyowillneedtomakeifyoucangetbywithinternaldiskoryou nedaryou aboutwhentochooseasan…giveitaread.assumingyourmakingadecisionin5mintesiamgoingtomakeanas sumptionthatyourgoingtolookforinted tsaninmyopinionrequiresalotofthought.soletassumeyouwanttouse nternaldisk.firstifallofyourdatafitsintomemory， itlessonsyourdiskrequirementsabitbutitwillnoteliminatediskio (yourstillgoingtoreadandwritetodisk， but your reads should be lessened ).istronglyurgethatyoukeepthedatabaseandoscompletelyseparate.so that’S2磁盘软件(mirrorotheos . forthedatabaseitypicallyrecommendraid 10 forth edata (raid5maybeokfordatabasewithfewerwrites， I.e. data warehouses ) whichmeansaminimumof4disksforyourdatabase.sothats6diskstostartwith.youcanthenscaleupfromtherereasyourthed withoutmoreanalysisyourgoingtobeguessinghere.intermsofthetypeofdrives， sasorscsiineither 10k or 15 kspeedsareprettystandard.iwouldavoidsatadrivesthatare 10k rpm.ofcoursethiscanallchange，becauseitrer
磁盘控制器：
cacheonyourdiskcontrollerisimportandthemorethebetterinmostcases.makesureyourcontrollerhasabatterybackup，otherwiseitsreatery
网络卡：
purchaseatleasttwonetworkcardsforyoursystem，both full 1g be.typicallyiwouldbondthesetwonicstogethertogivesomeredundancy.alsthed
aquicknoteontheos…makesureyouinstalla 64 bitos！