We get asked to do this a lot :) There's a bunch of different cases. What storage engines are you using? Do you have LVM with free space on the volume group, or another way to take snapshots such as a SAN? Sometimes there are clever ways to get around various limitations, but I'll wait till you reply because there are too many different permutations to just write about all of them.
> On Tue, Jan 6, 2009 at 4:04 AM, Claudio Nanni <claudio.na...@gmail.com> wrote: >> I need to setup a replication slave off a master that is currently >> production and not stoppable or lockable(possibly). >> >> Do you have any idea on how to setup the slave with minimum or no impact on >> the master? >> >> The database is about 80GB. -- Baron Schwartz, Director of Consulting, Percona Inc. Our Blog: http://www.mysqlperformanceblog.com/ Our Services: http://www.percona.com/services.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org