How is it convenient to upload local changes in sites and in mysql on vps (os x)?

Question

git

I wanted to optimize the development process.
Now I work under os x, I use mamp as a local server. Several local domains have been set up, for each project I raise a new one, delete unnecessary ones.
I would like to do so. I take my com-domain, make *.dev.mysite.com access the ip of my vps (well, any subdomain with dev.mysite.com accesses this vps). And locally I set it up so that all requests to *.dev.mysite.com are processed by me, leading to the web server on mamp.
I plan to work in such a way that I conduct all the development of the site on a local machine. I worked - I sent all the changes to the vpsk and you can give an external link to other people to see.
What is different is that the local domain of this site will match the one on the vps. Plus, I can still use software that loads all updates in css files in the browser without refreshing the page.
I myself have no idea how I'm going to do all this. They suggested to raise a git-server on their vpsk and just push updates every time. But what about mysql databases (many sites are made on wordpress and other cms)? And can I push updates exactly to the web server folder on the vps in this way?
I would appreciate any advice or suggestions on how I can do this.

Answer 1

They suggested to raise a git-server and JUST push - this is wrong.
Because it's unreliable.
Well, MySQL needs migrations.
There are ready-made solutions.
For example, the free and simple Flynn.io PaaS