search

microsoft / oxa-tools

Open edX on Azure Tools
MIT License
36 stars 103 forks source link

Change MySQL replication frequency #396

Closed fjferdiez closed 5 years ago

fjferdiez commented 5 years ago

Hello!

Currently, I am in charge of the maintenance of an edX instance deployed using the Mooncake version of the deployment, I would like to get some insights about the customization of MySQL DB data exportation to the backup blob storage.

image

I would like to know where and how can I customize the configuration of frequency and time when these backups are done. Currently, this blob receives the back-ups four times a day, but I noticed that it stopped a few days ago, I would like to be able to diagnose better the reason for the stop of the replications and set it up to low traffic times during the day.

image

Also, I am interested to know if I want to change the current passwords for the MySQL (including the root) which files should I change in order to keep the configuration consistent?

Thanks in advance for your answer.

eltoncarr commented 5 years ago

The backup frequency lives on the Jumpbox as a cron job. You can change the configuration from there. Take a look at the log files generated by the backups. You will get more details from there. Regarding the password change, this is a bit more involved. You'd need to update the application, replication configurations, etc.

fjferdiez commented 5 years ago

Thanks for the feedback.