Mysql server to another server.

sreeninair

• February 16, 2014 09:05

Hello Guys, I have a server which is having high load. So I am planning to purchase another serer and use it as my mysql server. Please let me know the procedure. Thanks Sreeni

• 

  dalem

  • February 16, 2014 14:14

  cpanel docs [url=http://docs.cpanel.net/twiki/bin/view/AllDocumentation/WHMDocs/SetupRemoteMySQL]Setup Remote MySQL Server

  0
• 

  cPanelMichael

  • February 17, 2014 17:25

  Hello :) Yes, as mentioned in the previous post, you can find full documentation on using a remote MySQL server at: [url=http://docs.cpanel.net/twiki/bin/view/AllDocumentation/WHMDocs/SetupRemoteMySQL]Setup Remote MySQL Server Thank you.

  0
• 

  sreeninair

  • February 18, 2014 09:53

  Hello Guys, I have configured it successfully. But no database were copied over to remote server. Do I have to manually copy databases to remote server?? . If so let me know the exact steps. Thanks Sreeni

  0
• 

  sreeninair

  • February 18, 2014 14:26

  Hello Guys, I have now rsynced mysql data directory and restarted mysql. The main server is using remote mysql and it is showing in remote mysql server section in whm. Still Mysql is consuming load from main server. The remote server mysql process is very low. Please help me on this. mysql process on main server 4204 mysql 15 0 208m 34m 4256 S 302.4 0.2 1:51.72 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=my mysql process on old server: 10348 mysql 20 0 497m 26m 5788 S 0.0 0.1 0:00.24 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql -- Thanks Sreeni

  0
• 

  cPanelMichael

  • February 18, 2014 16:08

  Could you provide more details about the CPU usage? For instance, what is your server load? Thank you.

  0
• 

  sreeninair

  • February 19, 2014 07:52

  Hello Michael, The load details are pasted below. The mysql is taking the load. How can I confirm mysql is running remotely. Here if I stop mysql in main server the sites will go down. top - 03:47:59 up 203 days, 15:07, 2 users, load average: 2.87, 2.99, 3.10 Thanks Sreeni

  0
• 

  sreeninair

  • February 19, 2014 10:45

  Hello, The main issue is when I stop mysql in main server the sites will show database connection error. Thanks SReeni

  0
• 

  dalem

  • February 19, 2014 13:03

  you have to change your connection strings for all of your scripts to use the remote mysql server

  0
• 

  sreeninair

  • February 19, 2014 15:19

  Hello Dalem, How is this possible?. I have thousands of accounts in the serer. Is their any way other than this ? Thanks Sreeni [COLOR="silver">- - - Updated - - - Hello Dalem, How is this possible?. I have thousands of accounts in the serer. Is their any way other than this ? Thanks Sreeni

  0
• 

  cPanelMichael

  • February 19, 2014 15:38

  You can actually leave your script configuration values in-place. When you setup the remote MySQL server option in WHM, it ensures that MySQL connection attempts to localhost are automatically routed to the remote MySQL server. You should not uninstall MySQL completely from the local machine. Thank you.

  0
• 

  sreeninair

  • February 20, 2014 12:24

  Hello Michael, But when I stop mysql in main server sites will go down. Thanks Sreeni

  0
• 

  cPanelMichael

  • February 20, 2014 15:12

  It's normal to see an active MySQL process when using a remote MySQL server. It should show the hostname of the remote MySQL server. However, feel free to open a support ticket using the link in my signature so we can take a closer look. You can post the ticket number here so we can update this thread with the outcome. Thank you.

  0

Please sign in to leave a comment.