2015mysql技术交流大会-mysql

2015,十月二十二日Copyright©2015,Oracleand/orits .| –Internal/Restricted/HighlySafeHarborThefollowingisintendedtooutlineourgeneralproductdirection.Itisintendedforinformationpurposesonly,andmaynotbeincorporatedintoanycontract.Itisnotacommitmenttodeliveranymaterial,code,orfunctionality,andshouldnotberelieduponinmakingpurchasingdecisions.Thedevelopment,release,andtimingofanyfeaturesorfunctionalitydescribedforOracle’sproductsremainsatthesolediscretionofOracle.Copyright©2015,Oracleand/orits .| –Internal/Restricted/Highly Copyright©2015,Oracleand/orits .| –Internal/Restricted/Highly Copyright©2015,Oracleand/orits .| –Internal/Restricted/Highly 流技术技术和基础平

Copyright©2015,Oracleand/orits . Copyright©2015,Oracleand/orits .| –Internal/Restricted/Highly 引领MySQL创新2010MySQLCluster7.1MySQLDatabaseMySQLEnterpriseBackup3.5MySQLClusterManager1.1MySQLEnterpriseBackup3.7全部正 PartialListofReleases

MySQLWindowsInstallerMySQLEnterpriseSecurityMySQLEnterpriseScalabilityMySQLCluster7.2MySQLUtilities全部正 tone

MySQLRouterMySQLMySQLFirewallMySQLEnterpriseBackup4.0MySQLFabricMySQLCluster7.4MySQLDatabase5.7全部正 MySQLRouter已经 Copyright©2015,Oracleand/orits .Copyright©2015,Oracleand/orits .| –Internal/Restricted/Highly

orOracle

19thFebruary Copyright©2015,Oracleand/orits .|Copyright2015,Oracleand/orits 1.从伺服器向主伺服器 create…insert…binarycreate…insert…M

3将relaylog的内容create…insert…relaycreate…insert…S

create…insert…binarycreate…insert…

Copyright©2015,Oracleand/orits . 读读主从19thFebruary Copyright©2015,Oracleand/orits .|Copyright2015,Oracleand/orits

MasterIORelay1

MasterIORelay2

…………

MasterIORelayN

19thFebruary Copyright©2015,Oracleand/orits .|Copyright2015,Oracleand/orits MySQLGroupMySQL

任何一个服务器都可以更新的多可侦 且解决之(事务转回不需服务器故障弹性横向扩张和收无单点故自动重19thFebruary Copyright©2015,Oracleand/orits .|Copyright2015,Oracleand/orits MySQLCluster5個9ApplicationMySQLClusterData

Data19thFebruary Copyright©2015,Oracleand/orits .|Copyright2015,Oracleand/orits MySQLCluster5個9ApplicationMySQLClusterData

Data19thFebruary Copyright©2015,Oracleand/orits .|Copyright2015,Oracleand/orits MySQLClusterApplicationMySQLClusterData

Data19thFebruary Copyright©2015,Oracleand/orits .|Copyright2015,Oracleand/orits MySQLCluster:主- 通过exceptiontable可调优自动解且相依的事务会滾

Cluster Cluster Copyright©2015,Oracleand/orits . MySQLFabric1.5:&

MySQL

化应用程序提供分范围或者哈资料分片可以再次分HA

HA

PHPNETC(labs)–不使 器，低延迟，没有瓶Copyright©2015,Oracleand/orits . -支持负载均衡,高可,MySQL

的ServerFarm之

MySQL

Fabric管理的Server MySQL Clusterware

Read-HA

Read-HA Copyright©2015,Oracleand/oritsaffiliates. s .|

– MySQL5.7:Sysbench 2xFasterthanMySQL5.63xFasterthanMySQLMySQL5.7:SysbenchReadOnly(Point

645,000QueriesQueriesper08

MySQLMySQLMySQL

(R)Xeon(R)CPUE7-48604socketsx10cores-HT(80CPU2.3GHz,512GBOracleLinuxCopyright©2015,Oracleand/orits . MySQL5.7:用Memcached的InnoDB6xFasterthanMySQLThank

1MillionMySQL5.7vs5.6-InnoDB&

MySQLQueriesQueriesper

MySQL0

(R)Xeon(R)CPUE7-48604socketsx10cores-HT(80CPU2.3GHz,512GBOracleLinuxCopyright©2015,Oracleand/orits . Copyright©2015,Oracleand/orits .| –Internal/Restricted/Highly $$Copyright©2015,Oracleand/oritsaffiliates.s.|Oracle–Internal/Restricted/Highly MySQLEnterpriseEdition Copyright©2015,Oracleand/orits . Copyright©2015,Oracleand/orits .MySQL Copyright©2015,Oracleand/orits .MySQL 实时查询效视觉化和图关找出和修正高代价的查详细查询统QueryResponseTimeindex

“WiththeMySQLQueryyzer,wewereabletoidentifyandyzeproblematicSQLcode,andtripleourdatabaseperformance.Moreimportantly,wewereabletoplishthisinthreedays,ratherthantakingKeithBigFishGamesCopyright©2015,Oracleand/orits .•，非锁定备份和回逻辑和物理备全量或增量备指时回也能做MyISAM表的备份和回

Tables&Copyright©2015,Oracleand/oritsaffiliates.s.MySQL线程池使容量扩充以上(读写

时性能耗竭的问题线程池Copyright©2015,Oracleand/orits .集中化开通，管理和认

/joelogsintologin,password

/joelogsapplication,applicationconnectstoMySQLwithuser

WinOSusers,groups,etcTokensarechecked,win_joeuserispasswordwithMySQLWinOSusers,groups,etc

\joeisauthenticatedonWindowsOSCREATEUSER

IDENTIFIEDWITHauthentication_windowsAS‘joe';

Copyright©2015,Oracleand/orits .

用户自定政策、筛选和日动态开启、关闭，不需重启数据XML为基础的审计流符合Oracle审计规容易通过MySQL5.5审计API实高于MySQL5.5.28的版Copyright©2015,Oracleand/orits .MySQL加密程序密钥管密钥交换方式RSADSA,和数据验–进行数 Copyright©2015,Oracleand/orits . SQLMySQL

SQL

Copyright©2015,Oracleand/orits .阻挡SQLInjection

MySQLEnterpriseFirewallCopyright©2015,Oracleand/orits .在云享有别的数据库无法比得上的地在AmazonRDS,阿里云 CloudSQL中最普遍的引OpenStack之Trove包括HPHelionCloudRelationalDatabase和RackspaceCloud OpenStack存放配置数据的默认存放Copyright©2015,Oracleand/orits . OracleOpenStackforOracleLinux

基于OpenStack OracleLinux或OracleVM 和MySQL

Copyright©2015,Oracleand/orits .MySQL ColumnColumnBasedCopyright©2015,Oracleand/orits .MySQLFabric1.5:&

MySQL

化应用程序提供分整数，日期等数字类范围或者哈希分Fabric适用的连接器Python,HA

HA

–不使 器，低延迟，没有瓶颈Copyright©2015,Oracleand/orits . MySQLApplierforUU

Brands“Liked”

WebLogs:

Copyright©2015,Oracleand/orits . Copyright©2015,Oracleand/orits .| –Internal/Restricted/Highly 流技术技术和基础平

Copyright©2015,Oracleand/orits . Copyright©2015,Oracleand/orits .| –Internal/Restricted/Highly Copyright©2015,Oracleand/orits .| –Internal/Restricted/Highly Copyrig