From: Baron Schwartz (baronxaprb.com)
Date: Tue Jan 06 2009 - 10:21:36 CST

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]