VPS Host Database – Shared Hosting Hosts Files

  • I currently have a VPS which I have tested and it is super fast, I also have a Shared Hosting account which is slow but has a lot of space and bandwidth compared to the VPS Hosting.

    My question is, does anyone here have knowledge if I can have Mysql Database hosted on the VPS and have ALL WordPress Files + Content and Uploads on the Shared Hosting Account?

    Reason for this is the Shared Hosting account limits the MySql Queries and when it hits the limit, it slows down those queries. If I have the Database in the VPS hosting, I believe that all Queries will be handle there which is Unlimited.

Viewing 3 replies - 1 through 3 (of 3 total)

  • Sure, configure MySQL on the VPS to allow external database connections and then use those configs – database, user, password, IP – in the wp-config.php file on the shared host. Google “remote database connection mysql”

    Thread Starter Scholarty

    (@scholarty)

    Hi Songdogtech,

    Thank you for your quick reply. By having the remote MySql, do you think it will definitely reduce Queries on the shared hosting site? Since I do not have experience with this, I cannot say and have tried to read up on this.

    My Shared Hosting support said that this would be pointless as it still uses the same amount of Queries on the Share hosting site.

    Thanks

    My Shared Hosting support said that this would be pointless as it still uses the same amount of Queries on the Share hosting site.

    If you’re not using the database at the shared host, you will reduce the load on them. Not completely, but substantially. Try it and see.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘VPS Host Database – Shared Hosting Hosts Files’ is closed to new replies.