Database Tiering

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

1、DatabaseTieringAchievingScale-OutbyCombiningMySQLwithyourExistingDatabase®AMySQLBusinessWhitePaperJuly2005Copyright©2005,MySQLABTableofContentsExecutiveOverview.......................................................................................3DatabaseTieringThroughReplication.........

2、...............................................3DatabaseTieringbyUsingGoldenGateSoftware......................................5WhentoUseGoldenGate..............................................................................7Conclusion.......................................................

3、...............................................8AboutMySQLNetwork..................................................................................8Resources.......................................................................................................9Copyright©2005,MySQLABPage2Ex

4、ecutiveOverviewManyorganizationsarefacingadoublethreatofincreasingvolumesofdataandtransactionswhileatthesametimeneedingtoreducetheirITorganizations’resources.Asaresult,manyareturningtoanew,modernscale-outarchitecturethatisbuiltonusinglow-costcommodityIntel/Opteronhardwarerunninganopensourc

5、eLAMP(Linux,Apache,MySQL,PHP/Perl/Python)stack.Whilemanymightadvocatemigratingexistingdatabaseapplicationstoanopensourcesolution,theremaybepracticalreasonstonotundertakesuchmigrationprojects.Isthereanarchitecturethatenablesorganizationstokeeptheircurrentdatabasesystemsrunningas-iswhileaddi

6、ngopensourcetothesolution?Yes,infactthenotionof“databasetiering”hasbecomeacommonwayformanyITorganizationstoaddopensourcesoftwaretoprovidegreatercost-effectivescale-outwhileminimizingchangetoexistingsystems.Theconceptbehinddatabasetieringistheseamlessco-existenceofmultiple(legacyandnew)data

7、basetechnologiestobestsolveabusinessproblem.Inmanycases,legacysystemsanddatabasesaredifficulttoreplaceinonestep.Atthesametime,legacydatabaseinfrastructuresposeexponentialcostproblemsandmaylimitoptionstoaccommodatefurthergrowth.Byusingadatabasetieringmethodolog