2
回答
分享wanelo数据库从mysql迁移到postgresql的一个例子
滴滴云服务器,限时包月0.9元,为开发者而生>>>   
原文地址:
http://blog.wanelo.com/post/31534906083/the-big-switch-how-we-rebuilt-wanelo-from-scratch-and
wanelo的网址: http://wanelo.com/
举报
kenyon_君羊
发帖于5年前 2回/420阅
共有2个评论 最后回答: 5年前
Database Layer
The Java app relied on 53 database tables, some of which were still MyISAM, and some of which were InnoDB. Only about 10 of them had a lot of data. The database server performed significantly better after an upgrade to Percona Server, but was still showing a load average of about 4-5 during busy times.

The new PostgreSQL schema contained only 13 database tables upon launch, as we determined most of the MySQL tables weren’t in active use. After launch, we had to add some missing indices on tables, and after that the load on the server settled to about 1.5-2 during high-traffic times

他没有贴出来mysql迁移到postgresql后的性能比对环境,以及DB参数等,不过从效果看来有所提升

顶部