The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Two webservers to one mySQL server

Discussion in 'General Discussion' started by ttremain, Oct 27, 2008.

  1. ttremain

    ttremain Well-Known Member

    Joined:
    Feb 16, 2003
    Messages:
    212
    Likes Received:
    0
    Trophy Points:
    16
    I currently have a single web server (cPanel,) connected to a 64 bit mySQL back end server. This was setup as a remote mySQL server, using WHM.

    All communications between webservers and mySQL server will take place on private network using private NICs (192.168.100.*)

    This services about a dozen domains, in just a couple cPanel accounts (Several parked and add-on domains) and about 12 databases (and growing.)

    For load balancing reasons we wish to add a second Apache server that will duplicate the files in two of the accounts from the main server using rsync.

    The second webserver will never be used for creating databases, just basic access via custom PHP application.

    Connections are simple,
    host: sqlhost
    username: <cpuser>_someuser
    database: <cpuser>_dbuser

    What is the best way to configure the second webserver to the mysql server without complicating authentication?
     
  2. SB-Nick

    SB-Nick Well-Known Member

    Joined:
    Aug 26, 2008
    Messages:
    134
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Hello,

    If you will be still using just one db server I do not see any Auth complication while setting up this.
    Just make sure you allow newserver ip's on every cpanel mysql user.
     
  3. ttremain

    ttremain Well-Known Member

    Joined:
    Feb 16, 2003
    Messages:
    212
    Likes Received:
    0
    Trophy Points:
    16
    Is this a specific step I need to take or command I need to run?

    Thank you!
     
  4. SB-Nick

    SB-Nick Well-Known Member

    Joined:
    Aug 26, 2008
    Messages:
    134
    Likes Received:
    0
    Trophy Points:
    16
    cPanel Access Level:
    Root Administrator
    Actually, yes.
    If you browse around there are tons of posts explaining how to allow a mysql user to connect remotely from a outside location (not from inside the server).
     
Loading...

Share This Page