Can you explain what a certfication really means? I ran inserts on one node and saw the following (No Deadlocks) ------------------------------------ 140502 18:49:53 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: f6fe4654-d146-11e3-98f6-07e3fb548fd3 version: 2 local: 1 state: CERTIFYING flags: 1 conn_id: 55000 trx_id: 9240293 seqnos (l: 12226, g: 157125, s: 157122, d: 156995, ts: 1399056593553436324) <--X--> source: 771d5f4a-d086-11e3-b81d-e62da7bc8426 version: 2 local: 0 state: COMMITTED flags: 1 conn_id: 104292 trx_id: 8692927 seqnos (l: 12225, g: 157124, s: 157123, d: 157123, ts: 1399056593163923614) 140502 18:49:53 [Note] WSREP: commit failed for reason: 3 140502 18:49:53 [Note] WSREP: conflict state: 0 140502 18:49:53 [Note] WSREP: cluster conflict due to certification failure for threads: 140502 18:49:53 [Note] WSREP: Victim thread: THD: 55000, mode: local, state: executing, conflict: cert failure, seqno: 157125 SQL: INSERT INTO registration (reg_name , reg_key , reg_secret , description , reg_status , user_id , owner_id ) VALUES ("MultiMasterInsert-186_akdrgdb003" ,"akdrgdb003186" ,"nopassword_186_akdrgdb003" ,"Testing multimaster insert" ,"active" ,"DBSCelestP186" ,"A_accessorLoadtestCk_1" ) 140502 18:49:53 [Note] WSREP: wsrep retrying AC query: INSERT INTO registration (reg_name , reg_key , reg_secret , description , reg_status , user_id , owner_id ) VALUES ("MultiMasterInsert-186_akdrgdb003" ,"akdrgdb003186" ,"nopassword_186_akdrgdb003" ,"Testing multimaster insert" ,"active" ,"DBSCelestP186" ,"A_accessorLoadtestCk_1" ) 140502 18:49:54 [Note] WSREP: releasing retry_query: conf 0 sent 0 kill 0 errno 0 SQL INSERT INTO registration (reg_name , reg_key , reg_secret , description , reg_status , user_id , owner_id ) VALUES ("MultiMasterInsert-186_akdrgdb003" ,"akdrgdb003186" ,"nopassword_186_akdrgdb003" ,"Testing multimaster insert" ,"active" ,"DBSCelestP186" ,"A_accessorLoadtestCk_1" ) 140502 18:49:55 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 103775 trx_id: 8718593 seqnos (l: 12231, g: 157130, s: 157128, d: 156995, ts: 1399056595415520640) <--X--> source: f6fe4654-d146-11e3-98f6-07e3fb548fd3 version: 2 local: 1 state: COMMITTED flags: 1 conn_id: 55002 trx_id: 9240298 seqnos (l: 12230, g: 157129, s: 157128, d: 157128, ts: 1399056595033967357) 140502 18:50:00 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 771d5f4a-d086-11e3-b81d-e62da7bc8426 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 104300 trx_id: 8692942 seqnos (l: 12242, g: 157141, s: 157138, d: 156995, ts: 1399056600007851587) <--X--> source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: COMMITTED flags: 1 conn_id: 103780 trx_id: 8718603 seqnos (l: 12241, g: 157140, s: 157139, d: 157139, ts: 1399056599617205643) 140502 18:50:00 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 771d5f4a-d086-11e3-b81d-e62da7bc8426 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 104300 trx_id: 8692943 seqnos (l: 12243, g: 157142, s: 157138, d: 156995, ts: 1399056600485955140) <--X--> source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: COMMITTED flags: 1 conn_id: 103780 trx_id: 8718603 seqnos (l: 12241, g: 157140, s: 157139, d: 157139, ts: 1399056599617205643) 140502 18:50:17 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 771d5f4a-d086-11e3-b81d-e62da7bc8426 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 104319 trx_id: 8692978 seqnos (l: 12274, g: 157173, s: 157171, d: 156995, ts: 1399056616994766251) <--X--> source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: COMMITTED flags: 1 conn_id: 103798 trx_id: 8718636 seqnos (l: 12273, g: 157172, s: 157171, d: 157171, ts: 1399056616570123972) 140502 18:50:23 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 103805 trx_id: 8718646 seqnos (l: 12283, g: 157182, s: 157180, d: 156995, ts: 1399056623027628333) <--X--> source: f6fe4654-d146-11e3-98f6-07e3fb548fd3 version: 2 local: 1 state: COMMITTED flags: 1 conn_id: 55031 trx_id: 9240352 seqnos (l: 12282, g: 157181, s: 157180, d: 157180, ts: 1399056622556702773) 140502 18:50:40 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 103824 trx_id: 8718683 seqnos (l: 12317, g: 157216, s: 157214, d: 156995, ts: 1399056640624842012) <--X--> source: f6fe4654-d146-11e3-98f6-07e3fb548fd3 version: 2 local: 1 state: COMMITTED flags: 1 conn_id: 55050 trx_id: 9240390 seqnos (l: 12316, g: 157215, s: 157214, d: 157214, ts: 1399056640260072337) 140502 18:50:43 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 771d5f4a-d086-11e3-b81d-e62da7bc8426 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 104346 trx_id: 8693028 seqnos (l: 12322, g: 157221, s: 157219, d: 156995, ts: 1399056643055017719) <--X--> source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: COMMITTED flags: 1 conn_id: 103826 trx_id: 8718687 seqnos (l: 12321, g: 157220, s: 157219, d: 157219, ts: 1399056642666421656) 140502 18:51:09 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 771d5f4a-d086-11e3-b81d-e62da7bc8426 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 104373 trx_id: 8693074 seqnos (l: 12365, g: 157264, s: 157261, d: 156995, ts: 1399056669012810344) <--X--> source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: COMMITTED flags: 1 conn_id: 103853 trx_id: 8718733 seqnos (l: 12364, g: 157263, s: 157262, d: 157262, ts: 1399056668614631489) 140502 18:51:11 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 771d5f4a-d086-11e3-b81d-e62da7bc8426 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 104375 trx_id: 8693081 seqnos (l: 12370, g: 157269, s: 157267, d: 156995, ts: 1399056670755359688) <--X--> source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: COMMITTED flags: 1 conn_id: 103855 trx_id: 8718737 seqnos (l: 12369, g: 157268, s: 157267, d: 157267, ts: 1399056670335185430) 140502 18:51:16 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 771d5f4a-d086-11e3-b81d-e62da7bc8426 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 104380 trx_id: 8693090 seqnos (l: 12377, g: 157276, s: 157274, d: 156995, ts: 1399056675776187476) <--X--> source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: COMMITTED flags: 1 conn_id: 103860 trx_id: 8718744 seqnos (l: 12376, g: 157275, s: 157274, d: 157274, ts: 1399056675329245764) 140502 18:51:23 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 771d5f4a-d086-11e3-b81d-e62da7bc8426 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 104386 trx_id: 8693106 seqnos (l: 12389, g: 157288, s: 157285, d: 156995, ts: 1399056683049854968) <--X--> source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: COMMITTED flags: 1 conn_id: 103867 trx_id: 8718757 seqnos (l: 12388, g: 157287, s: 157286, d: 157286, ts: 1399056682666141009) 140502 18:51:24 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 771d5f4a-d086-11e3-b81d-e62da7bc8426 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 104386 trx_id: 8693107 seqnos (l: 12390, g: 157289, s: 157286, d: 156995, ts: 1399056684515080396) <--X--> source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: COMMITTED flags: 1 conn_id: 103867 trx_id: 8718757 seqnos (l: 12388, g: 157287, s: 157286, d: 157286, ts: 1399056682666141009) 140502 18:51:26 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 103870 trx_id: 8718761 seqnos (l: 12393, g: 157292, s: 157290, d: 156995, ts: 1399056685919269446) <--X--> source: f6fe4654-d146-11e3-98f6-07e3fb548fd3 version: 2 local: 1 state: COMMITTED flags: 1 conn_id: 55094 trx_id: 9240472 seqnos (l: 12392, g: 157291, s: 157290, d: 157290, ts: 1399056685507576607) 140502 18:51:32 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 771d5f4a-d086-11e3-b81d-e62da7bc8426 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 104398 trx_id: 8693125 seqnos (l: 12407, g: 157306, s: 157304, d: 156995, ts: 1399056692493360390) <--X--> source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: COMMITTED flags: 1 conn_id: 103877 trx_id: 8718776 seqnos (l: 12406, g: 157305, s: 157304, d: 157304, ts: 1399056692049129313) 140502 18:51:33 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 771d5f4a-d086-11e3-b81d-e62da7bc8426 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 104398 trx_id: 8693126 seqnos (l: 12408, g: 157307, s: 157304, d: 156995, ts: 1399056693009953493) <--X--> source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: COMMITTED flags: 1 conn_id: 103877 trx_id: 8718776 seqnos (l: 12406, g: 157305, s: 157304, d: 157304, ts: 1399056692049129313) 140502 18:51:42 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 771d5f4a-d086-11e3-b81d-e62da7bc8426 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 104407 trx_id: 8693142 seqnos (l: 12424, g: 157323, s: 157320, d: 156995, ts: 1399056701970477110) <--X--> source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: COMMITTED flags: 1 conn_id: 103886 trx_id: 8718792 seqnos (l: 12423, g: 157322, s: 157321, d: 157321, ts: 1399056701526340344) 140502 18:51:43 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 771d5f4a-d086-11e3-b81d-e62da7bc8426 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 104407 trx_id: 8693144 seqnos (l: 12425, g: 157324, s: 157320, d: 156995, ts: 1399056703695682030) <--X--> source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: COMMITTED flags: 1 conn_id: 103886 trx_id: 8718792 seqnos (l: 12423, g: 157322, s: 157321, d: 157321, ts: 1399056701526340344) 140502 18:51:51 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: 1f655260-d083-11e3-9c99-274f9aafca92 version: 2 local: 0 state: CERTIFYING flags: 1 conn_id: 103896 trx_id: 8718808 seqnos (l: 12440, g: 157339, s: 157337, d: 156995, ts: 1399056711500269797) <--X--> source: f6fe4654-d146-11e3-98f6-07e3fb548fd3 version: 2 local: 1 state: COMMITTED flags: 1 conn_id: 55120 trx_id: 9240520 seqnos (l: 12439, g: 157338, s: 157337, d: 157337, ts: 1399056711081727971) 140502 18:52:08 [Note] WSREP: trx conflict for key 0 6f7669617069 726567697374726174696f6e 000041004b004400520047004400 : source: f6fe4654-d146-11e3-98f6-07e3fb548fd3 version: 2 local: 1 state: CERTIFYING flags: 1 conn_id: 55139 trx_id: 9240553 seqnos (l: 12468, g: 157367, s: 157365, d: 156995, ts: 1399056728148364384) <--X--> source: 771d5f4a-d086-11e3-b81d-e62da7bc8426 version: 2 local: 0 state: COMMITTED flags: 1 conn_id: 104435 trx_id: 8693190 seqnos (l: 12467, g: 157366, s: 157365, d: 157365, ts: 1399056727095068527) ------------------------------