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
