Not compatible with MySQL Group Replication

  • Resolved shadowlmd

    (@shadowlmd)


    3 years, 8 months ago

    This plugin creates table that doesn’t contain a primary key which is not compatible with MySQL Group Replication.

Viewing 1 replies (of 1 total)
  • Plugin Author Daniel Bachhuber

    (@danielbachhuber)

    Hey @shadowlmd,

    Here’s a SQL statement you can use to add an auto-incrementing id column:

    
ALTER TABLE wp_pantheon_sessions ADD COLUMN id BIGINT AUTO_INCREMENT PRIMARY KEY FIRST

    Hope this helps! I’ve released v1.2.2 which will include the auto-increment id in the default schema too.

Viewing 1 replies (of 1 total)
  • The topic ‘Not compatible with MySQL Group Replication’ is closed to new replies.