Home
| Calendar
| Mail Lists
| List Archives
| Desktop SIG
| Hardware Hacking SIG
Wiki | Flickr | PicasaWeb | Video | Maps & Directions | Installfests | Keysignings Linux Cafe | Meeting Notes | Linux Links | Bling | About BLU |
Matt Shields wrote: > On Jan 3, 2008 9:43 AM, Matthew Gillen <[hidden email]> wrote: >>> Can't you just use rsync on the MySQL data directories to create a mirror? >> >> Only if you shut down the server first, to guarantee that you're not in the >> middle of operation that would leave the on-disk database in an inconsistent >> state (and thus unusable as a backup). > > Yes you can. Do a flush tables, then do a LVM snapshot. You can then > copy the files. Once the file copy is done, release the snapshot. I > use this method to refresh my replicated slaves if something gets > corrupted on them. Master db stays online the whole time.
BLU is a member of BostonUserGroups | |
We also thank MIT for the use of their facilities. |