we use tcpcopy to make real traffic on our core systems. Many problems will be found in advance if we enlarge queries several times.
Read this PDF TCPCOPY[……]
June 29, 2016 Architect, Architecture, hardware, MYSQL, network No comments
May 29, 2016 Architect, Architecture, hardware, MYSQL, performance No comments
Sandisk (FusionIO) and Nexenta are working together to build this SDS solution.
Infiniflash is a very large SDS production, which manages for very large DW system who requires large storage space and also high IOPS.
We test infiniflash system ,read this Infiniflash_benchmark[……]
April 12, 2016 Architect, Architecture, hardware, MYSQL, replication, software No comments
Based on messages, we create mysql replication platforms , using async message to build strong distributed subscription system.
read this PDF : http://www.vmcd.blog/docs/MySQL_async_message.pdf[……]
February 1, 2016 Architect No comments
因公司业务发展迅速，部门现在招两个mysql dba 同学，目前本人在平安健康互联网（平安好医生）数据团队，负责数据库的整体规划，想来的同学可以发简历到我的邮箱 ylouis83@gmail.com 靠谱的公司靠谱的团队 ：）
关于公司：
国内最大的互联网医疗平台，提供全品类互联网医疗服务，目前国内前三大的a轮估值[……]
January 29, 2016 Architect, NoSQL, redis No comments
We wrote a python scripts to control redis backup work.
Three Steps to do this work:
1. Create meta database to store which redis instance needs to backup
2. Use scripts to connect to these redis instances with “–rdb” command (remote backup command)
3. Estimate which redis server should[……]
December 28, 2015 system No comments
We could use inotify-tools to monitor file or directory IO state
yum install inotify-tools
#inotifywait -m /storage/sas/mysql3306/data/diablo_im/#sql-ib4747-2643139248.ibd
Setting up watches. Watches established.[......]
October 21, 2015 Architect, Architecture, hardware, Internals, MYSQL, performance No comments
MariaDB TokuDB benchmark on FusionIO ,Compare TokuDB and InnoDB engines.
read: TokuDB_benchmark[……]
October 8, 2015 Internals, MYSQL, rdbms No comments
Description:
I create a empty table and then alter this table's "AUTO_INCREMENT" starts from 10000000.After a long time ,MySQL lost "AUTO_INCREMENT" definition when I show this table again. MariaDB has the same problem but Percona Server is fine.
$mysql06
Warning:[......]
September 6, 2015 Architect, hardware, Internals, MYSQL No comments
Benchmark for NVMFS (supports atomic writes ,so we can close double-write option on specific MySQL version )
tips: some Flash-based cards could support large block map , the main idea is to avoid fractured page writes.
August 24, 2015 Internals, linux, MYSQL, rdbms No comments