wsrep_certify_nonPK

Defines whether the node should generate primary keys on rows without them for the purposes of certification.

Command-line Format	--wsrep-certify-nonpk
System Variable	Name:	wsrep_certify_nonpk
Variable Scope:	Global
Dynamic Variable:
Permitted Values	Type:	Boolean
Default Value:	ON
Support	Introduced:	1
Galera Cluster requires primary keys on all tables. The node uses the primary key in replication to allow for the parallel applying of transactions to the table. This parameter tells the node that when it encounters a row without a primary key, that it should create one for replication purposes. However, as a rule do not use tables without primary keys.

SHOW VARIABLES LIKE 'wsrep_certify_nonpk';

+---------------------+-------+
| Variable_name       | Value |
+---------------------+-------+
| wsrep_certify_nonpk | ON    |
+---------------------+-------+