I am using mariadb galera cluster of nextcloud database node across multple site,
should I alter oc_* tables without primary key to add a primary key field.
and and would it be safe turn on innodb_strict_mode.
Nextcloud version (eg, 18.0.2): 20.1.1
Operating system and version (eg, Ubuntu 20.04): 18.04
Apache (eg, Apache 2.4.25): 2.4
PHP version (eg, 7.1): 7.4
So far I haven’t faced any problem but I read on severalnines website but they were talking about percona XtraDB Cluster
I found this thread using the search function of this forum, in which a user reported that he has enabled the named parameter. Perhaps his hints to optimize the database access helps you too: