My client requested quite a specific solution for his WP based wordpress (single site, not multisite). Basically what he wants is, let's say after 1000 posts new database should be created (with 5 tables only, posts, postmeta and 3 taxonomy related tables) and new posts should be stored in this one along with all post meta, until it reaches 1000 posts and then process repeats.
Challenging part is, all these databases have to be active at the same time, so WP should be able to access posts from main db and all these newly created databases (with 5 tables) at the same time. This could probably done with hyperdb. Questions are:
- How do I tell wp which database to save posts to?
- Is this even doable to begin with?
- If so, can it be done without modifications to WP core?