VMCD.ORG

Focus on DB architect mail:ylouis83#gmail.com

Good news for MySQL HA solutions

Posted by admin on June 9th, 2014


Oracle Clusterware is portable cluster software that allows clustering of independent servers so that they cooperate as a single system. Oracle Clusterware was first released with Oracle Database 10g Release 1 as the required cluster technology for the Oracle multi-instance database,  Oracle[......]

Read more

Tags:
Posted in MYSQL, Oracle Experience | No Comments »

news in mysqlbinlog – Back Up Master Binary Log Files

Posted by admin on May 13th, 2014

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 容灾级别,使[......]

Read more

Tags:
Posted in MYSQL | No Comments »

Multi-Master-Rep in MySQL DB

Posted by admin on May 12th, 2014

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
    -> ;
+------------------+-------[......]

Read more

Posted in MYSQL | No Comments »

linux tools part 9– Monitoring system performance

Posted by admin on April 25th, 2014

淘宝的开源监控工具 –同事推荐安装测下来非常不错 可以配合zabbix进行数据的采集

link:http://tsar.taobao.org/

[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.[......]

Read more

Posted in Unix/Linux | No Comments »

[SHOUG] 1号店Exadata应用

Posted by admin on April 3rd, 2014

Download PDF: [SHOUG.LOUISLIU]Exadata在电商的实践

Tags:
Posted in Oracle Experience | No Comments »

FlashCard Test Detail

Posted by admin on March 5th, 2014

Compare between FIO LSI and VD
Upload on 2014/3/5 by louis liu

Download this PDF

Tags:
Posted in Unix/Linux | No Comments »

MySQL 5.5&5.6 new features summary

Posted by admin on February 10th, 2014

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

Tags:
Posted in MYSQL | No Comments »

IBM will support Flash In DIMM using MCS

Posted by admin on January 17th, 2014

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[......]

Read more

Tags:
Posted in Unix/Linux | No Comments »

MySQL-Oslayer-Performance-Optimization

Posted by admin on January 13th, 2014

upload on 2014.1 [ten important tips of MySQL database design for better performance] Download this PDF

Tags:
Posted in MYSQL | No Comments »

团队合照一张

Posted by admin on December 25th, 2013

团队圣诞合照一张,缺了一个同事,也走了几个同事,往事不堪回首 – -)

IMG_0975

Tags:
Posted in Life | No Comments »