Migration from CentOS6 to CentOS7 with remote MySQL

malexherron

• April 05, 2021 18:54

Hello: I am preparing for an upgrade from a CentOS6 to CentOS7 server while using a remote MySQL server. I have used the manage_mysql_profiles tool described described here to transfer accounts from one server to another? If i transfer only a single account and IP, will there be any additional considerations to make so that is uses the information already present in the remote db? Thanks for any insight.

• 

  cPRex Jurassic Moderator

  • April 06, 2021 14:48

  Hey there! If I were doing this, I'd setup the remote database connection first, so things can be placed in the proper area when the accounts are migrated/restored. You can always try that with just one test account first to see if that gets things working how you expect.

  0
• 

  malexherron

  • April 07, 2021 23:14

  Hey there! If I were doing this, I'd setup the remote database connection first, so things can be placed in the proper area when the accounts are migrated/restored. You can always try that with just one test account first to see if that gets things working how you expect.

  
  thanks! i'll move forward then slightly more confidently =D

  0
• 

  cPDavidL

  • April 08, 2021 16:27

  Rex isn't around, today. But I'm glad he was able to help! Please let us know if we may be of further assistance.

  0
• 

  malexherron

  • April 08, 2021 19:50

  Rex isn't around, today. But I'm glad he was able to help! Please let us know if we may be of further assistance.

  
  I do have a slight follow up question. I am about to grant access on the remote mySQL server prior to migrating any accounts. Is it recommended to grant all permissions for the appropriate user on the new server? Is there any risk that existing db entries will be overwritten/changed by the new server prior to the accounts being migrated? I expect not, but would like to be sure. Also this issue is likely solved, how do i mark it as such?

  0
• 

  cPDavidL

  • April 09, 2021 14:05

  Is it recommended to grant all permissions for the appropriate user on the new server?

  
  If not on Amazon RDS, it will require "Super" privileges at minimum. A formal list of privileges required, can be found under step 3 of the Add Profile process, in the documentation:

  0
• 

  malexherron

  • January 19, 2022 00:12

  sorry to resurrect such a long dead thread, the migration was put on hold but is once again slated to occur. My source v6 server uses a remote MySQL profile for all sites, and Wordpress etc are configured to use that server. My destination server uses the same MySQL profile (exported from source and imported on destination servers). Based on the previous response:

  the transfertool will not modify the applications being migrated. This includes, for example, Wordpress settings to connect to its database at localhost via TCP or socket. The applications themselves must still be manually updated to connect to the remote MySQL host.

  
  I have gathered that as long as the MySQL profile is activated on the destination server, the application settings will be unaffected by Transfer Tool and therefore will use the remote server config and no additional configuration will be necessary on my part. Is this correct?

  0
• 

  cPanelAnthony

  • January 21, 2022 22:15

  Hello! That should be correct. As long as the new server's firewall and MySQL access hosts are all configured properly for incoming/outgoing port 3306 connections, I believe it should work. Obviously, I would suggest doing some testing on the destination server before switching the DNS off of the source.

  0

Please sign in to leave a comment.