Wikimedia Developer Support

What is the DevOps practice for websites on Azure virtual machine

I am running a non-profit MediaWiki website that involves both database updates and code changes. How can I test that the website is running properly before I release it?

A few questions that I have:

  1. Current DevOps guides focus on code maintainence, but given that I sometimes need to update the MySQL database when I change the code (e.g. installing an extension), how can I synchronize the database change between my local machine and the VM?
  2. How can I synchronize system changes (e.g. Apache2 server settings)
  3. LocalSettings.php contains sensitive information and should not be shared on repositories, but I often need to change the setting during development. What is the best practice to keep it only on VM? Use a secret.php file and load it with LocalSetting.php?

Hi, see https://www.mediawiki.org/wiki/Topic:Vohyokdsq8wfcene