news in mysqlbinlog – Back Up Master Binary Log Files
从mysql5.6开始 mysqlbinlog开始支持远程读取master主机的binlog写入本地,极大的加强了binlog的备份策略,由于在mysql cluster复制环境中,binlog的存在极大的决定的数据恢复的完整性，所以binlog的备份显得特别重要。在诸多HA方案中,例如MHA,使用主库的binlog去恢复主备库之间的数据差,在主库物理机器down机无法重启的情况下,binlog的备份可以直接用来recover slave.所以这一特性提升mysql 容灾级别,使[……]
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
from one master machine create new db and insert one record:
23:44:55 (none)> show master status
-> ;
+------------------+-------[......]
淘宝的开源监控工具 –同事推荐安装测下来非常不错 可以配合zabbix进行数据的采集
[mysql@mysqldb tmp]$ tsar Time ---cpu-- ---mem-- ---tcp-- -----traffic---- --sda--- ---load- Time util util retran bytin bytout util load1 24/04/14-22:30 1.19 64.[......]
Download PDF: [SHOUG.LOUISLIU]Exadata在电商的实践[……]
upload on 2014.2 [MySQL 5.5&5.6 new features summary] Download this PDF[……]
The next generation of IBM’s X-series servers will be able to accommodate solid-state Flash drives clipped into their DIMM memory slots, potentially improving the response times of fast-paced enterprise applications.
On Thursday, IBM unveiled the Series 6 generation of its System X x86-based serv[……]
update 12.14 (add two docs) Download this PDF
overview of gc_doc2
[……]
UPDATE 12.2: you can download complete PDF from database design of YHD[……]
