关于数据库的选择 , 案例 -- 两个凡是

宏哥 发布于 2016/12/28 21:58
阅读 1K+
收藏 0

微信用PG 越做越好

支付宝用 定制数据库

剩下的小公司, 用mysql

基本上是这个情况

加载中
2
notreami
notreami

这个牛皮吹的,苹果有些业务也是mysql哦,所以苹果是小公司。

1
eechen
eechen
支付宝用阿里自研的OceanBase,不代表阿里其他服务如淘宝,阿里云不用MySQL,否则阿里最新开源的MySQL分支AliSQL是怎么来的?

腾讯用MySQL也很多,腾讯互动娱乐事业群的DBA林水彬,就是在腾讯搞MySQL的,你可以看下人家的一篇技术分享:
http://dbaplus.cn/news-21-418-1.html
说的是用TokuDB这个引擎替换原来的InnoDB/MyISAM引擎,作为logdb(又叫Tlog)存储玩家的一些流水日志,如登录登出,购买的道具记录等,实现压缩数据后存储,大幅减少磁盘占用,以及在线快速添加和删除字段,适应业务变更.

MySQL一直在变强,Oracle搞的5.7,Percona基于InnoDB优化的XtraDB以及去年收购TokuTek拿到的TokuDB,都体现出MySQL的发展和进步.Percona的CEO Zaitsev(扎伊采夫,俄国人)还写了一篇博文说为什么要收购TokuDB:
https://www.percona.com/blog/2015/04/14/percona-acquired-tokutek-peter-zaitsev/
因为TokuTek之前还搞了个MongoDB的底层引擎实现TokuMX(toku2mongo),让NoSQL数据库MongoDB有了一个真正的关系数据库的芯,所以现在Percona也推出了Percona Server for MongoDB的产品线.

也就是说,TokuDB应该很有自己的亮点的,说不定楼主会因为TokuDB喜欢上MySQL呢?

Debian/Ubuntu可以非常方便地通过apt安装Percona官方源提供的二进制包:
http://www.percona.com/doc/percona-server/5.6/installation/apt_repo.html
wget https://repo.percona.com/apt/percona-release_0.1-4.$(lsb_release -sc)_all.deb
sudo dpkg -i percona-release_0.1-4.$(lsb_release -sc)_all.deb
sudo apt-get update
apt-cache search percona
可以看到Percona提供的所有工具,比如:
percona-xtrabackup-dbg - Debug symbols for Percona XtraBackup
percona-xtrabackup-test - Test suite for Percona XtraBackup
percona-xtradb-cluster-client - Percona XtraDB Cluster database client
percona-xtradb-cluster-server - Percona XtraDB Cluster database server
percona-xtradb-cluster-testsuite - Percona XtraDB Cluster database regression test suite
percona-xtradb-cluster-testsuite-5.5 - Percona Server database test suite
libperconaserverclient18 - Percona Server database client library
libperconaserverclient18-dev - Percona Server database development files
libperconaserverclient18.1 - Percona Server database client library
libperconaserverclient18.1-dev - Percona Server database development files
libperconaserverclient20 - Percona Server database client library
libperconaserverclient20-dev - Percona Server database development files
percona-agent - Percona Agent binaries
percona-cacti-templates - Percona Monitoring Plugins for Cacti
percona-nagios-plugins - Percona Monitoring Plugins for Nagios
percona-server-5.5-dbg - Debugging package for Percona Server
percona-server-5.6-dbg - Debugging package for Percona Server
percona-server-5.7-dbg - Debugging package for Percona Server
percona-server-client - Percona Server database client
percona-server-client-5.5 - Percona Server database client binaries
percona-server-client-5.6 - Percona Server database client binaries
percona-server-client-5.7 - Percona Server database client binaries
percona-server-common-5.5 - Percona Server database common files (e.g. /etc/mysql/my.cnf)
percona-server-common-5.6 - Percona Server database common files (e.g. /etc/mysql/my.cnf)
percona-server-common-5.7 - Percona Server database common files (e.g. /etc/mysql/my.cnf)
percona-server-mongodb - This metapackage will install the mongo shell, import/export tools, other client utilities, server software, default configuration, and init.d scripts.
percona-server-mongodb-32 - This metapackage will install the mongo shell, import/export tools, other client utilities, server software, default configuration, and init.d scripts.
percona-server-mongodb-32-dbg - Debugging package for Percona Server for MongoDB
percona-server-mongodb-32-mongos - This package contains mongos - the Percona Server for MongoDB sharded cluster query router
percona-server-mongodb-32-server - This package contains the Percona Server for MongoDB server software, default configuration files and init.d scripts
percona-server-mongodb-32-shell - This package contains the Percona Server for MongoDB shell
percona-server-mongodb-32-tools - Mongo tools for high-performance MongoDB fork from Percona
percona-server-mongodb-dbg - Debugging package for Percona Server for MongoDB
percona-server-mongodb-mongos - This package contains mongos - the Percona Server for MongoDB sharded cluster query router
percona-server-mongodb-server - This package contains the Percona Server for MongoDB server software, default configuration files and init.d scripts
percona-server-mongodb-shell - This package contains the Percona Server for MongoDB shell
percona-server-mongodb-tools - Mongo tools for high-performance MongoDB fork from Percona
percona-server-server - Percona Server database server
percona-server-server-5.5 - Percona Server database server binaries
percona-server-server-5.6 - Percona Server database server binaries
percona-server-server-5.7 - Percona Server database server binaries
percona-server-source-5.5 - Percona Server 5.5 source
percona-server-source-5.6 - Percona Server 5.6 source
percona-server-source-5.7 - Percona Server 5.7 source
percona-server-test-5.5 - Percona Server database test suite
percona-server-test-5.6 - Percona Server database test suite
percona-server-test-5.7 - Percona Server database test suite
percona-server-tokudb-5.6 - TokuDB engine plugin for Percona Server
percona-server-tokudb-5.7 - TokuDB engine plugin for Percona Server
percona-toolkit - Advanced MySQL and system command-line tools
percona-xtrabackup - Open source backup tool for InnoDB and XtraDB
percona-xtrabackup-21 - Open source backup tool for InnoDB and XtraDB
percona-xtrabackup-22 - Open source backup tool for InnoDB and XtraDB
percona-xtrabackup-24 - Open source backup tool for InnoDB and XtraDB
percona-xtrabackup-dbg-21 - Debug symbols for Percona XtraBackup
percona-xtrabackup-dbg-22 - Debug symbols for Percona XtraBackup
percona-xtrabackup-dbg-24 - Debug symbols for Percona XtraBackup
percona-xtrabackup-test-21 - Test suite for Percona XtraBackup
percona-xtrabackup-test-22 - Test suite for Percona XtraBackup
percona-xtrabackup-test-24 - Test suite for Percona XtraBackup
percona-xtradb-cluster-5.5-dbg - Debugging package for Percona XtraDB Cluster
percona-xtradb-cluster-5.6-dbg - Debugging package for Percona XtraDB Cluster
percona-xtradb-cluster-5.7-dbg - Debugging package for Percona XtraDB Cluster
percona-xtradb-cluster-55 - Percona XtraDB Cluster with Galera
percona-xtradb-cluster-55-g3 - Percona XtraDB Cluster with Galera
percona-xtradb-cluster-56 - Percona XtraDB Cluster with Galera
percona-xtradb-cluster-57 - Percona XtraDB Cluster with Galera
percona-xtradb-cluster-client-5.5 - Percona XtraDB Cluster database client binaries
percona-xtradb-cluster-client-5.6 - Percona XtraDB Cluster database client binaries
percona-xtradb-cluster-client-5.7 - Percona XtraDB Cluster database client binaries
percona-xtradb-cluster-common-5.5 - Percona XtraDB Cluster database common files (e.g. /etc/mysql/my.cnf)
percona-xtradb-cluster-common-5.6 - Percona XtraDB Cluster database common files (e.g. /etc/mysql/my.cnf)
percona-xtradb-cluster-common-5.7 - Percona XtraDB Cluster database common files (e.g. /etc/mysql/my.cnf)
percona-xtradb-cluster-full-55 - Percona XtraDB Cluster with Galera
percona-xtradb-cluster-full-55-g3 - Percona XtraDB Cluster with Galera
percona-xtradb-cluster-full-56 - Percona XtraDB Cluster with Galera
percona-xtradb-cluster-full-57 - Percona XtraDB Cluster with Galera
percona-xtradb-cluster-galera-2 - Metapackage for latest version of galera2.
percona-xtradb-cluster-galera-2.x - Galera components of Percona XtraDB Cluster
percona-xtradb-cluster-galera-2.x-dbg - Debugging package for Percona XtraDB Cluster Galera 2.
percona-xtradb-cluster-galera-3 - Metapackage for latest version of galera3.
percona-xtradb-cluster-galera-3.x - Galera components of Percona XtraDB Cluster
percona-xtradb-cluster-galera-3.x-dbg - Debugging package for Percona XtraDB Cluster Galera 3.
percona-xtradb-cluster-galera2-dbg - Metapackage for latest version of debug packages.
percona-xtradb-cluster-galera3-dbg - Metapackage for latest version of debug packages.
percona-xtradb-cluster-garbd-2 - Metapackage for latest version of garbd2.
percona-xtradb-cluster-garbd-2.x - Garbd components of Percona XtraDB Cluster
percona-xtradb-cluster-garbd-2.x-dbg - Debugging package for Percona XtraDB Cluster Garbd 2.
percona-xtradb-cluster-garbd-3 - Metapackage for latest version of garbd3.
percona-xtradb-cluster-garbd-3.x - Garbd components of Percona XtraDB Cluster
percona-xtradb-cluster-garbd-3.x-dbg - Debugging package for Percona XtraDB Cluster Garbd 3.
percona-xtradb-cluster-garbd-5.7 - Garbd components of Percona XtraDB Cluster
percona-xtradb-cluster-server-5.5 - Percona XtraDB Cluster database server binaries
percona-xtradb-cluster-server-5.6 - Percona XtraDB Cluster database server binaries
percona-xtradb-cluster-server-5.7 - Percona XtraDB Cluster database server binaries
percona-xtradb-cluster-server-debug-5.5 - Percona XtraDB Cluster database server UNIV_DEBUG binaries
percona-xtradb-cluster-server-debug-5.6 - Percona XtraDB Cluster database server UNIV_DEBUG binaries
percona-xtradb-cluster-server-debug-5.7 - Percona XtraDB Cluster database server UNIV_DEBUG binaries
percona-xtradb-cluster-source-5.5 - Percona XtraDB Cluster 5.5 source
percona-xtradb-cluster-source-5.6 - Percona XtraDB Cluster 5.6 source
percona-xtradb-cluster-source-5.7 - Percona XtraDB Cluster 5.7 source
percona-xtradb-cluster-test-5.5 - Percona XtraDB Cluster database test suite
percona-xtradb-cluster-test-5.6 - Percona XtraDB Cluster database test suite
percona-xtradb-cluster-test-5.7 - Percona XtraDB Cluster database test suite
percona-zabbix-templates - Percona Monitoring Plugins for Zabbix
pmm-client - Percona Monitoring and Management Client
xtrabackup - Transitional package for percona-xtrabackup
percona-release - Package to install Percona gpg key and APT repo



如果你只想安装5.6版本,只需执行:
sudo apt-get install \
percona-server-server-5.6 \
percona-server-client-5.6
0
loyal
loyal
谁说微信用的PG?
快速开发师
快速开发师
这个还真别说progress在很多方面超过oracle,特别是在做erp方面
0
空指针
空指针

既然是数据库选择案例,那就把主流的数据库的优劣,什么情况下该如何选择说清楚!  

PS : 技术牛的不一定是好奶牛,没事别瞎BB, 误导人。  

0
U
Uabc
这些东西只能当个笑话看
0
爱吃荷包蛋i
爱吃荷包蛋i
在用Percona 
0
geminiblue
geminiblue

我只知道,电信多用oracle,税务系统oracle,用pg的没见过,任你怎么说,mysql用起来还是杠杠的

快速开发师
快速开发师
回复 @雨翔河 : 早期的ERP软件那个时候,都是字符界面,字符界面的概念不知道你知道不,相信宏哥这种年纪应该知道,现在字符界面依然没有被淘汰,因为速度快啊,再配合progress就TM更快了,你知道用户最讨厌速度慢了
雨翔河
雨翔河
回复 @快速开发师 : 外企吧
快速开发师
快速开发师
回复 @雨翔河 : 你知道QAD么?
雨翔河
雨翔河
回复 @快速开发师 : 专做erp?别逗我,国外很流行的好吧,它支持标准的sql,运算符和各种处理函数是最多的,子查询比mysql性能强很多,不可否认postgresql比mysql在某些方面强很多,但是mysql的文档和应用在大陆地区比postgresql多太多,mysql的使用也相对更加简单。
快速开发师
快速开发师
pg是用来专做erp的,很多方面超过oracle
0
大賢者
大賢者
 不好说,要综合考虑,不知道谁闲的蛋疼可以写点测试数据,各种db,各种查询执行,有对比才有伤害
0
AutoPlus
AutoPlus
接触的范围太少了,桌面应用需要嵌入式 sqlite,科学计算、生活设施需要 Nosql 存储大量无关联元数据,mysql 对于快速响应要比 pg 好得多,pg 对于稳定可靠要比 mysql 好一些
0
懶蟲
懶蟲
经常看到这货在这误导别人,每个数据库或语言都很好,它们存在有它们的理由。有可能是业务环境和人等等的原因造成了数据库迟缓和压力。下次再下结论时请拿出数据说话,否则就别瞎BB了。
返回顶部
顶部