Using a remote mysql server..

Scan123

• August 05, 2015 06:12

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!

• 

  24x7server

  • August 05, 2015 12:18

  Hello, You need to migrate your all databases from your cPanel server to mysql server. You can migrate your all databases through mysqldump command.

  0
• 

  cPanelMichael

  • August 05, 2015 13:39

  Hello :) Yes, you must copy over the local databases to the remote MySQL server. The following thread offers some instructions on how to do this:

  0
• 

  Scan123

  • August 06, 2015 20:10

  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?

  0
• 

  24x7server

  • August 08, 2015 10:59

  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.

  0
• 

  cPanelMichael

  • August 10, 2015 17:09

  You may also want to consider running a MySQL tuner for the remote MySQL server and see if any optimization is possible:

  0

Please sign in to leave a comment.