Changes between Initial Version and Version 1 of SQLCloning
- Timestamp:
- Feb 4, 2013, 10:26:32 PM (12 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
SQLCloning
v1 v1 1 To create a clone of a SQL server from scratch (~pseudocode): 2 3 * `iptables -A INPUT -p tcp --dport mysql -j REJECT` 4 * Wait for connections to die down 5 * `mysql -e "show master status"` and save the output 6 * `mysqladmin shutdown` 7 * `umount /path/to/mysqldata` 8 * `sync` 9 * `lvcreate -s -L 10G -n snapshot /dev/vg/mysqldata` 10 * `mount /path/to/mysqldata` 11 * `/etc/init.d/mysql restart` 12 * Copy from /dev/vg/mysqldata at your leisure