0

I'm implementing a wordpress on Microsoft Azure on a subfolder (something like http://domain.com/blog)

All the servers are on a Windows,

I did a workaround using an external server for the mysql and allocated the php stuff on a subfolder with php.

The problem is that this is extremely slow because it has to go from one server to another.

I checked the option of using wordpress with sql server but it doesn't work with the plugins that we use,

And I also tried this solution https://blog.kloud.com.au/2014/11/27/installing-wordpress-in-a-sub-folder-on-azure-websites/ but clear is expensive for a blog.

We can't use subdomains like http://blog.domain.com for a policy issue of the company.

I created a virtualmachine with the bitnami image, and would like if it's possible to use it as a "folder" with some magic trick, or something like cloaking on azure.

closed as unclear what you're asking by Reaces, womble Jul 9 '16 at 2:14

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • MySQL on another machine shouldn't be particularly slow, unless there's something wrong with your network. MySQL can be installed on Windows no problem at all. I don't really understand the problem you're having, this seems trivial. – Tim Jul 4 '16 at 19:59
  • I don't understand the premise... Why don't you just provision a MySQL server on Azure? Or are you saying the connection between your Azure webserver and your MySQL is slow? In which case... Did you provision them in the same region? – Reaces Jul 4 '16 at 20:34
  • it's not windows, it's a microsoft azure server, you can't put mysql without paying extra's and we are already above 10k a month on servers wich is our limit @Tim, the other server is on dreamhost, and the loadtime can be sometimes up to 10 seconds which blocks the access – Saikios Jul 4 '16 at 20:52
  • @Reaces that mysqlserver cost more than the budget that we have for the blog, it's min 50 dols a month just for the database, the problem is that we are trying to figure out how to put it on the same domain, I checked some documentation and there are workarounds like what I did on the vm, but the php has to be on the subfolder which makes it slow for excel, etc – Saikios Jul 4 '16 at 20:56
  • So what you're saying is your problem has a solution, you just can't afford it? I'm afraid sometimes that's just the way it is. Not everything can be replaced by cheaper components and keep its performance up. – Reaces Jul 4 '16 at 21:01
1

Putting MySQL on a server outside your data center is going to introduce significant latency. You need to put your database in the same data center as your app server. The problem here is your budget, which has affected your deployment architecture.

The smallest AWS Linux instance can run a good sized blog, especially if you do caching (eg Nginx page caching). I imagine Azure is similar. Based on the comments below I think you have four solutions:

  • Architect this properly - ie get a VM, install everything, and get it running
  • Pay for a database
  • Drop the plugins that don't work
  • Set up some kind of a page cache. If you have a predefined system you may not have that option. If you have users logged in a lot it won't help them. If your site is mostly anonymous users then page caching can increase performance as the request doesn't even hit Wordpress, let alone the database. I use page caching in my Wordpress tutorial and it improves performance by a couple of orders of magnitude.
  • Hi @tim the technical problem would be how to use vm as a folder domain, if there is any way to do it – Saikios Jul 5 '16 at 0:44
  • What is an "Azure Server"? Does it have an operating system you can install things on? – Tim Jul 5 '16 at 1:09
  • 1
    @Tim In his case it does. If for Azure you see something like the above mentioned I created a virtual machine with the *** image it is an image offered by a publisher with a machine with pre-configured installation. Otherwise it would be an Azure App/Web Service. – Reaces Jul 5 '16 at 6:16
  • Ok, then the problem is both financial and that it's been poorly architected. The solution is to do the job properly. – Tim Jul 5 '16 at 9:07
  • @Tim thanks a lot for your answer, except for the extra database (budget problem) is what I have :), A vm running with mysql, I have only the plugins that work, I have a cache activated on wordpress and a plugin; the issue is that I wanted to have everything on the same server and just use a cloaking or something of the kind without affecting the seo – Saikios Jul 5 '16 at 12:51

Not the answer you're looking for? Browse other questions tagged or ask your own question.