WordPress Development Stack Exchange is a question and answer site for WordPress developers and administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Is it possible for Wordpress to work from two databases?

The reason I ask is that we're approaching our 100mb limit for database size on our host (1and1) but have up to 100 databases, so what I was hoping to do is essentially 'add on' another database for when the limit is reached?

share|improve this question
up vote 3 down vote accepted

Yes, but that is out of quick and easy realm.

See HyperDB in Codex and repository for starters.

share|improve this answer
Do you know if it will split a table at all as the bulk of the database is taken up by the posts table. – Vince Pettit Mar 4 '11 at 16:04
@Vince Pettit sorry, no hands-on experience with it. It's what wordpress.com uses so is usually first thing to point at. – Rarst Mar 4 '11 at 16:16
Brilliant, thanks for the info, been reading up on it and seems to do what I want... will give it a try and take it from there! – Vince Pettit Mar 4 '11 at 16:21

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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