Our team is going to publish game in social networks. Expected DAU is about 100k, which is about 500 concurrent connections and 100-400 transactions\sec. Our main risk is the game-database server(Windows Server 2008 using MySQL) because it would handle most of the load. As player enters game server SELECTs his gamestate and caches it in memory. After it most queries will be simple UPDATEs. No complex queries are planned.
So we've stumbled upon game-database configuration questions:
1) Is CPU much important for game-database server? Would 1 Intel Xeon E3-1230(or 1270) be enough for us?
2) Is RAM much important for game-database server? Would 24-32gb DDR3 RAM be enough for us?
3) Is SSD much better than HD in terms of game-database server?