As people are getting back from vacations and application traffic is going back and hitting database backend hard, it is a good time to think about performance and prepare for the winter holiday spike. Whenever you are on-premise or in the cloud, questions are the same:
- Are we satisfied with the current MySQL performance?
- How much traffic are we currently serving?
- Is there enough capacity to stay stable as traffic increases?
- What would be the best way to stay cost-effective as we grow?
Unfortunately, the answers are not so obvious and require a thorough performance analysis. However, there is a chance that your problem has already been solved by someone else. I do not mean StackOverflow (which is a beautiful place, by the way), but some higher level questions which people usually discuss at conferences, and we have several of them ongoing or just a couple of weeks away.
…
[Read more]