Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-16660

Deploy SQuaSH API to production and update InfluxDB with validate_drp results

    Details

    • Type: Story
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      • Redeploy InlfuxDB with a persistent volume for /data in the influxdb-demo cluster.
      • Use the method outlined in DM-15888 to write SQuaSH prod results to InfluxDB.
      • Deploy the SQuaSH API to production after DM-16300
      • Update metric definitions and specs

        Attachments

          Issue Links

            Activity

            Hide
            afausti Angelo Fausti added a comment - - edited

            We want to preserve squash-demo before redepoying InfluxDB with a persistent volume.

            Procedure for backup/restore a database:

            $ kubectl exec -it <origin pod>  -- influxd backup -portable -database squash-demo ./squash-demo.influx
             
            $ kubectl cp <origin pod>:./squash-demo.influx squash-demo.influx
             
            <change context if needed>
             
            $ kubectl cp ./squash-demo.influx <dest pod>:./squash-demo.influx
             
            $ kubectl exec -it <dest pod> -- influxd restore -portable -db squash-demo ./squash-demo.influx
             
            
            

            Show
            afausti Angelo Fausti added a comment - - edited We want to preserve squash-demo before redepoying InfluxDB with a persistent volume. Procedure for backup/restore a database: $ kubectl exec -it <origin pod> -- influxd backup -portable -database squash-demo ./squash-demo.influx   $ kubectl cp <origin pod>:./squash-demo.influx squash-demo.influx   <change context if needed>   $ kubectl cp ./squash-demo.influx <dest pod>:./squash-demo.influx   $ kubectl exec -it <dest pod> -- influxd restore -portable -db squash-demo ./squash-demo.influx  
            Hide
            afausti Angelo Fausti added a comment -

            Added notebook reproduces what the SQuaSH API InfluxDB Celery does, and can be used to "manually" synchronize the SQuaSH production data with an InfluxDB instance.
            https://github.com/lsst-sqre/squash-restful-api/pull/40

            Show
            afausti Angelo Fausti added a comment - Added notebook reproduces what the SQuaSH API InfluxDB Celery does, and can be used to "manually" synchronize the SQuaSH production data with an InfluxDB instance. https://github.com/lsst-sqre/squash-restful-api/pull/40
            Hide
            afausti Angelo Fausti added a comment -

            Production SQuaSH API updated and metrics definitions and specs were updated.

            Show
            afausti Angelo Fausti added a comment - Production SQuaSH API updated and metrics definitions and specs were updated.
            Show
            afausti Angelo Fausti added a comment - https://github.com/lsst-sqre/squash-restful-api/pull/40

              People

              • Assignee:
                afausti Angelo Fausti
                Reporter:
                afausti Angelo Fausti
                Watchers:
                Angelo Fausti
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Summary Panel