MySQL.Cluster.Tutorial.2010

《MySQL.Cluster.Tutorial.2010》由会员上传分享，免费在线阅读，更多相关内容在学术论文-天天文库。

1、MySQLClusterTutorialO’ReillyMySQLConference&Expo2010,Apr.122010.AndrewHutchings(Oracle)AndrewMorgan(Oracle)GeertVanderkelen(Oracle)ThisdocumentisahandoutfortheMySQLClusterTutorial.Pleasealsochecktheslideswhichwereshownturingthetutorial.http://en.oreilly

2、.com/mysql2010/public/schedule/detail/12438Copyright©2010,Oracleand/oritsaffiliates.Allrightsreserved.1/81Introduction!5VirtualMachine!5Topics!5Speakers!6MySQLClusterinshort!7Transactions!7InstallationandConfiguration!9ReleaseModelandVersioning!9Download!

3、9Installation!9Locations!10Configuration!11Starting&UsingMySQLCluster!13StartingMySQLCluster!13StartManagementNode(s)!13StartDataNodes!14StartMySQLServer(s)!14CreateaClustertable!15Exercise:!16AdministerMySQLCluster!17CommonCommands!17DataNodeLogs!20MySQ

4、LClusterManager!23MySQLClusterManager–ArchitectureandUse!23MySQLClusterManagerModel&Terms!25UsingMySQLClusterManager–aworkedexample!26Singlehostexercise!33Faulttolerance!34MySQLServer!34Heartbeats!34OnlineBackup!36Tools!36Backingupthedata,online!36Backi

5、ngupmetadata!36Restoringusingndb_restore!37ndb_restorecandomore!38NDBInfo!39Copyright©2010,Oracleand/oritsaffiliates.Allrightsreserved.2/81ndbinfoDataNodeStatistics!39ndbinfo.counters!39ndbinfo.logbuffers!40ndbinfo.logspaces!40ndbinfo.memoryusage!41ndbin

6、fo.nodes!41ndbinfo.transporters!42Exercise!42NDBAPI!43NDBAPIOverview!43ExampleNDBAPICode!44MySQLClusterConnectorforJava!49TechnicalOverview!49ClusterJ!50ClusterJPA!52Pre-requisitesforTutorial!54ClusterJTutorial!55CompilingandrunningtheClusterJtutorialco

7、de!61OpenJPA/ClusterJPATutorial!61CompilingandrunningtheClusterJPAtutorialcode!67Exercise!67Schemaconsiderations!68DevelopforMySQLCluster!68Re-normalization!68Denormalization!69PrimaryKeysandUniqueIndexes!70HistoricalData!70ScalingandPerformance!71MySQL

8、Nodes!71NDBAPI!71DataNodes!71OtherIssues!71OnlineAddNode!72GeographicalReplication!73BinaryLogFormat!73EnablingBinaryLogging!74TheLOST_EVENTincident&solution!75SettingupReplicationbetweenClusters!76Copyright©2010,Oracleand/oritsa