Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

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,447
    Likes Received:
    56
    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:
    38,127
    Likes Received:
    1,366
    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,447
    Likes Received:
    56
    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:
    38,127
    Likes Received:
    1,366
    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:
    236
    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:
    822
    cPanelMichael
    Aug 3, 2016
  3. Erik Ellsinger

    See if I am running dnsonly using CLI

    Erik Ellsinger, Sep 21, 2017 at 2:12 AM, in forum: General Discussion
    Replies:
    1
    Views:
    32
    cPanelMichael
    Sep 21, 2017 at 10:27 AM
  4. lorio

    Implications of using NetworkManager CentOS 7?

    lorio, Sep 20, 2017 at 3:52 AM, in forum: General Discussion
    Replies:
    1
    Views:
    35
    cPanelMichael
    Sep 20, 2017 at 6:37 AM
  5. chanklish

    Using AV clamscan question

    chanklish, Sep 20, 2017 at 2:37 AM, in forum: Security
    Replies:
    12
    Views:
    93
    chanklish
    Sep 22, 2017 at 2:50 AM

Share This Page