[Tickets #14639] Primary key on all tables of horde database

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: https://bugs.horde.org/ticket/14639
------------------------------------------------------------------------------
  Ticket             | 14639
  Created By         | limperis at cti.gr
  Summary            | Primary key on all tables of horde database
  Queue              | Horde Groupware Webmail Edition
  Version            | 5.2.20
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


limperis at cti.gr (2017-05-10 13:29) wrote:

Hello, Horde team

I try to deplo horde on Mysql Innodb cluster or Galera cluster, but  
these environments require primary key on all database tables. These  
are the database logs that describe the problem:

'Table horde_auth_schema_info does not have any PRIMARY KEY. This is  
not compatible with Group Replication'
'Table horde_cache_schema_info does not have any PRIMARY KEY. This is  
not compatible with Group Replication'
'Table horde_core_schema_info does not have any PRIMARY KEY. This is  
not compatible with Group Replication'
'Table horde_dav_schema_info does not have any PRIMARY KEY. This is  
not compatible with Group Replication'
'Table horde_group_schema_info does not have any PRIMARY KEY. This is  
not compatible with Group Replication'
'Table horde_groups_members does not have any PRIMARY KEY. This is not  
compatible with Group Replication'
'Table horde_history_schema_info does not have any PRIMARY KEY. This  
is not compatible with Group Replication'
'Table horde_imap_client_schema_info does not have any PRIMARY KEY.  
This is not compatible with Group Replication'
'Table horde_lock_schema_info does not have any PRIMARY KEY. This is  
not compatible with Group Replication'
'Table horde_perms_schema_info does not have any PRIMARY KEY. This is  
not compatible with Group Replication

Is it predicted to add primary key to all tables at some subsequent  
distribution of horde?

If I add a primary key to all the tables, do you think the Horde will  
work properly or will problems occur?

You can see for this requirement for example  in url:   
https://mariadb.com/kb/en/mariadb/mariadb-galera-cluster-known-limitations/

Thank you.
Antonis Limperis