MySQL Forums
Forum List  »  Replication

Advanced Search
New Topic

Re: failure to setup replication using mysqldump and --single-transaction
Posted by: Scott Nemes
Date: September 21, 2012 11:29AM

Since you say you have "mostly" InnoDB tables, the problem is likely due to MyISAM tables. Mysqldump's --single-transaction parameter only works for transactional storage engines (like InnoDB), but not for non-transaction storage engines (like MyISAM).

I would recommend looking into Percona's Xtrabackup (http://www.percona.com/doc/percona-xtrabackup/?id=percona-xtrabackup:start). With that you can easily backup your master and reload it on the slave, as it records the replication coordinates for you and handles locking of your MyISAM tables. Note that it will require a lock of the MyISAM tables while they are being backed up, so make sure that is acceptable if it is on a production master.

--
Scott Nemes
MySQL DBA

http://www.linkedin.com/in/scottnemes
http://www.twitter.com/ScottNemes

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
failure to setup replication using mysqldump and --single-transaction
2421
Peter Sylvester
September 21, 2012 10:20AM
Re: failure to setup replication using mysqldump and --single-transaction
1258
Scott Nemes
September 21, 2012 11:29AM
Re: failure to setup replication using mysqldump and --single-transaction
1078
Peter Sylvester
September 21, 2012 11:52AM
Re: failure to setup replication using mysqldump and --single-transaction
1039
Rick James
September 22, 2012 05:34PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.