资源描述:
《google高级架构师jeremy cole谈大规模mysql架构》由会员上传分享,免费在线阅读,更多相关内容在学术论文-天天文库。
1、TheMySQLEcosystematScaleJeremyColeSr.SystemsEngineer-SREGoogleInc.JeremyCole@jeremycole“MakingMySQLAwesome”atGoogleWorkedatMySQLAB2000-2004Contributorsince3.23Over14yearsintheMySQLcommunityCode,documentation,research,bugreportsYahoo!,ProvenScaling,TwitterBuiltaMySQL5.5forkatTwitterAttendedXLD
2、Bmanytimesbuthaven’tspokenbeforeAboutthistalkNotreallyaboutGoogle,perseNotacademicorscientificallyfocusedPragmatic,fromindustryexperienceonlyImperfectandnon-idealworldMySQL’srootsHigh-scaleusagescenariosStrengthsandweaknessesatscaleStateandfutureoftheMySQLecosystemDatabasesinindustryAlwaysonli
3、ne,nodowntimeLowriskorcarefullymanagedriskfromoperationsMigrationisthehardestpartofanychangeNodowntime,minimalimpactfromchangesUsually50-steponlinemigration,not2-stepdowntimeRollbackmustalsobeonlineBeingupismuchmoreimportantthanbeingrightThebusinessismoreimportantthangooddatabaseprinciplesDat
4、abasesarefunUntilyouusethem...AbitofMySQLhistoryAshorthistoryoftheMySQLsoftware1994:Developmentstarted;somerootsalreadypresent2000:3.23+InnoDB,replication2002:4.0+replicationredesign,setoperations2004:4.1+subqueries2005:5.0+storedprocedures,views,triggers,XA2008:5.1+partitioning,row-basedrepl
5、ication2010:5.5+stability,codecleanup,InnoDBscalability2013:5.6+InnoDBscalability,performance,manageabilityTheMySQLcommerciallandscape2003:Alzato(MySQLCluster)acquiredbyMySQL2005:InnobaseOy(InnoDB)acquiredbyOracle2006:Perconafounded2008:MySQLAB/Inc.acquiredbySun2009:MontyProgram(MariaDB)found
6、ed2010:SunacquiredbyOracle2010:SkySQLfounded2013:MontyProgramacquiredbySkySQL2011MySQLdeclareda“fateworsethandeath”byMikeStonebraker2013MySQLstillrunningmostoftheweb,includingTwitterandFacebookandGoogleand...MySQLMySQLwinsPrettyfast,usually(<500µsfortypicalreasonablequeries)Veryrobustdatastor
7、agelayer(InnoDB)Replicationthatusuallyworks(orisatleastwellunderstood)EasytouseandeasytorunHmm!ArandomserverwecameacrossatTwitter:Uptime:212d11h16mQuestions:127481750624(127billion,or6,943persecond)Innodb_rows_read:24989035721780(24.9trillion