I'd use MySQL if its what you know best - it is definately scalable. I like using MySQL to populate Redis (for all reads) since Redis is blazing fast. My last tip is to think horizontal while building your app detailed speed and query based optimizations can always be added.
