howto tunnel out to another MySQL server from powweb

[HongPong]

Hey all,

i am trying to get better performance for my powweb-hosted drupal site by hosting thru my workplace MySQL server. (a friendly boss thank god!)

Basically i got a couple questions: One: is powweb apache allowed to connect out to other Mysql servers?

two: what is the IP address of my powweb apache server? is it the same as the regular name lookup of my site? i feel the answer is obviously yes: 65.254.250.103 = powweb-3.powweb.com = hongpong.com . true?

this is what i am getting on drupal:
Can't connect to MySQL server on '216.67.242.92' (111).
Currently, the username is [deleted] and the database server is 216.67.242.92.

I also was able to allow incoming Mysql connections on the workplace server to whatever IP range i want, and i allowed 65.254.250.103 as well as 65.254.250.% for wildcard. Using the handy cocoaMySql GUI program i verified i can connect from my Mac using the proper logins - after i allowed my mac as a connector.

Why bother? well this workplace server has only about 9 queries/second and is far less swamped than the powweb server @ 300+ queries/second. not to whine but Drupal is too slow laboring among this rate of queries. drupal runs a ton of queries for every page and it just can't respond well at this traffic level.

[tbonekkt]

You will not be able to connect to an external database: http://forum.powweb.com/showthread.php?t=66463

[HongPong]

thanks for your quick answer. i suspected this might be the case. i am feeling there is no way out of this problem. Drupal is too slow on the powweb mysql servers and i want to shift the load to another server. i would think the company would support lightening the load on the 15 mysql daemons, but i can see the security problem as well. i am going to keep in contact with the Powweb staff and keep pestering until i can get connected to a decent mysql server or else get a refund on my web hosting.

the whole point of having paid web hosting is to get reasonable database speed for the price. that is all i want. if powweb can't set up some more daemons i want to put it on another database server. i know one little setting could make my problem disappear, and there it is taunting me as my site grinds away.