How to have vBulletin (hosted with ev1) use a database server (that I will setup at..

[mfinc]

How to have vBulletin (hosted with ev1) use a database server (that I will setup at work).

I have my webserver with EV1, but now want to setup a server of my own at work (which will only be used for the database). I want to make it so the webserver will access the server that i setup (through the work router).

Can anyone give me some tips?

[Marco van Herwaarden]

I should start with warning against this. What you are trying to setup would require you to send all DB requests over the public internet to your database server, and the results back to your webserver. This will not only be killing your performance, but will also make all the internal SQL traffic to be added to your bandwidth usage at ev1. It would probably also become Time-Out heaven.

If you want to do it anyway, the basics are pretty simple:
- Change the MySQL config to allow connections from the external (ev1) host.
- Change your includes/config.php to point to the correct hostname or IP-number.

How you can setup your routers at work to allow connections and route them to your MySQL servr, i can not answer, since that depends greatly on the config used at your work.

[mfinc]

I should start with warning against this. What you are trying to setup would require you to send all DB requests over the public internet to your database server, and the results back to your webserver. This will not only be killing your performance, but will also make all the internal SQL traffic to be added to your bandwidth usage at ev1. It would probably also become Time-Out heaven.

If you want to do it anyway, the basics are pretty simple:
- Change the MySQL config to allow connections from the external (ev1) host.
- Change your includes/config.php to point to the correct hostname or IP-number.

How you can setup your routers at work to allow connections and route them to your MySQL servr, i can not answer, since that depends greatly on the config used at your work.
Hi Marco, thanks for your reply!

Would you rather suggest we begin to house our servers on-site (within our own facilities?). We have a dedicated T3 line....we just want to have direct access to the database info.

[Marco van Herwaarden]

I am only suggesting that a webserver and databaseserver, should have a fast connection between them (and normal i would say at least 100Mb), and that you should be aware how the data is routed, so that you will not be surprised by high bandwidth usage. Also if routed over the public network (ie. internet) then you should consider that this is potentionally less secure.

[eva2000]

not advisable.. best is to have both servers connected privately :)

[mfinc]

not advisable.. best is to have both servers connected privately :)
Too bad I can't run a cross-over from Ev1 to work :(

So where would I go about getting such a setup?