Distributed monitoring databases not align!!!
Hi,
I have a system based on distributed motitoring, with 1 master node and 3 child nodes.
If I need to make a backup of a child node's database (mysql DB - database of a week ago), How does the alignment with the master node database work???
If I have, in this week, made correct changes on child node, how can I align the Child's DB with aMaster's DB?
If I have, in this week, made wrong changes on child node, how can I align the Master's DB with a Child's DB?
If I simpy restore the DB on child node (mysqldump < etc etc..), I find a lot of incongruous things between DBs.
Any idea?
Thanks and sorry for my english!
I have a system based on distributed motitoring, with 1 master node and 3 child nodes.
If I need to make a backup of a child node's database (mysql DB - database of a week ago), How does the alignment with the master node database work???
If I have, in this week, made correct changes on child node, how can I align the Child's DB with aMaster's DB?
If I have, in this week, made wrong changes on child node, how can I align the Master's DB with a Child's DB?
If I simpy restore the DB on child node (mysqldump < etc etc..), I find a lot of incongruous things between DBs.
Any idea?
Thanks and sorry for my english!