The mailing list for listmasters using Sympa

[Phil Stracchino <address@concealed>]

On 9/14/21 6:46 AM, Antoni Garcia Navarro wrote:
> Hello,
> 
> We are using Sympa for a long time with a dedicated single instance
> MySQL as backend.
> 
> Now, while improving our infrastructure we are migrating the DB to a new
> Percona MySQL Cluster which although it's fully compatible with MySQL
> has some limitations on the database schema .
> 
> The main problem we are facing is the Percona limitation of not having
> tables without primary key, as it is in the sympa tables:
> 
> https://www.percona.com/doc/percona-xtradb-cluster/LATEST/features/pxc-strict-mode.html#tables-without-primary-keys
> <https://www.percona.com/doc/percona-xtradb-cluster/LATEST/features/pxc-strict-mode.html#tables-without-primary-keys>
> 
> It's possible to define a primary key for tables without impacting on
> the way sympa works? Or maybe there is a reason to not having such a
> primary key?


I have been running Sympa backed by a Galera cluster since initial
install.  I do not recall having had to do anything special to the
schemas.  It just works.  Not all of the tables have primary keys, true,
but it does not appear to be an issue.  It possibly hurts performance,
but my installation is so small it does not matter or has no visible effect.




-- 
  Phil Stracchino
  Babylon Communications
  address@concealed
  address@concealed
  Landline: +1.603.293.8485
  Mobile:   +1.603.998.6958