[Solved]

[Armando Ota]

Ok after a little testing I found a solution to my problem. My guess is, that mysql has a bug here, but don't have time or enough servers to create test case and confirm as a bug !

1. I changed the destination database ID field into varchar(255) since i only need it for unique identification, not for joins and stuff ..
2. I changed the triggers (update example):

CREATE TRIGGER `data_update` AFTER UPDATE ON `data`
FOR EACH ROW
BEGIN
INSERT INTO my_lonesome_database.tablexyz (id, source, entity, record_id, child_record_id, created, action)
VALUES (CONCAT(RAND(),'-',(UTC_TIMESTAMP() + 0)), DATABASE(),'articles',NEW.id, NULL, NOW(),2);
END$$

note: check CONCAT for unique ID value in destination database table

conclusion: If posible don't use auto_increment for cases like this .. I know I wont !

kind regards

Armando