Articles of hyperdb

Is it possible to split database tables using HyperDB?

I’m looking for an answer from someone who’s implemented HyperDB or has knowledge of it. I have a database which has just passed the 100mb mark a week or so ago, the problem is my host only allows databases of 100mb a time. I was looking to implement HyperDB but wanted to find out some […]

Doing a loop with multiple DBs simultaneoulsy

I have a website setup made up of with more than 3-4 WordPress setups as subdirectories of main. For example: Site | ———- Site/Site1 | ———- Site/Site2 | ———- Site/Site3 Each have separate codebase, separate DB for itself. The Database server is one and the host directory is also one. Basically we can say these […]

How to use hyperdb to separate and share a user dataset between wordpress installs?

I’m looking for a way to separate my users and usermeta table to be in a different database than my main WP install. The end goal is sharing these table over a number of WP installs. From what I read, HyperDB should allow for this, however their documentation is a little sparse when it comes […]

Built to scale, or worry later?

I’m starting a service that offers websites that runs on a giant WordPress multi-site. I have a cloud based vps with nginx-php5-php-fpm-mysql. Storage with Amazon S3, distribution with MaxCDN. WP Total cache takes care of this for WP. I do expect to be busy from the start as far as the number of sites created. […]

MySQL Replication Latency Issues in wp-admin pages

I have an environment running WP 3.0.1 with a Master db and two slaves. I am using HyperDB to force all writes to go to the Master, and all reads to read from the two slaves. I am experiencing a variety of issues in wp-admin pages where data is being written to the master, and […]