Announcement

Announcement Module
Collapse
No announcement yet.

row IDs wrong

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • row IDs wrong

    Hi,

    We working with 3 nodes cluster and we have some issue with row IDs.

    When we insert new data the first row ID is 1 but the second one is for example 4. Of course it should be 1 and 2.

    Any idea?

    xtraDB version is 5.5.33-rel31.0 on CentOS 6 servers.

  • #2
    This is common behavior of cluster to avoid conflict while inserting to other nodes, u can change the auto increment to u r desired values, but its not recommended.

    Comment


    • #3
      I see.

      Thank you

      Comment

      Working...
      X