要面个广告公司, job description如下
Mysql query performance analysis.4+ years RDBMS experience working in a high
volume production environment.
MySQL 5.x (InnoDB and MyISAM engines)
MySQL replication (Master-Master, Master-Slave ) and sharding.
Experience/familiarity with Percona toolkit for backup, restore , online
schema change.
Develop tools for db monitoring, collect and analyze performance metrics.
Expertise in Ruby, Python preferred.
Familiarity with configuration management tools like Puppet.
1. replication,我们公司太小了,目前production db server 就一个machine,没有
replication. 我能说我用过吗?还是要实话实说
2. percona toolkit,没有用过,能扯用过吗?
3. develop tool for db monitoring,collect/analyze performance.什么tool啊?
谁能给点提示吗
4. configuration management tool like puppet,有人用过吗?
5. 怎么恶补performance analysis?