Architecture

MySQL 5.5&5.6 new features summary

February 10, 2014 Architecture, MYSQL, performance No comments

upload on 2014.2 [MySQL 5.5&5.6 new features summary] Download this PDF[……]

Read more

MyAWR another mysql awr –That is Great !!

May 22, 2013 Architecture, MYSQL, performance No comments

MyAWR 开源了,第一版的reference 已经放出, tx to noodba

MyAWR_Reference_Guid
slideshare地址:MyAWR (awr of MySQL)
MyAWR template:MySQL WorkLoad Report[……]

Read more

MySQL AWR – Myawr

May 6, 2013 Architecture, MYSQL, performance No comments

noodba同学写的基于mysql的 WORKLOAD REPOSITORY工具,目前还没有开源 非常的给力!!

主要思想为一台管理机器,集中了所有client端的数据,client 为mysql database 使用host_id来区分 如 host_id=1代表mysql databas[……]

Read more

基于MHA 的MySQL高可用方案

March 25, 2013 Architecture, MYSQL No comments

aaqwsh与select同学测试的MHA文档,另外基于这个HA方案公司应该会部署一些核心应用。另外提供之前的MHA测试

[……]

Read more

drbd+heartbeat+mysql slave 方案

March 29, 2012 Architecture, MYSQL No comments

drbd+heartbeat+mysql slave 方案

测试机器IP:public
10.2.0.181 — drbd+heartbeat
10.2.0.182 — drbd+heartbeat
10.2.0.183 — mysql slave
10.2.0.184[……]

Read more