Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Baron Schwartz (baronxaprb.com)
Date: Tue Jan 06 2009 - 10:21:36 CST
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.nannigmail.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