Digital Ocean, a preferred VPS internet hosting supplier, just lately introduced a hosted-MySQL platform. The explanations chances are you’ll wish to do use this (vs placing the MySQL occasion on the identical server as your WordPress wed server) are somewhat extra delicate than I wish to get into right here, however suffice it to say you’d get higher scalability however a presumably extra advanced setup. For that purpose, I’m linking to this tutorial on the subject from Mark Drake.
I’ve obtained an curiosity in utilizing this for some syncing of my varied improvement environments. However sufficient about me.
This tutorial does a number of nice issues, however essentially the most fascinating one is that establishing of the database. In some ways, the remaining is a reasonably widespread WordPress set up information. The usage of Apache (vs Nginx) is among the features of that stuff we might have lengthy debates about, however once more I’ll defer that dialogue to different venues and alternatives.