Re: replication newbie questions

2013-08-28 Thread Ed L.
e 5.5 hour dumps are already done during the least busy times. Regarding snapshots, how long are snapshot locks held? These are ext4 filesystems. Assuming the lock is not held for long, what's the recommended way to do snapshots on ext4? Thanks, Ed On Thursday, August 29, 2013, Ed L

replication newbie questions

2013-08-28 Thread Ed L.
Mysql newbie here, looking for some help configuring 5.0.45 master-slave replication. Here's my scenario... We have a heavily loaded 30gb 5.0.45 DB we need to replicate via master-slave configuration to a new, beefier server running same mysql 5.0.45, and then cutover to the new server. Du

connection issue

2013-08-09 Thread Ed L.
This mysql newbie is having trouble connecting to a mysqld instance, hoping someone can offer a clue on troubleshooting. I have 2 mysql 5.0.45 installations on one RHEL server. One live mysqld is setup in what appears to be a relatively standard installation, port 3306, user 'mysql', etc.