How to synchronize MySQL DB between two servers?

Question

MySQL

There are sites on Bitrix, they are developed on one server, and go to production on another server, git is used for files. What could be a DB solution? Because in the admin panel on the development server, content can pile up, and on the production server too, how can I glue it together then? Thank you.

Answer 1

If you need to synchronize tables / links (do not pull data from the dev. database), then I advise you to make a .sql script to create tables in the database, etc. and commit it to git.
To automate the synchronization process, I advise you to write a small script that will once a day (for example) execute scripts from a file.

Answer 2

back up the production base and periodically restore the development base from these backups.
And what is crammed into the developer base, do you really need it?