My site is focused on gaming news and tips & tricks. Recently I had an issue where my hosting provider told me my site was using a lot of resources on the shared server. After a database cleanup everything is fine, but I am a bit worried how much time will it take until I have to move to a bigger hosting solution.

1. How do big news website deal with this?

2. Is there a way to have multiple small databases to load my wordpress content?

Thanks!