I gave a lightning talk on MySQL Innodb and how realestate.com.au
configures their databases to the DevOPS
Melbourne meetup last night.
My slides can be found here.
Simply some take aways are
- Use Innodb for everything (unless another engine is appropriate)
- Having the working set in bufferpool makes MySQL Innodb fast by eliminating those foreground randrom reads of tablespace
- Use a RAID controller with BBU and write back cache for transactional log performance
Thanks To Evan Bottcher for owning and organising the
meetup!