Using a remote mysql server..

Scan123

Member
Aug 5, 2015
6
0
1
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!
 

Scan123

Member
Aug 5, 2015
6
0
1
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?
 

24x7server

Well-Known Member
Apr 17, 2013
1,911
98
78
India
cPanel Access Level
Root Administrator
Twitter
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.