PXC AUTO_INCREMENT values don't replicate to MyISAM tables correctly
Bug #1080913 reported by
Daniel Nichter
This bug affects 3 people
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Confirmed
|
Undecided
|
Unassigned | ||
Percona Toolkit moved to https://jira.percona.com/projects/PT |
Won't Fix
|
Undecided
|
Unassigned | ||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
Won't Fix
|
Undecided
|
Unassigned |
Bug Description
To reproduce:
1. Create a MyISAM table with an AUTO_INCREMENT column on node1.
2. INSERT INTO <that table> (auto_inc_col) VALUES (NULL);
3. The new auto-inc value on the node is 1, but it is 2, 3, or other values on other nodes.
This only affect MyISAM tables, regardless of binlog_format (if that affects PXC/Galera at all). Change the same table to InnoDB and there's no problem.
Changed in percona-toolkit: | |
status: | New → Confirmed |
tags: |
added: auto-inc removed: auto-increment |
Changed in galera: | |
status: | New → Confirmed |
Changed in percona-toolkit: | |
milestone: | none → 2.2.1 |
importance: | Undecided → High |
Changed in codership-mysql: | |
status: | New → Confirmed |
no longer affects: | galera |
tags: | added: pxc |
Changed in percona-toolkit: | |
milestone: | 2.2.1 → none |
summary: |
- AUTO_INCREMENT values don't replicate to MyISAM tables correctly + PXC AUTO_INCREMENT values don't replicate to MyISAM tables correctly |
Changed in percona-toolkit: | |
importance: | High → Undecided |
To post a comment you must log in.
We've had about 8 months of experience with PXC now, and the verdict seems clear: PXC and MyISAM are not a good combination, and afaik there's no big push from users to make it work, i.e. the 99% use-case is PXC with InnoDB. So I'm going to WontFix this bug in Percona Toolkit.