You should be able to on a standard shared host presuming its not extremely resource intensive, and the host has remote MySQL access enabled. Alternatively there should be a few dedicated MySQL providors available, I reccomend a WHT search
BeeServe * Rock solid shared & reseller UK webhosting. No downtime™ * Now offering fully managed VPS servers
you can buy a cpanel based shared hosting account with any provider..and then in your cPanel->MySQL you can add your other server's IP in Access List... so that should allow you to connect it remotely.. still confirm with your host before buying..
This is be a good idea but remember you will then need to have two servers up and communicating properly for your site to work ..also this will increase your bandwidth consumption.. do all the calculations before you make a decision.. and make sure you go with a good host or else your site could fill up with 'Cant connect to MySQl host' errors
I'm hosting a site thats pushing ALOT of mysql, and wondering if i could outsource the mysql queries to another specialized host, and sugestions please ?
And shared not dedicated
You are only going to want to do this if the server doing the mysql and the server handling the web are on the same network, otherwise your request times are goign to go through the roof -
User -> Web server -> Mysql -> Web server -> Mysql -> Webserver ..repeat as required.. -> User
Are you sure that it's really the quantity of requests thats causing the mysql load? Have you looked into creating appropriate indexes on the data - a well designed index can reduce loads many hundreds of times, I've seen queries go from minutes to milliseconds with just the addition of a proper index.