Difference between revisions of "Database Table: clustermove inprogress"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Changing Category:Database Tables)
Line 1: Line 1:
 +
{{#set:name=clustermove_inprogress|table type=global|description=This table is used to track the transitions of users between clusters.}}
 
This table is used by the [[ljbackup.pl|ljbackup]] and [[ljumover.pl|ljumover]] daemons to track the transitions of users between clusters.
 
This table is used by the [[ljbackup.pl|ljbackup]] and [[ljumover.pl|ljumover]] daemons to track the transitions of users between clusters.
 
+
moverinstance identifies an instance of the [[ljumover.pl|ljumover]] daemon.
 
= Definition =
 
= Definition =
 
<source lang="sql">
 
<source lang="sql">
Line 13: Line 14:
 
)
 
)
 
</source>
 
</source>
 
+
{{Database Table Footer}}
= Relationships =
+
 
+
Foreign key userid to [[Database Table: user|user]].userid
+
 
+
moverinstance identifies an instance of the [[ljumover.pl|ljumover]] daemon.
+
 
+
= Location =
+
 
+
[[Global database]]
+
 
+
[[Category:Database Tables Needing Conversion|clustermove_inprogress]]
+

Revision as of 18:40, 5 October 2009

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