Reference Oracle AWR. These two was developed by python and perl.
Both of these are following data collection method.
Use these tools can help[……]
August 21, 2014 MYSQL, performance No comments architecture, mongodb, mysqlawr, nosql
Reference Oracle AWR. These two was developed by python and perl.
Both of these are following data collection method.
Use these tools can help[……]
August 12, 2014 Architecture, MYSQL No comments architecture, mysql
July 28, 2014 MYSQL, performance 2 comments mysql
看到叶金荣的一篇关于mysql分页的文章,结合雅虎之前发的一篇PDF 谈谈自己的看法
在叶子的文章里谈到了使用inner join 从而减少了对page的扫描也就是减少了所谓的回表 例如:
SELECT * FROM `t1` INNER JOIN ( SELECT id FROM `t[......]
July 17, 2014 migration, oracle, system, unix No comments architecture
You can view this presentation click here: x86_architect
注意使用chrome打开文件 不然可能乱码[……]
June 18, 2014 Architecture, MYSQL No comments architecture
June 9, 2014 Architecture, MYSQL, replication No comments HA
Oracle Clusterware is portable cluster software that allows clustering of independent servers so that they cooperate as a single system. Oracle Clus[……]
May 13, 2014 Architecture, MYSQL, replication No comments architecture
news in mysqlbinlog – Back Up Master Binary Log Files
从mysql5.6开始 mysqlbinlog开始支持远程读取master主机的binlog写入本地,极大的加强了binlog的备份策略,由于在mysql cluster复制环境中,b[……]
May 12, 2014 Architecture, MYSQL, replication No comments
Multi-master-rep
two masters: -- 192.168.126.128 mysql 5.6.12 -- 192.168.126.129 mysql 5.6.12
slave : -- 192.168.126.130 MariaDB 10.0
[……]
April 3, 2014 Architect, Exadata, hardware, oracle No comments architecture
Download PDF: [SHOUG.LOUISLIU]Exadata在电商的实践[……]
February 10, 2014 Architecture, MYSQL, performance No comments architecture
upload on 2014.2 [MySQL 5.5&5.6 new features summary] Download this PDF[……]