I have a website that is getting enough traffic to cause some issues with performance in our shared account. We would like to move this site only to a new VPS account. This site runs on WordPress.
Can someone explain what I have heard about having a VPS for web and a MySQL VPS? I don’t see anything on the DreamHost site about costs for a MySQL specific VPS.
Does this mean I would need 2 VPS accounts?
Also, how would I go about moving just this single website. We want to keep the others on the shared account.