资源描述:
《causes-of-downtime-in-mysql》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、CausesofDowntimeinProductionMySQLServersAPerconaWhitePaperBaronSchwartzAbstractEveryonewantstopreventdatabasedowntimebybeingproactive,butaremeasuressuchasinspectinglogsandanalyzingSQLreallyproactive?Althoughtheseareworthwhile,theyalmostalwaysidentifyproblemsthatalreadyexis
2、t.Tobetrulyproactive,onemustpreventproblems,whichrequiresstudyingandunderstandingthereasonsfordowntime.Thispaperpresentstheresultsofastudyofemer-ThesampledataisbiasedandmightnotrepresentgencydowntimeissuesthatPerconawasaskedtotheoverallpopulationofMySQLusers.Theremightreso
3、lve.Itshedslightonwhattypesofproblemsbeahighnumberofwebsiteemergenciescomparedcanoccurinproductionenvironments.Theresultstothegeneralpopulation.Webapplicationdevelop-mightbesurprising.Conventionalwisdomholdsersandstartupcompaniesoftenworkinalessdis-thatbadSQListheleadingca
4、useofdowntime,butciplinedfashionthan,forexample,banksorphar-theoutcomeofthisresearchwasquitedifferent.maceuticalresearchcompanies.(Percona’scustomerlistdoesincludethoseindustries,andthesamplein-Inthispaper,downtimeisdefinedastimethatthecludesemergencydowntimeissuesfromthose
5、typesdatabaseserverisnotprovidingcorrectresponsesofcustomers.)Therefore,thisstudymightover-withacceptableperformance.Downtimecouldberepresentmistakesmadebypeoplebuildingap-becauseaserverhasjustbeenrebootedandisrun-plicationsinahecticstartupenvironmentwithoutningoncoldcache
6、swithincreasedresponsetimes,properresourcesorplanning.Furthermore,manyordatahasbeendestroyedsotheserverisreturningemergenciesareresolvedwithoutcallingPercona;wronganswers,orreplicationisdelayed,oranyofweareoftencalledonlyforperplexingproblems.anumberofothercircumstancesbes
7、idescompleteForexample,althoughthedatashowsthatSANfail-unavailability.uresareasignificantcauseofstorageproblems,thatThispaperexplainshowwecategorizedtheinci-couldbebecauseSANfailuresaredifficulttodiag-dents,presentstake-awaysaboutdowntimeanditsnose.causes,andconcludeswithsom
8、erecommendationsWefoundthatdowntimeincidentscanbegroupedthatseemlikelytohelppreventdownti