Group Replication

Collapse
X
Collapse
+ More Options
Posts
 
  • Time
  • Show
Clear All
new posts
  • Vincent
    Senior Member
    • May 2017
    • 178

    #1

    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.
  • Vincent
    Senior Member
    • May 2017
    • 178

    #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...