Consulting
I am available for MySQL consulting. I have worked on both small and large projects, working with hundreds of GB of data in a high traffic environment (hundreds to thousands of queries per second). Take a look at my resume for details. I am also available for Solr consulting.
- Performance Tuning
- Schema Audit and Optimization
- Creating new databases based on existing specifications
- Backup Strategy
- Integration with Search (Solr, Sphinx)
- Migration to MySQL
- MyISAM to InnDB Migration
- Upgrading MySQL Server
- Integration with Memcached
I’ve been involved with these major projects:
- answerbag.com
- Over 100GB of data
- 1 million pageviews per day
- Peak traffic at 100 pages / second
- Largest table holding close to 1 billion rows
- Solr integration
- Handled all architecture
- airliners.net
- Migrated search from database (8 servers) to solr (2 servers).
- Fixed architecture issues
- livestrong.com
- Largest table holding over 500 million rows
- Over 1 million pageviews / day
- nflrush.com
- Diagnosed several performance issues related to database schema and query construction
- mania.com
- Diagnosed several performance issues related to database schema and query construction
- automd.com
- Multi-core solr integration
- Geo coding search using localsolr project.
Please contact me at jon at jonhaddad.com for further information.
MySQL and InnoDB are trademarks of Oracle Corporation.
