Percona XtraDB Cluster - HA scalable solution for MySQL

PXC AUTO_INCREMENT values don't replicate to MyISAM tables correctly

Reported by Daniel Nichter on 2012-11-19
This bug affects 3 people
Affects Status Importance Assigned to Milestone
MySQL patches by Codership
Percona Toolkit
Percona XtraDB Cluster

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
Daniel Nichter (daniel-nichter) wrote :

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.

Changed in percona-toolkit:
status: Confirmed → Won't Fix
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers