Hosting your database on a dedicated server can be a good idea if you can afford to rent two servers. The upsides of a separate database server include a boost in performance as your website and database are using independent resource pools and better security as your database will be safe if your website server is compromised and vice versa. But the downside is the cost of renting two different servers which can put a hole in your pocket.