WordPress database scalability from the code perspective

If INT is set to UNSIGNED, allowing only non-negative integers, your value range is from 0 to 4294967295. Thats… 4,294,967,295 (4 billion +). …for the given table. Just to put things into perspective. Only through poor management and unnecessary incrementation would you exhaust that range, say for your posts table as an example. That said … Read more

How to run WordPress across 2 VMs for high availability

The Bad News: The core open source base of WordPress does make quite a few assumptions about being run on a single server (wp-content, user uploads and media library to name a few) The Good News: Pretty much all cloud providers (including Azure) have abstractions that allow you to work around these design limitations. Fundamentally, … Read more

What are the best practices for using a caching plugin on a shared host?

On shared hosting plans your caching options are limited. You will only be able to statically cache the html output from your pages. This is the fastest way to serve pages but you loose the dynamic aspects of WordPress like making comments and seeing the latest comments on posts. There are disk caching options available … Read more

Azure WordPress and Scalable WordPress

Basic differences: Media is stored in a separate storage account and MySQL database is automatically scalable using ClearDB (master-master replica). Regular WordPress is single site single database only. For performance critical scenarios, scalable wordpress will handle a lot more concurrent requests. It also provides contingency.