re: replication newbie questions

2013-08-29 Thread Michael Widenius
Hi! > "Ed" == Ed L writes: Ed> Mysql newbie here, looking for some help configuring 5.0.45 master-slave Ed> replication. Here's my scenario... Ed> We have a heavily loaded 30gb 5.0.45 DB we need to replicate via Ed> master-slave configuration to a new, beefier server running same mysql

Re: replication newbie questions

2013-08-28 Thread Ananda Kumar
if i u have LVM's then lock is held only for the duration of taking snapshot, which would be few min, if there is very less activity on the db. On Wed, Aug 28, 2013 at 3:08 PM, Ed L. wrote: > On 8/28/13 2:00 PM, Ananda Kumar wrote: > > > Why don't u try snapshot backups, where the lock held fo

Re: replication newbie questions

2013-08-28 Thread Ed L.
On 8/28/13 2:00 PM, Ananda Kumar wrote: Why don't u try snapshot backups, where the lock held for less duration. Or can't u take mysql dumps during Night time when there is less bd activity I neglected to mention these systems are both CentOS linux systems. Unfortunately, the 5.5 hour dumps

Re: replication newbie questions

2013-08-28 Thread Ananda Kumar
Why don't u try snapshot backups, where the lock held for less duration. Or can't u take mysql dumps during Night time when there is less bd activity On Thursday, August 29, 2013, Ed L. wrote: > > Mysql newbie here, looking for some help configuring 5.0.45 master-slave replication. Here's my sce