《mysql-mmm实现mysql-HA》《瞬间表锁---mmm-tools实快照速备份和还原》.ppt

* * [root@andy ~]# mmm_backup --host db1 --copy-method scp --dest-dir /mmm_backup/ INFO: Checking local destination directory /mmm_backup/... INFO: Directory is ok INFO: Verifying ssh connection to remote host root@28 (command: ssh -p 22 root@28 date)... root@28s password: Thu Dec 8 00:05:42 CST 2011 INFO: OK: SSH connection works fine! INFO: ssh -p 22 root@28 /usr/lib/mysql-mmm//tools/create_snapshot root@28s password: File descriptor 4 (socket:[1785871]) leaked on lvcreate invocation. Parent PID 16900: perl Logical volume mmm_snapshot created OK: Snapshot created! INFO: Copying var from snapshot on host db1 with copy method scp INFO: Executing command scp -P22 -c blowfish -r root@28:/mmm_snapshot/var /mmm_backup// 拷贝文件 INFO: Copied directory var! INFO: Copying _mmm from snapshot on host db1 with copy method scp INFO: Executing command scp -P22 -c blowfish -r root@28:/mmm_snapshot/_mmm /mmm_backup// root@28s password: status.txt 100% 2345 2.3KB/s 00:00 f 100% 5570 5.4KB/s 00:00 INFO: Copied directory _mmm! INFO: ssh -p 22 root@28 /usr/lib/mysql-mmm//tools/remove_snapshot root@28s password: Logical volume mmm_snapshot successfully removed OK: Snapshot removed! * * mmm_common.conf(二) 主机配置部分 host db1 ip 28 mode master peer db2 /host host db2 ip 29 mode master peer db1 /host host db3 ip 30 mode slave /host * mmm_common.conf(三) 角色配置部分 role writer hosts db1, d