Unloading/Migrate MySQL to a separate VPS

pauloray

• August 26, 2014 01:58

My current Cpanel VPS has MySQL in a single machine. Due to high load, I want to unload mySQL and put it on a separate VPS, dedicated to MySQL. How do u migrate all MySQL data to a separate server so that there will be minimal downtime? What configuration should I need to do on my current Cpanel VPS to connect it to the Remote Mysql Server (separate VPS)? Is CSF enough to secure a MySQL Server?

• 

  cPanelMichael

  • August 26, 2014 13:27

  Hello :) This is documented here: Setup Remote MySQL Server You will have to backup and restore the databases manually to the remote MySQL server, as that's not a transfer process facilitated by the cPanel software. Thank you.

  0
• 

  pauloray

  • August 26, 2014 18:31

  Thanks CpanelMichael. :)

  0
• 

  pauloray

  • August 29, 2014 20:28

  [quote="cPanelMichael, post: 1716542">Hello :) This is documented here: Setup Remote MySQL Server You will have to backup and restore the databases manually to the remote MySQL server, as that's not a transfer process facilitated by the cPanel software. Thank you.
  Do we need to re-configure MySQL in each of our clients' website to reflect the IP of the Remote MySQL server? Because currently, there website's database is using "localhost".

  0
• 

  cPanelMichael

  • September 03, 2014 17:04

  You will still be able to use "localhost". However, ensure you follow the instructions for "Make certain that the local server's hostname resolves" in the document referenced from my last post. Thank you.

  0

Please sign in to leave a comment.