Deploy web applications: patches and database structure changes - existing tools?

Question

Software Deployment

Hello!
Please help me with the next question.
We use Capistrano to automate the process of deploying a web application (php) on stage and production servers .
Previously, to solve the problem of applying changes to database structures (MySQL), they used their "bicycles" executed by Capistrano. But time goes by, and I don't think that this process has not yet been unified.
Actually, the question is - please tell me ready-made solutions for rolling changes in the database structure during the deployment process.
Thank you very much for your help!

Answer 1

Вы про механизм миграций спрашиваете?
В Yii2, Laravel используются миграции, которые выполняются через 1 команду: yii migrate/up, например.
И у вас самая свежая версия схемы БД.