Announcement

Collapse
No announcement yet.

Group Replication

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Group Replication

    We want to use the mySQL for Group Replication
    https://dev.mysql.com/doc/refman/5.7...uirements.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.

  • #2
    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')

    Comment

    Working...
    X