Fulltext results:
- Replication @linux:databases:mysql
- tion: If we know that only one node is performing data modifications we can avoid many possible problems... "slave" could be easily promoted to a new master. Data modifications are automatically replicated to fai... dates=1 ==== Activate replication ==== Import data e.g. from a innobackup on the slave - ideally it is the same data. at least it should not have much lag, so export
- mySQL
- l give you an exact point-in-time snapshot of the data --single-transaction produces a checkpoint that allows the dump to capture all data prior to the checkpoint while receiving incoming