Using a remote mysql server..

[Scan123]

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]

Hello,

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

 

[cPanelMichael]

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:

https://forums.cpanel.net/threads/backup-databases.423632/

Thank you.

 

[Scan123]

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?

 

[24x7server]

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.

 

[cPanelMichael]

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

https://forums.cpanel.net/threads/m...tats-gathering-tool-for-cpanel-server.268011/

Thank you.