Topic: Replication and bases.
Read horror stories from . and cases from life there was a question: how competently to organize regular replicable basis?
[quote =] "Bin-broad gull and replications - For replication" mysqldump "it is not intended, for this purpose there is a bin-broad gull (- log-bin)"
And on the contrary:
[quote =] "1. Recovery from is possible only when they were conducted from the very beginning. Or if there is a mold of an initiating state of a database after which broad gulls started to be conducted.
2. On the loaded servers quickly kill space on a disk, therefore they are stored not by everything, and a quantity of the last. Previous or are packed, or at all are deleted. It is clear that in the latter case to recover it will be possible nothing.
3. One more assignment - replication. If there is a remark, unconditionally it is easier to recover the data from it, than from . "