Changes between Initial Version and Version 1 of SQLCloning


Ignore:
Timestamp:
Feb 4, 2013, 10:26:32 PM (11 years ago)
Author:
quentin
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • SQLCloning

    v1 v1  
     1To 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