I have two KnownHost VPS accounts. One is slightly older, in terms of installation, and it holds my biggest site.
I have a couple of problems that I need to sort out. I'm not looking for someone to tell me every step to take, but I'm hoping I can get some advice as to the order of big steps I need to take to accomplish my goals.
Goal 1 is to update the old site to the latest PHP & MySQL.
Goal 2 is to migrate site to newer VPS, where I will upgrade ( and update ) the VPS and get rid of the older VPS.
( Regarding the sites, they are all my own custom rolled code, so I will have to handle any code fixes myself. There aren't any updates I can download. Typically I like to do that on my localhost setup, which is on Windows. I'm considering setting up a localhost Linux box to help with this process. )
First concern is MySQL. I'm on 5.0 on the first server and 5.1 on the second.
I want to get the destination server up to 5.7, ideally, but MySQL recommends that databases are incrementally upgraded. So apparently I will need to upgrade the database a few times to get it up to the latest version.
My concern is juggling the upgrade process and at the same time dealing with migration. I want to do this with as little downtime as possible, and of course, hopefully without data loss or complications.
My PHP is stuck on 5.4 and I want to get that up to 7 if possible.
Is there a preferred approach to this scenario? Should I focus entirely on the database first and deal with PHP after I've migrated and upgraded? I'm honestly not sure if there are compatibility issues with all of these various versions of MySQL and PHP. I was looking for a basic compatibility chart, but I didn't find one.
After I developed my last couple of sites, I took an extended break from any backend development. The sites have been humming along without any issues. But now it's time to dive in move forward again.
Any advice is greatly appreciated. Thanks.
I have a couple of problems that I need to sort out. I'm not looking for someone to tell me every step to take, but I'm hoping I can get some advice as to the order of big steps I need to take to accomplish my goals.
Goal 1 is to update the old site to the latest PHP & MySQL.
Goal 2 is to migrate site to newer VPS, where I will upgrade ( and update ) the VPS and get rid of the older VPS.
( Regarding the sites, they are all my own custom rolled code, so I will have to handle any code fixes myself. There aren't any updates I can download. Typically I like to do that on my localhost setup, which is on Windows. I'm considering setting up a localhost Linux box to help with this process. )
First concern is MySQL. I'm on 5.0 on the first server and 5.1 on the second.
I want to get the destination server up to 5.7, ideally, but MySQL recommends that databases are incrementally upgraded. So apparently I will need to upgrade the database a few times to get it up to the latest version.
My concern is juggling the upgrade process and at the same time dealing with migration. I want to do this with as little downtime as possible, and of course, hopefully without data loss or complications.
My PHP is stuck on 5.4 and I want to get that up to 7 if possible.
Is there a preferred approach to this scenario? Should I focus entirely on the database first and deal with PHP after I've migrated and upgraded? I'm honestly not sure if there are compatibility issues with all of these various versions of MySQL and PHP. I was looking for a basic compatibility chart, but I didn't find one.
After I developed my last couple of sites, I took an extended break from any backend development. The sites have been humming along without any issues. But now it's time to dive in move forward again.
Any advice is greatly appreciated. Thanks.