99greatrecipesformasteringMySQLconfigurationandadministration
InDetail
MySQListhemostpopularopen-sourcedatabaseandisalsoknownforitseasysetupfeature.However,properconfigurationbeyondthedefaultsettingsstillisachallenge,alongwithsomeotherday-to-daymaintenancetaskssuchasbackingupandrestoring,performancetuning,andservermonitoring.Thesetaskshavenotbeencoveredthoroughlyinthedefaultdocumentation.
Thisbookprovidesbothstep-by-steprecipesandrelevantbackgroundinformationonthesetopicsandmore.ItcoverseverythingfrombasictoadvancedaspectsofMySQLadministrationandconfiguration.Oneofthethingsyouarereallygoingtoloveaboutthisbookisthatallrecipesarebasedonreal-worldexperienceandwerederivedfromprovensolutionsusedinanenterpriseenvironment.
ThisbookshowsyoueverythingyouneedtoknowaboutMySQLAdministration.YouwilllearntosetupMySQLreplicationtomanageloadbalancinganddealwithonlinebackupandfail-overscenarios.Asyouconsiderthebenefitsofbackingup,youmightliketobackupyourdatabaseefficientlywithadvancedtechniquescoveredinthisbook.
Thebookdemonstrateshowtocreate,modify,anddeleteindexes.Youwillalsolearntoidentifyduplicateindexes,whichhinderyourMySQLserverperformance.Thisbookfocusesonadministrationtasksandwillhelpyouasanadministratortooptimizethedatabaseforefficiencyandreliability.
Youwilllearntomanagedataefficientlybyinsertingdatainexistingdatabasecontentandimportingandexportingdatabases.Thesooneryoulearnabouttakingadvantageofmetadatafromthisbook,thesooneryoucanstartusingthespaceefficiently.Gettoknowaboutmanagingusersandassigningprivilegesandregaininglostadministrativeusercredentials.Finally,learntomanagethedatabaseschemabycustomizingittoautomatedatabaseschemaevolutioninthecontextofapplicationupdates.
Whatyouwilllearnfromthisbook
Approach
Thisbookusestheapproachofacookbook,presentingsolutionstoproblemsintheformofrecipes.Eachrecipeprovidesthereaderwitheasystep-by-stepdescriptionsoftheactionsnecessarytoaccomplishaspecifictask.Examplevaluesandcodesamplesareusedthroughouttherecipes,whichmakesadaptationforindividualneedseasy
Administratorsofallskill-levelswillfindstep-by-stepinstructionsforpracticalapproachestoMySQLconfiguration,maintenance,andoptimizationtopics.Eachrecipeusesaconcreteexampleforeasyunderstanding.
Whothisbookiswrittenfor
ThisbookisforambitiousMySQLusersaswellasprofessionaldatacenterdatabaseadministrators.BeginnersaswellasexperiencedadministratorswillprofitfromthiscookbookandgetfreshideastoimprovetheirMySQLenvironments.DetailedbackgroundinformationwillenablethemtowidentheirMySQLhorizon.
ItdoesnotcoverSQLbasics,howtoinstallMySQLservers,orhowtodesignarelationaldatabaseschema.ReadersareexpectedtohaveabasicunderstandingoftheSQLlanguageanddatabaseconceptsingeneral.