Mysql master<->master replication getting entirely messed up. What config do I need to tweak?

[dormando]

> Hi Dormando,
> 
> I've got a question about your master-master configuration. I checked
> the default mogilefs SQL table schemas, and I didn't find any auto
> increment column. Do I have to change schema for master-master
> replication? Here is my current state:
> 
> mysql> use mogilefs
> Database changed
> mysql> desc file;
> +----------+----------------------+------+-----+---------+-------+
> | Field    | Type                 | Null | Key | Default | Extra |
> +----------+----------------------+------+-----+---------+-------+
> | fid      | int(10) unsigned     | NO   | PRI | NULL    |       |
> | dmid     | smallint(5) unsigned | NO   | MUL | NULL    |       |
> | dkey     | varchar(255)         | YES  |     | NULL    |       |
> | length   | int(10) unsigned     | YES  |     | NULL    |       |
> | classid  | tinyint(3) unsigned  | NO   |     | NULL    |       |
> | devcount | tinyint(3) unsigned  | NO   |     | NULL    |       |
> +----------+----------------------+------+-----+---------+-------+
> 6 rows in set (0.02 sec)
> 
> Thanks,
> Michael

It's in the 'tempfile' table. The 'fid' referenced everywhere can be 
overridden (which was a bad idea IMHO)... Also file data is pushed into 
'tempfile' until it's done uploading, so the auto_increment has to exist 
in there.

-Dormando