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

Discussion in 'Database Discussions' started by arjanvr, Feb 11, 2015.

  1. arjanvr

    arjanvr Well-Known Member

    Joined:
    Dec 13, 2013
    Messages:
    58
    Likes Received:
    1
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    Hello,

    After consulting with ticket support my i/o is high due to mysql. I want a different server with ssd instead of regular hdd and run my mysql database there. If this is in another country, would this affect performance or might ssd make up for this?
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    The connection speed between the servers might have some effect on it's performance, but it's really difficult to know until you implement it. You may find the following document helpful:

    Setup Remote MySQL Server

    Thank you.
     
  3. arjanvr

    arjanvr Well-Known Member

    Joined:
    Dec 13, 2013
    Messages:
    58
    Likes Received:
    1
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    I will have a SSD added to my current machine, moving mysql there must be an improvent over the current HDD. Will cpanel be able to help me move it to a different drive in the same machine or is this the same as moving it to a remote location?
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
  5. arjanvr

    arjanvr Well-Known Member

    Joined:
    Dec 13, 2013
    Messages:
    58
    Likes Received:
    1
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    Moving inside the server to ssd would be a huge improvement I hope?
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    654
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    It's possible, but we can't really predict how much of an improvement you will see. It's typically a good idea to consult with a qualified system administrator or a MySQL specialist if you want details on how much of an improvement you will see with your particular hardware and usage.

    Thank you.
     
Loading...

Share This Page