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

* Your Email Address
* Spam protection	Enter the letters below: ._..__..___.\ / __. \| \| \| \| >< (__ _\|_\|__\| \| / \.__)
Comment	> 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 > > >
Attachment
Watch this ticket

Saved Queries