Difference between revisions of "Database Table: clustermove inprogress"
From Dreamwidth Notes
Exor674Bot (Talk | contribs) 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}} | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
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
