Errors fall out at replications?

Question

MySQL

There are 5 servers running master-master. On server 4 I get the following error:

Could not execute Write_rows event on table base.clients_visits; Cannot add or update a child row: a foreign key constraint fails (`base`.`clients_visits`, CONSTRAINT `clients_visits_client_id` FOREIGN KEY (`client_id`) REFERENCES `clients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE), Error_code: 1452; handler error HA_ERR_NO_REFERENCED_ROW; the event's master log bin.002353, end_log_pos 37146233
...
Could not execute Update_rows event on table base.devices; Can't find record in 'devices', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log bin.002353, end_log_pos 37446205
...

What are the best steps to take to avoid these errors?

Answer 1

binlog mode? there is a statement - that is possible. Better mixed or row