Leginon

The default is still MyISAM. To switch to create new tables in InnoDB, you need to

1. change /etc/my.cnf default_storage_engine to InnoDB
2. restart mysql service
3. modify your working sinedon.cfg to include at global level
   

   engine: InnoDB
   

Anchi, have we done anything to address the FOREIGN_KEY aspect of InnoDB

CREATE TABLE Orders (
    OrderID int NOT NULL,
    OrderNumber int NOT NULL,
    PersonID int,
    PRIMARY KEY (OrderID),
    FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)
);

ALTER TABLE AcquisitionImageData
ADD FOREIGN KEY (`REF|SessionData|session`) REFERENCES SessionData(DEF_id); 

I am trying to learn the ins and outs of InnoDB vs. MyISAM and what I can tell it looks we'll need to connect the tables using the FOREIGN KEY flag, especially if we want the multi-master setup to work. Otherwise, it wouldn't know how to properly connect the tables together when locking rows.

No, I have not looked at Foreign Key, yet.