IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 169 and Version 170 of ippToPsps


Ignore:
Timestamp:
Oct 5, 2011, 3:14:48 PM (15 years ago)
Author:
rhenders
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ippToPsps

    v169 v170  
    8585{{{ippToPsps}}} contains numerous separate programs that work together to process and load IPP data (in the form of batches) to the datastore, monitor the progress of those batches and then perform the necessary cleanup of the various temporary files once those batches are safely merged into the PSPS database.
    8686
    87 == Setting up a loading machine ==
    88 
    89 Although this can be changed in the config file, {{{ippToPsps}}} uses a 'scratch' MySQL database on {{{localhost}}} while processing. So, to run  {{{ippToPsps}}} a local MySQL server should be up-and-running, with a database created as the {{{ipp}}} user for use by {{{ippToPsps}}}. The default name for this is {{{ipptopsps_scratch}}}.
     87== Loading ==
     88
     89
     90=== Setting up a loading machine ===
     91
     92Although this can be changed in the config file, {{{ippToPsps}}} uses a 'scratch' MySQL database on {{{localhost}}} while processing. So, to to any loading, a local MySQL server should be up-and-running, with a database created as the {{{ipp}}} user for use by {{{ippToPsps}}}. The default name for this is {{{ipptopsps_scratch}}}.
    9093
    9194Because {{{ippToPsps}}} uses this local database as a scratch database, there are large number of inserts and deletions, meaning large log files. For this reason, it is important to configure MySQL to store its data on a local partition, and not {{{/var}}} as is the default. For example, on {{{ipp005}}}:
     
    113116}}}
    114117
    115 == Loading ==
     118At the time of writing, scratch databases are set up on the following IPP hosts:
     119
     120{{{
     121ipp005
     122ipp006
     123ipp007
     124ipp033
     125ipp034
     126}}}
     127
     128{{{ipp005}}} in fact has ''three'' scratch databases, so three clients can potentially be run on this machine. This is because {{{ipp005}}} is where the DVO databases are currently stored, so clients running on the same machine have a much higher throughput.
     129
     130=== Running ===
    116131
    117132Loading data means running the {{{load.py}}} program while passing it the relevant configuration file (see above). So, running the software is simply a case of editing a config and passing it as an argument to the program, like this: