Announcement

Collapse
No announcement yet.

Planning on using a separate server for MySQL DB

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Planning on using a separate server for MySQL DB

    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

  • #2
    You will need to enter the IP and database information for this server in your config.php file:
    PHP Code:
        //    ****** 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

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools <- awesome site for html/css help

    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X