分享wanelo数据库从mysql迁移到postgresql的一个例子

kenyon_君羊 发布于 2012/09/20 15:52
阅读 441
收藏 2
原文地址:
http://blog.wanelo.com/post/31534906083/the-big-switch-how-we-rebuilt-wanelo-from-scratch-and
wanelo的网址: http://wanelo.com/
加载中
0
Wentasy
Wentasy
多谢分享。
0
kenyon_君羊
kenyon_君羊
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参数等,不过从效果看来有所提升

返回顶部
顶部