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.

Remote MYSQL question

Discussion in 'General Discussion' started by cwalke32477, Oct 10, 2011.

  1. cwalke32477

    cwalke32477 Well-Known Member

    Joined:
    Mar 2, 2010
    Messages:
    94
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Atlanta, Georgia
    cPanel Access Level:
    Root Administrator
    This is probably quite the "n00b" question; if I activate remote mysql on a production server, will it automatically move the sql databases off the main server, and onto the new remote sql server?
    I'm looking for ways to reduce disk i/o one of my older servers, and it seems that MySQL is responsible for most of the i/o wait.
     
  2. milind

    milind Well-Known Member

    Joined:
    Jan 15, 2006
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Nasik (Maharashtra), India
    cPanel Access Level:
    Root Administrator
    Hello,

    I don't think that enabling Remote MySQL will automatically move your databases from current server to another. You have to manually do that (someone from cPanel please confirm this.)
     
  3. cwalke32477

    cwalke32477 Well-Known Member

    Joined:
    Mar 2, 2010
    Messages:
    94
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Atlanta, Georgia
    cPanel Access Level:
    Root Administrator
    Please cPanle, can you confirm this? I can;t find any documentation on the process.
     
  4. nobodyk

    nobodyk Well-Known Member

    Joined:
    Aug 1, 2010
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    6
    I'm not cPanel, but remote mysql means that your MySQL can be access remotely. By default mysql does not allow remote connections. Your MySQL server will not move its data, enabling remote access is just that - enabling remote access. If you're having IO issues your best bet is to configure my.cnf

    Have a look at mysqltuner to help you determine the optimal values for your setup. It's mostly that you don't have a good configuration on mysql.
     
  5. cwalke32477

    cwalke32477 Well-Known Member

    Joined:
    Mar 2, 2010
    Messages:
    94
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Atlanta, Georgia
    cPanel Access Level:
    Root Administrator
    I've already run mysqltuner and optimised my.cnf
    This is a reseller server, and it's just getting loaded a bit.
    Rather than create a new server, and purchase double licenses on everything, I can setup a remote server for handling the MySQL, and drop the loads in half, all transit between the two servers would be through gigabit channels on an internal network.

    See WHM >> Main >> SQL Services >> Setup Remote MySQL server
    That is the remote MySQL I am referring too, not the ability to connect to the local MySql remotely.

    As cPanel states it...
    So the question still remains...
    Will setting this up allow me to automatically migrate the existing clients MySQL DB's, within the WHM interface, to the remote server, or would this have to be done manually?
     
    #5 cwalke32477, Oct 12, 2011
    Last edited: Oct 12, 2011
  6. minosjl

    minosjl Well-Known Member

    Joined:
    Jun 4, 2011
    Messages:
    168
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hi bro,

    I don't this there is an option to automatically move the MYSQL databases in to your remote server having MYSQL service.I think you need to configure this manually on your server.I think you can achieve this by MYSQL replication option .There are lots of docs are available in order to do that. You can configure your cpanel server as master and your remote server as slave .

    Yo can also configure your master server as writing the MYSQL data's and execute the MYSQL queries in the slave server a type of load balancing.
     
Loading...

Share This Page