Seperate sql server

Discussion in 'Databases' started by SyndicateHosting, Mar 29, 2010.

0
  1. #1
    I have huge forum that needs to be split, how should I go about having a seperate server just for mysql requests.
     
    SyndicateHosting, Mar 29, 2010 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    How is your site being hosted?

    Basically you want a 10/1000 or better connection directly between the 2 servers. Then once your existing database is migrated to the new server, you just specify in your software to connect to the remote server rather than localhost.
     
    jestep, Mar 30, 2010 IP
  3. nabil_kadimi

    nabil_kadimi Well-Known Member

    Messages:
    1,065
    Likes Received:
    69
    Best Answers:
    0
    Trophy Points:
    195
    #3
    You'd better speak with your host, if they're good, they will suggest a better plan for your needs.
     
    nabil_kadimi, Apr 2, 2010 IP
  4. maestria

    maestria Well-Known Member

    Messages:
    705
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    110
    #4
    you just need to create the database on a remote server and then on the area where your sites are hosted and the config file, using which you are trying to connect the database, instead of localhost, put the ip address of the remote host.
    And then in the remote host, provide a grant all privilege to that database for the ip of the hosting domain.
     
    maestria, Apr 3, 2010 IP
  5. fifo

    fifo Peon

    Messages:
    31
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    ...and if your database is really huge make sure the new server is with lots of RAM
     
    fifo, Apr 18, 2010 IP