when I deleted a few rows, those rows did not get deleted on mariadb cluster second node. $ sudo grep "wsrep_certify_nonPK" /etc/mysql/my.cnf wsrep_certify_nonPK=1
show create table comp2012db.uni12_jevents_vevdetail; +-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table
| +-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | uni12_jevents_vevdetail | CREATE TABLE `uni12_jevents_vevdetail` ( `evdet_id` int(12) NOT NULL AUTO_INCREMENT, `rawdata` longtext NOT NULL, `dtstart` int(11) NOT NULL DEFAULT '0', `dtstartraw` varchar(30) NOT NULL DEFAULT '', `duration` int(11) NOT NULL DEFAULT '0', `durationraw` varchar(30) NOT NULL DEFAULT '', `dtend` int(11) NOT NULL DEFAULT '0', `dtendraw` varchar(30) NOT NULL DEFAULT '', `dtstamp` varchar(30) NOT NULL DEFAULT '', `class` varchar(10) NOT NULL DEFAULT '', `categories` varchar(120) NOT NULL DEFAULT '', `color` varchar(20) NOT NULL DEFAULT '', `description` longtext NOT NULL, `geolon` float NOT NULL DEFAULT '0', `geolat` float NOT NULL DEFAULT '0', `location` varchar(120) NOT NULL DEFAULT '', `priority` tinyint(3) unsigned NOT NULL DEFAULT '0', `status` varchar(20) NOT NULL DEFAULT '', `summary` longtext NOT NULL, `contact` varchar(120) NOT NULL DEFAULT '', `organizer` varchar(120) NOT NULL DEFAULT '', `url` text NOT NULL, `extra_info` varchar(240) NOT NULL DEFAULT '', `created` varchar(30) NOT NULL DEFAULT '', `sequence` int(11) NOT NULL DEFAULT '1', `state` tinyint(3) NOT NULL DEFAULT '1', `modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `multiday` tinyint(3) NOT NULL DEFAULT '1', `hits` int(11) NOT NULL DEFAULT '0', `noendtime` tinyint(3) NOT NULL DEFAULT '0', PRIMARY KEY (`evdet_id`) ) ENGINE=InnoDB AUTO_INCREMENT=515 DEFAULT CHARSET=utf8 | +-------------------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) It seems that there's a PK. But what would cause this?