很久之前看过这个帖子,当时没有细究,这几天看了下mysql相关的internal 突然想起这个问题,跟三四个朋友讨论了下 想把这个问题展开讲一讲。
源帖子内容见：https://community.oracle.com/thread/1087650?start=0&tstart=0
这个[……]
Category: rdbms
Some data collection display
Reference Oracle AWR. These two was developed by python and perl.
Both of these are following data collection method.
Use these tools can help[……]
Talk about some MySQL HA architecture
Advanced Pagination for MySQL
看到叶金荣的一篇关于mysql分页的文章,结合雅虎之前发的一篇PDF 谈谈自己的看法
在叶子的文章里谈到了使用inner join 从而减少了对page的扫描也就是减少了所谓的回表 例如：
SELECT * FROM `t1` INNER JOIN ( SELECT id FROM `t[......]
小型机迁移x86平台之老生常谈
You can view this presentation click here: x86_architect
注意使用chrome打开文件 不然可能乱码[……]
MySQL Fabric HA&Sharding solutions
Good news for MySQL HA solutions
Oracle Clusterware is portable cluster software that allows clustering of independent servers so that they cooperate as a single system. Oracle Clus[……]
news in mysqlbinlog – Back Up Master Binary Log Files
news in mysqlbinlog – Back Up Master Binary Log Files
从mysql5.6开始 mysqlbinlog开始支持远程读取master主机的binlog写入本地,极大的加强了binlog的备份策略,由于在mysql cluster复制环境中,b[……]
Multi-Master-Rep in MySQL DB
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
[……]
[SHOUG] 1号店Exadata应用
Download PDF: [SHOUG.LOUISLIU]Exadata在电商的实践[……]