1

Is there a way to replicate master/slave without disturbing master for dump like mysqldump or cold copy of data files? I'm ok to bring down the instance only once for master to enable log-bin. But there is no feasibility for dump or even cold copy. As I have 400G of data and 1min down time only.

Mannoj
  • 1,551
  • 3
  • 15
  • 36

1 Answers1

1

I would recommend Percona's Xtrabackup for this, especially since you mentioned all of your tables are InnoDB. From the page:

Percona XtraBackup is designed to make backups a seamless procedure without disrupting the performance of the server in a production environment.

The tool will allow you to take a backup without locking innodb tables. It will do a lock to copy any MyISAM tables (such as the tables mysql in the mysql database) but those shouldn't take long.

I cannot tell you how long it will take on 400GB database, but it should do it without downtime.

Derek Downey
  • 23,440
  • 11
  • 78
  • 104
  • yeah.. thats the last option I have, if this is the case on any mode of replication. – Mannoj Oct 15 '12 at 14:13
  • eh? You're going to have to get a full backup of your 'master' to set up any replication. – Derek Downey Oct 15 '12 at 14:15
  • yep I get that. But my peers having a strong objection on this concept in HA. The underlying concept is. For any HA either via cluster or replication if primary is down and secondary takes over the threads as a failover and inorder to rebuilt the primary do we need to get the dump from failover node? only in terms of backup? "I say yes,.. thats the only option by taking dump from failover node and construct the failed primary by taking down time in non-peek hrs.. – Mannoj Oct 15 '12 at 14:25
  • xtrabackup won't require you to take down any nodes, especially if you don't have myisam tables. – Derek Downey Oct 15 '12 at 14:30
  • Yes, I have done that earlier, for myisam 90GB data it goes for a toss too... I don't have to worry abt that one though. But I was checking is there an option to automatically pick data from failover node to primary without any binary logs or any backup methods. Just wondering what kind of replication would do this.. :( – Mannoj Oct 15 '12 at 14:34
  • I have done that one earlier.. for myisam 90 GB data it goes for a toss.. and I don't have to worry abt that as I don't have them. I was curious to see if any replication module has a way to automatically absorb from master. – Mannoj Oct 15 '12 at 14:37