What is best configuration settings for Wordpress and MySQL on Win2008 + IIS7 stack?
- by holiveira
I currently have four blogs that uses Wordpress running on a shared hosting company. This blogs have a considerable amount of visits and I'm constantly receiving warnings from the hosting company saying that I'm consuming too much server CPU.
Considering the fact that I have a dedicated server in another company with plenty of idle resources (it has a quad core Xeon 2.5GHz and 8GB of Ram and run on Win2008) I'm planning to move the blogs to this server in order to have some more freedom. I'm currently using this server to host some web applications using ASP.Net and SQL Express.
I've installed a blog to test and it worked fine, but some issues appeared and raised some questions in my mind:
How to properly set the permissions in the folders used by wordpress plugins, I mean, what permissions should I set for the IIS_User in some folders so that the plugins works correctly?
What's the best caching plugin to use considering this is a Window Server? In the previous hosting company I used the WPSuperCache, but it was a Linux Stack.
Or should I ignore the caching plugins and use the Dynamic Caching Feature of IIS7?
How can I optmize the MySQL server running in this server (specially the settings regarding memory and caching)
How can I protect the admin folders against hacker attacks?
I know some people will advice me not to run Wordpress in a Windows stack, but that's my only choice. I don't even know were to start managing and LAMP stack, don't have the time to do so nor the money to rent another server.