Hi,
i'm having a replication problem. I have 1 master and 14 slaves and 13 of them work fine, 14th keeps complaining about error in its relay-bin file. MySqlBinLog confirms error in file, but i don't know how to fix that so i'd like to do it the easy way. Can i do the following :
- save local tables, that are not replicated
- copy master's db to that 14th slave
- return saved local tables to the db in their original state
- stop 14th slave server (** i guess i'll have to modify some system settings on the slave to indicate, that all the data was replicated)
- start 14th slave server
- delete log files on 14th slave
If this is "legal", what do i have to do, to achieve ** ?
Thanks in advance,
Andrej
i'm having a replication problem. I have 1 master and 14 slaves and 13 of them work fine, 14th keeps complaining about error in its relay-bin file. MySqlBinLog confirms error in file, but i don't know how to fix that so i'd like to do it the easy way. Can i do the following :
- save local tables, that are not replicated
- copy master's db to that 14th slave
- return saved local tables to the db in their original state
- stop 14th slave server (** i guess i'll have to modify some system settings on the slave to indicate, that all the data was replicated)
- start 14th slave server
- delete log files on 14th slave
If this is "legal", what do i have to do, to achieve ** ?
Thanks in advance,
Andrej