Database Table: clustermove inprogress
From Dreamwidth Notes
Revision as of 16:11, 30 March 2009 by Twentyfourhours (Talk | contribs)
This table is used by the ljbackup and ljumover daemons to track the transitions of users between clusters.
Definition
CREATE TABLE clustermove_inprogress ( userid INT UNSIGNED NOT NULL, locktime INT UNSIGNED NOT NULL, dstclust SMALLINT UNSIGNED NOT NULL, moverhost INT UNSIGNED NOT NULL, moverport SMALLINT UNSIGNED NOT NULL, moverinstance CHAR(22) NOT NULL, # base64ed MD5 hash PRIMARY KEY (userid) )
Relationships
Foreign key userid to user.userid
moverinstance identifies an instance of the ljumover daemon.