荣耀彩票代理

IT技术互动交流平台

Percona与MariaDB分支对比详解过程

作者:whl  来源:网络整理  发布日期:2018-11-17 08:58:00
    很多人在使用MySQL时对于选择它哪一个分支而犹豫不决,那么到底是Percona更好还是MariaDB更好呢?小编为此特意对手上的资料进行了整理,下面将把这两个分支的各方面优劣对比一一列出来,大家可以参考一下,选择出更适合自己的一种。

在MySQL被Oracle收购以后,越来越多的人对于MySQL的前景表示了担忧,对于开源的MySQL,或多或少对于Oracle自家的数据库产品产生冲击,这个开源免费的MySQL 对于Oracle更多的是包袱而不是资产。比如淘宝就从Oracle转成了MySQL,一些大型互联网公司也在推行去IOE(I:IBM,O:Oracle,E:EMC),甲骨文公司收购了MySQL后,有将MySQL闭源的潜在风险,因此社区采用分支的方式来避开这个风险。

MySQL

Percona

ZAIJIESHAO Percona ZHIQIAN,SHOUYAOYAOJIESHAODESHIXtraDBCUNCHUYINQING,ZAIMYSQLZHONGJIECHUBIJIAODUODESHIMyISAMHEInnoDBZHEILIANGGECUNCHUYINQING,XIANQIANDEWENZHANG:《MySQL MyISAMHEInnoDBDEQUBIE》YEJINXINGLEXIANGXIDEJIESHAO。

MySQL 4HE5SHIYONGMORENDEMyISAMCUNCHUYINQINGANZHUANGMEIGEBIAO。CONG5.5KAISHI,MySQLYIJIANGMORENCUNCHUYINQINGCONGMyISAMGENGGAIWEIInnoDB。MyISAMMEIYOUTIGONGSHIWUZHICHI,ERInnoDBTIGONGLESHIWUZHICHI。YUMyISAMXIANGBI,InnoDBTIGONGLEXUDUOXIWEIDEXINGNENGGAIJIN,BINGQIEZAICHULIQIANZAIDESHUJUDIUSHISHITIGONGLEGENGGAODEKEKAOXINGHEANQUANXING。

Percona XtraDB SHI InnoDB CUNCHUYINQINGDEZENGQIANGBAN,BEISHEJIYONGLAIGENGHAODESHIYONGGENGXINJISUANJIYINGJIANXITONGDEXINGNENG,TONGSHIHAIBAOHANYOUYIXIEZAIGAOXINGNENGHUANJINGXIADEXINTEXING。XtraDB CUNCHUYINQINGSHIWANQUANDEXIANGXIAJIANRONG,ZAI MariaDB ZHONG,XtraDB CUNCHUYINQINGBEIBIAOSHIWEI”ENGINE=InnoDB”,ZHEIGEYU InnoDB SHIYIYANGDE,SUOYINIKEYIZHIJIEYONGXtraDB TIHUANDIAO InnoDB ERBUHUICHANSHENGRENHEWENTI。Percona XtraDB BAOHANYOUSUOYOU InnoDB's JIANZHUANGXING,KEYILAIDE ACID JIANRONGSHEJIHEGAOJI MVCC JIAGOU。XtraDB ZAI InnoDB DEJIANSHIJICHUSHANGGOUJIAN,SHI XtraDB JUYOUGENGDUODETEXING,GENGHAODIAOYONG,GENGDUODECANSHUZHIBIAOHEGENGDUODEKUOZHAN。CONGSHIJIANDEJIAODULAIKAN,XtraDB BEISHEJIYONGLAIZAIDUOHEXINDETIAOJIANXIAGENGYOUXIAODESHIYONGNEICUNHEGENGJIAFANGBIAN,GENGJIAKEYONG。XINDETEXINGBEIYONGLAIJIANGDI InnoDB DEJUXIANXING。XINGNENGCENGMIAN,XtraDBYUNEIZHIDEMySQL 5.1 InnoDB YINQINGXIANGBI,TAMEIFENZHONGKECHULI2.7BEIDESHIWU。

荣耀彩票代理Percona ServerYOULINGXIANDEMySQLZIXUNGONGSIPerconaFABU。Percona ServerSHIYIKUANDULIDESHUJUKUCHANPIN,QIKEYIWANQUANYUMySQLJIANRONG,KEYIZAIBUGENGGAIDAIMADEQINGKUANGLEXIAJIANGCUNCHUYINQINGGENGHUANCHENGXtraDB 。

荣耀彩票代理PerconaTUANDUIDEZUIZHONGSHENGMINGSHI“Percona ServerSHIYOUOracleFABUDEZUIJIEJINGUANFANGMySQL EnterpriseFAXINGBANDEBANBEN”,YINCIYUQITAGENGGAILEDALIANGJIBENHEXINMySQLDAIMADEFENZHIYOUSUOQUBIE。Percona ServerDEYIGEQUEDIANSHITAMENZIJIGUANLIDAIMA,BUJIESHOUWAIBUKAIFARENYUANDEGONGXIAN,YIZHEIZHONGFANGSHIQUEBAOTAMENDUICHANPINZHONGSUOBAOHANGONGNENGDEKONGZHI。

MariaDB

MariaDBYOUMySQLDECHUANGSHIRENMAIKEER·WEIDENIUSIZHUDAOKAIFA,TAZAOQIANCENGYI10YIMEIYUANDEJIAGE,JIANGZIJICHUANGJIANDEGONGSIMySQL ABMAIJILESUN,CIHOU,SUIZHESUNBEIJIAGUWENSHOUGOU,MySQLDESUOYOUQUANYELUORUOracleDESHOUZHONG。MariaDBMINGCHENGLAIZIMAIKEER·WEIDENIUSIDENVERMALIYA(YINGYU:Maria)DEMINGZI。

MariaDB的目的是完全兼容MySQL,包括API和命令行,使之能轻松成为MySQL的代替品。在存储引擎方面,10.0.9版起使用XtraDB(名称代号为Aria)来代替MySQL的InnoDB。

BANBENFANGMIAN,MariaDBZHIDAO5.5BANBEN,JUNYIZHAOMySQLDEBANBEN。YINCI,SHIYONGMariaDB5.5DERENHUICONGMySQL 5.5ZHONGLEJIEDAOMariaDBDESUOYOUGONGNENG。CONG2012NIAN11YUE12RIQIFABUDE10.0.0BANKAISHI,BUZAIYIZHAOMySQLDEBANHAO。10.0.xBANYI5.5BANWEIJICHU,JIASHANGYIZHIZIMySQL 5.6BANDEGONGNENGHEZIXINGKAIFADEXINGONGNENG。

XIANGDUIYUZUIXINDEMySQL5.6,MariaDBZAIXINGNENG、GONGNENG、GUANLI、NoSQLKUOZHANFANGMIANBAOHANLEGENGFENGFUDETEXING。BIRUWEIMIAODEZHICHI、XIANCHENGCHI、ZICHAXUNYOUHUA、ZUTIJIAO、JINDUBAOGAODENG。

KANDAOSHANGMIANZHEIXIENEIRONG,GUJIXUANZEPercona OR MariaDBDUIYUHENDUORENLAISHUOZHENSHIWUBIKUNNANDESHIQING,GENGHEKUANGSHIYOUXUANZEKUNNANZHENGDEYONGHULE。QISHIDUIYUZHEILIANGGESHUJUKUDEXUANZEHENDUOGONGSIYESHIZUOYOUYAOBAIDE,BIRUXIANZAITAOBAOSHIYONGDEJIUSHIPerconaSHUJUKUERGoogleZHEIXIESOUSUOWANGZHANFANERXUANZELEMariaDB。

延伸阅读:

Tag标签:   
  • 专题推荐

About IT165 - 广告服务 - 隐私声明 - 版权申明 - 免责条款 - 网站地图 - 网友投稿 - 联系方式
本站内容来自于互联网,仅供用于网络技术学习,学习中请遵循相关法律法规