Monthly Archives: April 2010

MySQL Conference 2010 Day 2

Replication Tips – slides Single master can typically handle a few dozen slaves If you have a lot of slaves and want to do filtering for all, maybe use blackhole engine to do filtering in one place. Especially if running blackhole slave on same server to limit network bandwidth. Replicate over WAN – slave_net_timeout, master_connect_retry,… Read More »

MySQL Conference 2010 Day 1

What’s New in MySQL 5.5? Performance Unleashed! – slides Default storage engine is InnoDB (what had been called the InnoDB plugin, but now is the only version). Many locks and mutexes held back scalability in 5.1. Biggest win was fixing uses of LOCK_open. It was used for many things, some of which made no sense. Introduced… Read More »

MySQL Conference 2010

This year’s MySQL Conference was once again jam packed with very technical presentations. Best of all was the news about all the performance and feature enhancements in MySQL 5.5. The benchmark results for the performance improvements were very impressive. After attending this year’s conference, I’m more confident about MySQL’s future than I’ve been for a… Read More »