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.

WHM and remote mysql

Discussion in 'General Discussion' started by upsforum, Jul 22, 2007.

  1. upsforum

    upsforum Well-Known Member

    Joined:
    Jul 27, 2005
    Messages:
    446
    Likes Received:
    0
    Trophy Points:
    16
    In WHM if set a remote mysql server (with Remote mySQL Host Setup option) I can also continue to use the mysql localhost?
     
  2. upsforum

    upsforum Well-Known Member

    Joined:
    Jul 27, 2005
    Messages:
    446
    Likes Received:
    0
    Trophy Points:
    16
    another question: but with SSH port the remote mysql comunication is fast??
     
  3. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    Yes you can use remote and localhost separately without issues. Just point your connection scripts to the proper location.

    As for your second question, I do not understand what you are asking. I will comment that in order to ssh to the remote database, you would need to ssh directly to that server or setup a tunnel.

    You can however, manage the remote location via phpmyadmin on the web server or you can set phpmyadmin to manage your local mysql, however you like to set it up.
     
  4. upsforum

    upsforum Well-Known Member

    Joined:
    Jul 27, 2005
    Messages:
    446
    Likes Received:
    0
    Trophy Points:
    16
    Hi,

    Thank you for your responce, for communication fast I thing if run the queries (SELECT, UPDATE etc..) from remote mysql this is fast?
     
  5. jayh38

    jayh38 Well-Known Member

    Joined:
    Mar 3, 2006
    Messages:
    1,215
    Likes Received:
    0
    Trophy Points:
    36
    Fast? Mysql is Mysql. How fast depends on the server, how heavy the querys and the connection. Best performance will be over a private switch between the web server and mysql server. Best performance would be database replication with master / slave servers for a total of 3 servers.

    Setting up your web server to send insert querys to the master and read querys to the slave would be the ultimate in speed and versatility provided most of your querys are balanced between read and write. Otherwise, a single remote database server would do well over a switch.
     
Loading...

Share This Page