Database Table: clustermove inprogress

From Dreamwidth Notes
Revision as of 18:40, 5 October 2009 by Exor674 (Talk | contribs)

Jump to: navigation, search

This table is used by the ljbackup and ljumover daemons to track the transitions of users between clusters. moverinstance identifies an instance of the ljumover daemon.

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

Outgoing

  • Foreign key: userid to user.userid