MySQL DBA's Blog

Archive for October, 2009

Amazon宣布在美国推出MySQL服务

Saturday, October 31st, 2009

http://aws.amazon.com/rds/
看到这个消息,首先想到的是Amazon肯定有很多空闲的MySQL服务器。

Amazon是云计算的始作俑者,推出云计算主要是为了解决服务器资源过剩的问题:
Amazon played a key role in the development of cloud computing by modernizing their data centers after the dot-com bubble which, like most computer networks, were using as little as 10% of their capacity at any one time just to leave room for occasional spikes. Having found that the new cloud architecture resulted in significant internal efficiency improvements whereby, small, fast-moving “two-pizza teams” could add new features faster and easier, Amazon started providing access to their systems through Amazon Web Services on a utility computing basis in 2005.[21]
(more…)

Taobao新家

Thursday, October 29th, 2009

搬到创业有两个星期了,今天早上终于有机会拿相机去四处拍了拍。希望大家喜欢~

从创业六楼的正门开始进入淘宝!
zhengmen
(more…)

MySQL性能监控系统构思

Wednesday, October 28th, 2009

之前设计了一个性能监控系统,用于淘宝的MySQL性能监控。整个框架如下:
1、客户端跑脚本采集MySQL的状态值,计算一段时间内状态值的变化并存成文件,通过FTP传送到Monitor上
2、Monitor上面部署了一个C++程序,可以解析这些文件并将数据送入数据库
3、前台通过PHP和JPGRAPH来展现数据
(more…)

mysqlreport研究

Monday, October 26th, 2009

祝幽在测试用户中心时要求在MySQL服务器上安装mysqlreport以便观察性能。我让他直接用MyDoc去看状态值是否合理,因为我自己没用过mysqlreport,出来的数值不知道怎么去解读;况且MyDoc是我自己写的,虽然很挫,但是顺手。
没能满足祝幽的愿望,不得不说是一个遗憾。mysqlreport已经好长时间没有更新了,不过研究一下有利于我改进MyDoc。于是下载了mysqlreport的文档,周末回家仔细学习了一下。
(more…)