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.

Using a remote mysql server..

Discussion in 'Database Discussions' started by Scan123, Aug 5, 2015.

  1. Scan123

    Scan123 Member

    Joined:
    Aug 5, 2015
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    netherlands
    cPanel Access Level:
    Website Owner
    Hello,

    My wordpress sites are growing fast and my server is doing more and more cpu usage cause of a lot of the heavy mysql usage.

    Now i've setup another server wich i want to use mainly as my mysql database server.

    I allready have setup "Remote MySQL Server" in whm.

    My question is do i now also need to copy my mysql db's from 'local' to the remote server?

    If so how and where do i copy them too?

    Thank you very much!
     
    #1 Scan123, Aug 5, 2015
  2. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,352
    Likes Received:
    49
    Trophy Points:
    28
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Hello,

    You need to migrate your all databases from your cPanel server to mysql server. You can migrate your all databases through mysqldump command.
     
    #2 24x7server, Aug 5, 2015
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    36,294
    Likes Received:
    1,209
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    #3 cPanelMichael, Aug 5, 2015
  4. Scan123

    Scan123 Member

    Joined:
    Aug 5, 2015
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    netherlands
    cPanel Access Level:
    Website Owner
    seems like i got it working. Im now connection to the db's on the remote mysql wich made my local host's load reduce like 40%. The problem however is that when I let my biggest site use the remote mysql host mysql is getting really really slow even tho load on remote is only around 1 then. for example wp-admin takes time to load and sometimes doesnt even load. what can cause this problem?
     
    #4 Scan123, Aug 6, 2015
  5. 24x7server

    24x7server Well-Known Member

    Joined:
    Apr 17, 2013
    Messages:
    1,352
    Likes Received:
    49
    Trophy Points:
    28
    Location:
    India
    cPanel Access Level:
    Root Administrator
    Are you using private network to contact your MySQL server from web server ? If not, then I will suggest you please setup remote mysql with the private network so that you will not get this issues.
     
    #5 24x7server, Aug 8, 2015
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    36,294
    Likes Received:
    1,209
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    #6 cPanelMichael, Aug 10, 2015
(You must log in or sign up to post here.)
Loading...
Similar Threads - Using remote mysql
  1. Souther

    MySQL Profiles: user app migration to using remote server

    Souther, Jun 21, 2017, in forum: Database Discussions
    Replies:
    6
    Views:
    126
    Souther
    Jun 22, 2017
  2. bloatedstoat

    Remote mail using Office 365, plus remotely hosted website

    bloatedstoat, Aug 2, 2016, in forum: Bind / DNS / Nameserver Issues
    Replies:
    3
    Views:
    681
    cPanelMichael
    Aug 3, 2016
  3. gsusonline

    Trouble using install_ssl via api

    gsusonline, Jul 18, 2017 at 5:45 AM, in forum: cPanel Developers
    Replies:
    3
    Views:
    52
    cPanelMichael
    Jul 20, 2017 at 10:16 AM
  4. intuitivsol

    Two servers using the same domain name

    intuitivsol, Jul 17, 2017 at 11:17 AM, in forum: Bind / DNS / Nameserver Issues
    Replies:
    3
    Views:
    40
    cPanelMichael
    Jul 18, 2017 at 11:10 AM
  5. tecwithquestion

    Run php code in Paper lantern using .html.tt

    tecwithquestion, Jul 17, 2017 at 9:34 AM, in forum: User Experience
    Replies:
    1
    Views:
    49
    cPanelMichael
    Jul 17, 2017 at 2:26 PM

Share This Page