Planning on using a separate server for MySQL DB

[kirupa]

Hi everyone,
My current server is unable to handle the number of users my forums have at any given time. To help fix this, I've added a new server that will just handle the mysql database.

Now, once I move my database's contents from my current server over to the new server, what do I need to do in order to have my vBulletin installation on my current server recognize that the database is on the new server altogether?

I searched but couldn't find any information on this.

Thanks,
Kirupa

[Lynne]

You will need to enter the IP and database information for this server in your config.php file:

    //    ****** MASTER DATABASE SERVER NAME AND PORT ******
    //    This is the hostname or IP address and port of the database server.
    //    If you are unsure of what to put here, leave the default values.
$config['MasterServer']['servername'] = 'xxx.xxx.xxx.xxx';
$config['MasterServer']['port'] = 3306;

    //    ****** MASTER DATABASE USERNAME & PASSWORD ******
    //    This is the username and password you use to access MySQL.
    //    These must be obtained through your webhost.
$config['MasterServer']['username'] = 'databaseusername';
$config['MasterServer']['password'] = 'databasepassword'; 

If you have a Slave Configuration, then there is a spot for that info also in the config.php. For me, the only lines I had to change were the ones above. If you have a direct connection between the two servers (a Gig-E connection?), then your IP would probably be one like 192.168.x.x