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?

1 Answer 1


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

See HyperDB in Codex and repository for starters.

  • 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 P
    Mar 4, 2011 at 16:04
  • 1
    @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, 2011 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 P
    Mar 4, 2011 at 16:21

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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