I'm transitioning to a new VPS. The old one is running CentOS 6.10 xen hvm and WHM v86.0.32, with PHP 5.6 and MySQL 5.5; the new one is running CentOS 7.9 and WHM v92.0.3, with both PHP 7.4 and 5.6 installed and MariaDB 10.3.
One account (which is mine, and the largest) is roughly 40G in size, and 11G of that is MySQL. The last major rebuild was on PHP 5 and used procedural mysql_ commands throughout, but PHP 7.x requires MySQLi so it's a bit of work to modify the whole thing.
I'm trying to minimize (better yet, prevent entirely) any down time.
So first question... would you suggest that I:
A) move 29G of PHP and images (mostly uploaded by users) to the new VPS on PHP 5.6, modify the DNS to point to the new VPS, and on the new VPS modify the scripts to load MySQL from the old VPS (which would just require a change on one file), then modify each of the scripts for MySQLi? Or
B) move the 11G of MySQL first, then point the scripts on the old VPS to point to the new VPS for MariaDB?
Second question...
What would be the best way to move these items piecemeal like that?
I'm guessing that I would need to manually create an account on the new VPS with the same account name and domain name as the old VPS, but I have 55+ domains parked on the old VPS... would I have to manually park each of them on the new VPS?
Then I'm guessing that I would need to use cPanel to create the emails, MySQL database, and MySQL users with the same names, usernames, and passwords as the old VPS, and THEN use rsync to copy the files over?
That's a lot of opportunity for mistakes so it's far from ideal, but I don't see an option in WHM to select file types or directories to transfer, or to just transfer DNS data or anything.
TIA for any advice you can give!
One account (which is mine, and the largest) is roughly 40G in size, and 11G of that is MySQL. The last major rebuild was on PHP 5 and used procedural mysql_ commands throughout, but PHP 7.x requires MySQLi so it's a bit of work to modify the whole thing.
I'm trying to minimize (better yet, prevent entirely) any down time.
So first question... would you suggest that I:
A) move 29G of PHP and images (mostly uploaded by users) to the new VPS on PHP 5.6, modify the DNS to point to the new VPS, and on the new VPS modify the scripts to load MySQL from the old VPS (which would just require a change on one file), then modify each of the scripts for MySQLi? Or
B) move the 11G of MySQL first, then point the scripts on the old VPS to point to the new VPS for MariaDB?
Second question...
What would be the best way to move these items piecemeal like that?
I'm guessing that I would need to manually create an account on the new VPS with the same account name and domain name as the old VPS, but I have 55+ domains parked on the old VPS... would I have to manually park each of them on the new VPS?
Then I'm guessing that I would need to use cPanel to create the emails, MySQL database, and MySQL users with the same names, usernames, and passwords as the old VPS, and THEN use rsync to copy the files over?
That's a lot of opportunity for mistakes so it's far from ideal, but I don't see an option in WHM to select file types or directories to transfer, or to just transfer DNS data or anything.
TIA for any advice you can give!