白皮书 MySQL高可靠集群方案介绍

Copyright©2003,MySQLABAGuidetoHighAvailabilityClusteringHowMySQL®Supports99.999%AvailabilityAMySQL®BusinessWhitePaperJune,2004Copyright©2003,MySQLABPage2TableofContentsExecutiveSummary.......................................................................................3IntroductiontoMySQLCluster.....................................................................3AdvantagesofMySQLCluster.....................................................................4ArchitectureofMySQLCluster.....................................................................4HighAvailabilityReducesCostlyDowntime...............................................5HighPerformanceOnlyaMainMemoryDatabaseCanDeliver................5AutomaticFastFailoverWithoutCustomProgramming...........................6IncrementallyScaleApplicationstoMeetCapacity...................................6HotBackupandRestorewithoutSystemInterruption..............................6SignificantlyReducetheCostofDowntime................................................6ReduceHardwareCosts................................................................................7LowerMaintenanceCosts.............................................................................7EasytoUseAdministration..........................................................................7Services&Support........................................................................................7Conclusion......................................................................................................7AboutMySQL.................................................................................................8Copyright©2003,MySQLABPage3ExecutiveSummaryMoreandmoreorganizationsarerelyingononlineandelectronicmeanstogrowtheirbusiness,improveefficiencies,andcutcosts.ThisincreasedrelianceonInternetandnetworkedtechnologiestomeetbusinessgoalsisforcingorganizationstodeliver‘alwayson’availabilitytomaximizerevenuesandsatisfycustomerexpectations.Downtimeforsuchapplicationscanmeananimmediatelossinrevenues.Forexample,•Telecomprovidersandnetworkoperatorsarerequiredtoprovidenon-stop,alwaysavailableservicetoanincreasingnumberofuserstostaycompetitive.Inaddition,telecomprovidersmustextendtheirservicestoincludeadditionalcontentandvideo.•Financialinstitutionsmustcontinuetoaccommodatetheincreasingvolumeofusersandtime-sensitivetransactionswithoutsacrificingreal-timeperformancerequirements.•PublicwebsitesandcompanyportalsthatprovideselfserviceapplicationsovertheInternetmustbeabletoaccommodatethegrowingonlinecommunityandtheexponentialgrowthindatathatneedsbedelivered.•E-commercecompaniesandothersthataregrowingtheironlinesaleschannelmustaccommodatethegrowingaudienceofonlineshoppers.Fortheseandotherorganizationswhocannotafforddowntime,ahighavailabilitydatabasesolutionisacentralandcriticalcomponenttotheirsuccess.Withoutahighavailabilitydatabasetheycompromisecustomersatisfactionandtheirrevenuestream.Atthesametime,budgetaryconstraintsareforcingorganizationstomeetthesedemandsinamorecost-effectivemannerthancanbeachievedbyusingaproprietarydatabase.Proprietarydatabasestypicallyrequirehighannualsoftwarelicensingcosts,inadditiontolargeupfronthardwareandsoftwareinvestments.Andtraditionalsolutionstohigh-availabilityareexpensivetodevelopandmaintainduetotheircomplexity,makingthemcost-prohibitiveformanyorganizations.ThiswhitepaperdescribeshowMySQLClusterisabletocost-effectivelymeettheneedforhighavailabilitydatabaserequirements.ThiswhitepaperwillalsodescribetheuniquearchitectureandfeaturesthatMySQLClusterimplementstoachieve99.999%availability.IntroductiontoMySQLClusterMySQLisanopensourcedatabasewithover4millioninstallations.MySQLisprovenforitseaseofuseandreliabilityandhasbeenadoptedbysomeofthelargestorganizationsworldwideincludeSabre,Yahoo!,andLufthansa.OneoftheprimaryreasonsforMySQL’swidespreadadoptionisitsabilitytoreducedatabaseTCO.Onaverage,companiesusingMySQLareexperiencingper-projectsavingsofbetween$250,000and$500,000.Largerprojects,orenterprisedeployments,areyieldingsavingsofmillionsofdollars.MySQLClusteristhehigh-availabilityversionoftheworld’smostpopularopensourcedatabasewhichprovides“5nines”availability.MySQLClusterwasdevelopedinclosecooperationwithoneofthelargesttelecomequipmentvendorsintheworldtomeetthehighavailability,throughput,andresponse-timerequirementsoftelecomprovidersandnetworkoperators.MySQLClusterimplementsadistributed,highlyfaulttolerantarchitecturewithnosinglepointoffailure.Inessence,MySQLClusterdeliversmainframereliabilityoncommodityhardwaremakingitthemostcost-effectivesolutionforhighavailability.UsingMySQLClusterorganizationscandeliverthescalability,reliabilityandperformancetorunthemostdemandingapplicationsintheworld.Copyright©2003,MySQLABPage4AdvantagesofMySQLClusterMySQLCluster’suniqueparallelfaulttolerantarchitectureprovidesthefollowingbenefits:•99.999%Availability–providedbyafaulttolerantarchitecture•CostEffective–requiringlesshardware,lowermaintenancecosts,andaffordablelicensingcomparedtoproprietarydatabases.•Hig