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[……]
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.[......]
MariaDB TokuDB benchmark on FusionIO ,Compare TokuDB and InnoDB engines.
read: TokuDB_benchmark[……]
upload on 2014.12
important tips of MySQL database design for better performance
Read : mysql-system-opt[……]
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:[......]
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[……]
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.
