MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Re: Is mixed based binlog OK for setting 'innodb_autoinc_lock_mode=2'?
Posted by: Rick James
Date: May 26, 2014 12:31PM

You have to choose between performance and consistency.

The possible inconsistency in Replication happens when multiple INSERTs (or LOAD DATA) are happening on the Master, and you have non-ROW based replication.

You do not want the Slave to have different ids than the Master. So, either go with ROW or the appropriate auto inc setting.

The performance problem will rarely be visible anyway.

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




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.