Group Replication

[Vincent]

We want to use the mySQL for Group Replication

https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html

One of the requirements is primary key.

• Primary Keys. Every table that is to be replicated by the group must have a defined primary key, or primary key equivalent where the equivalent is a non-null unique key.

I would like to ask whether all tables in mySQL for espoCRM having a primary key? Thanks.

[Vincent]

I have run below script and got no result returned, it seems that all tables in MySQL for EspoCRM having primary key

select distinct table_name
from information_schema.columns
where table_schema = 'espo'
and table_name not in (select table_name
from information_schema.columns
where table_schema = 'espo'
and column_key = 'PRI')