What is the best way to roll out updates for php + mysql site?

Question

PHP

What are the best ways to push updates to a site with FTP and SSH access, on a regular hosting, using only php and mysql?
More precisely, I want to find an ideal way in which you can copy the site with the database, make changes both to the files and to the database structure (but not to the data - only up-to-date data should be used) - add tables and fields in existing tables. And then roll out the updated version to the production server.
So that when updates are made at any time, even when the site is being used, it does not cause problems for users and generally goes unnoticed. Just refreshing the page would add new features.
It is very important not to lose data during the upgrade and not to interfere with the introduction of new data during the rollout of the upgrade.
I use PhpStorm on a mac, if a solution for it would be great.
There is only one developer (me), but it is desirable that there be support for BitBucket (for example).
I would love to hear your solutions.

Answer 1

git. An ideal version control system, you can deploy and test as you like, and most importantly, it is simple and very powerful. Read habrahabr.ru/post/123111 and use