The mailing list for listmasters using Sympa

[Antoni Garcia Navarro <address@concealed>]

Missatge de Phil Stracchino <address@concealed> del dia dt., 14 de set. 2021 a les 16:08:

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.

 

Hi Phil,

The problem, according to Percona documentation, is that some write operations cannot be propagated to the other nodes. On our installation, PXC Strict Mode is set to ENFORCING, and this causes the extra validations.

Of course, I could disable validations to import the data, and reenable them later, but I'm guessing it could led to problems transferring data between nodes. Because of that, if tables could have their primary keys in place, Percona will be a "validated" backend for Sympa.

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

--

Toni Garcia Navarro

Servicio de Infraestructura Informática

Universidad Miguel Hernández

http://si.umh.es | 96 522 2613

P  Antes de imprimir este mensaje, asegúrese de que es necesario. Proteger el medio ambiente está en nuestra mano.