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,727
    Likes Received:
    77
    Trophy Points:
    78
    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:
    42,734
    Likes Received:
    1,706
    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,727
    Likes Received:
    77
    Trophy Points:
    78
    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:
    42,734
    Likes Received:
    1,706
    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. toplisek

    A remote Mysql and Amazon AWS using WHM

    toplisek, Nov 11, 2017, in forum: Database Discussions
    Replies:
    7
    Views:
    310
    toplisek
    Nov 15, 2017
  2. Masimo

    Transfering from old server, using same remote mysql server

    Masimo, Nov 7, 2017, in forum: Database Discussions
    Replies:
    3
    Views:
    199
    cPanelMichael
    Nov 8, 2017
  3. Souther

    MySQL Profiles: user app migration to using remote server

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

    Remote mail using Office 365, plus remotely hosted website

    bloatedstoat, Aug 2, 2016, in forum: Bind / DNS / Nameserver Issues
    Replies:
    3
    Views:
    1,342
    cPanelMichael
    Aug 3, 2016
  5. kjdion84

    SOLVED Gmail "send mail as" using cPanel mail account auth error

    kjdion84, Apr 18, 2018 at 2:12 PM, in forum: General Discussion
    Replies:
    3
    Views:
    40
    cPanelLauren
    Apr 19, 2018 at 6:50 AM

Share This Page