因公司业务发展迅速，部门现在招两个mysql dba 同学，目前本人在平安健康互联网（平安好医生）数据团队，负责数据库的整体规划，想来的同学可以发简历到我的邮箱 ylouis83@gmail.com 靠谱的公司靠谱的团队 ：）
关于公司：
国内最大的互联网医疗平台，提供全品类互联网医疗服务，目前国内前三大的a轮估值[……]
How to backup remote redis instance
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[……]
Linux tools part 11 – Monitoring specified file-IO
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.[......]
TokuDB benchmark on PCIe
MariaDB TokuDB benchmark on FusionIO ,Compare TokuDB and InnoDB engines.
read: TokuDB_benchmark[……]
Talk about some MySQL HA architecture
MySQL-Oslayer-Performance-Optimization
upload on 2014.12
important tips of MySQL database design for better performance
Read : mysql-system-opt[……]
HBASE Performance Test by YCSB
MySQL lost “AUTO_INCREMENT” after a long time
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:[......]
MySQL message subscription system
Introducing MQ system based on MySQL (canal + roma)
Using this system to subscribe message between different platforms.
View this PDF roma_system
Also download this PDF from slideshare[……]
NVMFS Supports Atomic Writes
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.