I've got a MySQL RDS database that uses pure generated GUIDs for key columns. The current value of the innodb_autoinc_lock_mode is 1, and due to some performance bottlenecks we want to change it 2. However, in MySQL documentation it says that:
If you are using statement-based replication, set innodb_autoinc_lock_mode to 0 or 1 and use the same value on the source and its replicas. Auto-increment values are not ensured to be the same on the replicas as on the source if you use innodb_autoinc_lock_mode = 2 (“interleaved”) or configurations where the source and replicas do not use the same lock mode.
Our replication mode is set to Mixed (default in RDS). So what I read here is telling me to keep innodb_autoinc_lock mode to 0 or 1. However the question is: Given that we are NOT using AUTO_INCREMENT columns, what would be the issue with setting innodb_autoinc_lock_mode to 2 with regards to statement-based replication and binlog replay (for recovery) ?