I've been tasked with assorted maintenance of a DB. I have very little experience with MySQL, so pardon any ignorance :)
Two (well, four) related questions:
- The DB is supposed to be replicated to a backup slave, but it's been pointing at the wrong host for quite some time, so it's currently months behind. It looks like I want to run
change master tofrom the slave to fix this.
- Is it generally safe to do this live?
- If not, is there a static config counterpart to the command, such that I can send it out in a managed deployment?
- We suspect the binary logs on the master may be corrupt/incomplete.
- Will this affect the ability to fully replicate all data?
- If so, how can I ensure a full backup? Is a full
Hopefully I'm not barking up the wrong tree here. Feel free to point me in a different direction. The overall need is to have a backup, of some sort, as soon as possible. Thanks!