I have a very big WordPress site and I am facing speed issue and server resources issues. Specially numbers of MySQL records are so high. So, I want to split the big WordPress site into multiple small sites.
I have URL structure like this
- http://siteurl.com/this-is-first-post.html (category1)
- http://siteurl.com/this-is-second-post.html (category2)
- http://siteurl.com/this-is-third-post.html (category1 and category2)
I want to separate the WordPress according to category, I am thinking about two solutions
- Either I create two DBs for each categories, e.g.
db_cat1
anddb_cat2
and I divide the data using some logic. -
Or I create subdomains and install different WP instances like this:
My questions are:
- If I try the first logic, then how can I divide the databases into different categories db?
- If I try second logic, then how can I manage the URL structure and keep SEO juice there? How can I divide the common tags and categories?
- How I will manage resources such as image etc after splitting the WordPress?
- Is there any better way to do this job?
I don’t want change the server or work on server because I already tried different types of server and all servers have the MySQL resources issues. I prefer second logic because it is easy to handle.