My Drupal site is an aggregated site.
Through out the years, my drupal database has built up quite a large database (>500mb). node_revision is the table that has the most data.
Is there a way to separate the nodes into different databases in order reduce the size of my drupal database?
The aged nodes are still valuable thus deleting them is not an option.
I have thought of using multisite module to move the aged nodes to another database. But this approach doesn't work in my case since my nodes still have to interact with each other in certain level.
Thank you for reading.