What will be best way to split large database on single site, not multi-site wp installation? HyperDB is maybe for this (just, less than 10 webmasters managed to figure out how to install it, according to active installs).
Currently site has about 350k posts, it is on good VPS. Site is running quite fast in fronted, opening pages, browsings... But it slows down at back-end when publishing new posts, every day lots of new posts are added.
Site has this permalink structure:
sitename.com/year/month/day/postid/post-name Practically just new posts are edited, and once published post are not changed.
Any idea how to speed up database writing, or better, to have published post in one database, and have new database for future posts?
First installation: Is installation in root of site with new database, without old, published posts, just for future posts. Permalink structure is as it was:
Second installation: Created folder "2015" in root of site and installed WP in that folder with sql database of original WP installation from root, with all posts up to end of September, just permalink are changed to:
and it will give the same URL structure as it was (because WP is in sub-folder "2015"):
This approach is working when I need to split database once per year (for example for year 2014). For every past year I can have one folder named by past year and with WP installation in that folder with database with posts of that past year.
That way when visitor try to open URL for example:
server will look first in sub-folder /2014/ and there is WP installation which will return that post.
Problem: When database is too big for current year I tried to split posts from current year into two databases, one have all published posts from this year up to end of September, and another will have future post.
I have this:
In root of site I have folder "2015" with WP installation with permalink structure:
And in root WP installation with permalink structure:
If I try to open URL:
server will check in folder "2015" and WP installation from that folder will return post from 1st September, and it works fine.
If I publish new post today in WP installation in root of site it will have URL like this: sitename.com/2015/10/29/post-name-here
And If I try to open it, server will look in WP installation inside of folder "2015", but that installation have posts just up to end of September, and I get 404. After that server will not look inside WP installation in root of site where that post is.
How to make server look in WP installation inside sub folder "2015", and if there is no post in that installation to look for that post inside WP installation in root of site?