MySQL 5.1 集群白皮书

NewFeaturesinMySQLCluster5.1AMySQL®TechnicalWhitePaperAugust2006Copyright©2006,MySQLABPage1of22TableofContentsIntroduction......................................................................................................................................3NewFeatureOverview....................................................................................................................3MySQLClusterArchitectureOverview............................................................................................3DiskData.........................................................................................................................................6CreatingaMemory-BasedTable................................................................................................6CreatingaLOGFILEGROUPandTABLESPACE.....................................................................7CreatingaDisk-BasedTable......................................................................................................7DiskDataAdministrationandMaintenance................................................................................8MigratingMemory-BasedTablestoDisk....................................................................................9Parameters................................................................................................................................10AdditionalNotesonDiskData..................................................................................................10SupportforReplication..................................................................................................................11ReplicationChannel..................................................................................................................13ReplicationSchemaandTables...............................................................................................14ReplicationSetup......................................................................................................................15StartingReplication...................................................................................................................16AdditionalNotesonMySQLClusterReplication.......................................................................17FasterADD/DROPINDEX............................................................................................................17EfficientVariable-SizedRecords...................................................................................................19Conclusion.....................................................................................................................................20AboutMySQL................................................................................................................................21Resources......................................................................................................................................21WhitePapers.............................................................................................................................21CaseStudies.............................................................................................................................21PressReleases,NewsandEvents...........................................................................................21LiveWebinars............................................................................................................................21WebinarsonDemand................................................................................................................22Copyright©2006,MySQLABPage2of22IntroductionMySQLClusterisascalable,high-performance,clustereddatabase,originallydevelopedforsomeoftheworld’smostdemandingapplicationsfoundinthetelecommunicationsindustry.Oftenthesetelecomapplicationsrequiredthatthedatabase’savailabilityapproach99.999%.SinceMySQLCluster’sintroductionin2004,newfeaturesetshavebeensteadilyintroducedintotheproduct.Thishasbroadeneditsappealfornewapplicationuse-cases,marketsandindustries.MySQLClusterisnowbeingadoptednotonlyasadatabasefortraditionaltelecomapplicationslike,HLR(HomeLocatorRegistry)orSLR(SubscriberLocatorRegistry),itisnowalsobeingwidelydeployedforVOIP,internetbilling,sessionmanagement,eCommercesites,searchenginesandeventraditionalbackofficeapplications.InthispaperwewillexplorethenewfeatureswhichhavebeenintroducedinMySQLCluster5.1.NewFeatureOverviewWiththereleaseof5.1,manynewfeaturesandimprovementshavebeenintroducedtothealreadypopularMySQLCluster.Theseinclude:•SupportforDiskData•Row-basedReplication•HigherperformanceADD/DROPINDEX•MoreefficientVariableSizedRecordsMySQLClusterArchitectureOverviewBeforeembarkingonatechnicalexaminationofMySQLCluster’snewfeatures,itmakessensetoquicklyreviewtheproduct’sarchitectureandhowitfunctions.MySQLClusterisahighavailabilitydatabasebuiltusingauniquesharednothingarchitectureandastandardSQLinterface.Thesystemconsistsofmultipleno