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:
- 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?
- How can I synchronize system changes (e.g. Apache2 server settings)
- 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?