IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Initial Version and Version 1 of rcInterest


Ignore:
Timestamp:
Oct 15, 2009, 12:54:26 PM (17 years ago)
Author:
bills
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • rcInterest

    v1 v1  
     1[wiki:ManagingDistributionServer up to Managing distribution on the server side]
     2
     3We have distTargets that define data and rcDestinations that define destinations. The files that get posted to destination's data store are specified by an rcInterest.
     4
     5Data gets bundled when there is a destination that has expressed interset in a target.
     6
     7This table is rather boring to look at alone
     8
     9{{{
     10mysql> select rcInterest.* from rcInterest join distTarget using(target_id) where dist_group = 'MD01' and stage = 'warp';
     11+--------+---------+-----------+---------+
     12| int_id | dest_id | target_id | state   |
     13+--------+---------+-----------+---------+
     14|   1393 |      20 |       742 | enabled |
     15|   1394 |      20 |       744 | enabled |
     16|   1395 |      20 |       743 | enabled |
     17|   1396 |      20 |       746 | enabled |
     18|   1397 |      20 |       745 | enabled |
     19+--------+---------+-----------+---------+
     20}}}
     21
     22What's going on is more instructive when the table is joined with the targets
     23
     24{{{
     25mysql> select * from rcInterest join distTarget using(target_id) where dist_group = 'MD01' and stage = 'warp';
     26+-----------+--------+---------+---------+------------+---------+-------+-------+---------+---------+
     27| target_id | int_id | dest_id | state   | dist_group | filter  | stage | clean | state   | comment |
     28+-----------+--------+---------+---------+------------+---------+-------+-------+---------+---------+
     29|       742 |   1393 |      20 | enabled | MD01       | g.00000 | warp  |     0 | enabled | NULL    |
     30|       744 |   1394 |      20 | enabled | MD01       | i.00000 | warp  |     0 | enabled | NULL    |
     31|       743 |   1395 |      20 | enabled | MD01       | r.00000 | warp  |     0 | enabled | NULL    |
     32|       746 |   1396 |      20 | enabled | MD01       | y.00000 | warp  |     0 | enabled | NULL    |
     33|       745 |   1397 |      20 | enabled | MD01       | z.00000 | warp  |     0 | enabled | NULL    |
     34+-----------+--------+---------+---------+------------+---------+-------+-------+---------+---------+
     35
     36}}}
     37
     38
     39The first interest in the table above might have been added by the command
     40
     41
     42{{{
     43disttool -defineinterest -dest_name ps1-200910-2 -dist_group MD01 -stage warp -filter g.00000
     44}}}
     45
     46