MySQL Cluster not working because of missing primary keys

Questions and Answers Database-SQL
1
System Information
  • Strapi Version: 4.1.2
  • Operating System: MacOS 12.3.1
  • Database: MySQL 8 InnoDB Cluster
  • Node Version: node:16-alpine

Hi,

I am trying to setup a MySQL 8 InnoDB cluster, but because Strapi does not have primary keys defined on all tables, the group replication is not working. Is there a workaround to enforce the creation of primary keys or is there a feature planned to add this?

Thank you.

2

Same problem here. I didn’t find a work around yet.