Infrastructure
  1. Infrastructure
  2. INFRA-5711

offsite backup of translate-vm incl. mysql

    Details

    • Type: Task Task
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Fix Version/s: Initial Clearing
    • Component/s: Backups
    • Labels:
      None
    • Environment:
      ubuntu

      Description

      Currently there are no on-site or off-site backup of translate-vm. Offsite backup of mysql is highly needed, and /home/* (or at least jsc) is adviced, because it contains the synchronised copy of po files.

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Waiting for Infra Waiting for Infra Waiting for user Waiting for user
        17d 12h 19m 1 Tony Stevenson 15/Jan/13 11:20
        Waiting for user Waiting for user Waiting for Infra Waiting for Infra
        1d 8h 1 jan iversen 16/Jan/13 19:21
        Waiting for Infra Waiting for Infra Closed Closed
        7d 6h 54m 1 Gavin 24/Jan/13 02:15
        Gavin made changes -
        Fix Version/s Initial Clearing [ 12325964 ]
        Gavin made changes -
        Status Waiting for Infra [ 10011 ] Closed [ 6 ]
        Assignee Gavin [ ipv6guru ]
        Resolution Fixed [ 1 ]
        Hide
        Gavin added a comment -
        Done.

        root cron backs up database at 06:30 UTC
        backup cron backs up the backups dir offsite at 07:00 UTC

        Show
        Gavin added a comment - Done. root cron backs up database at 06:30 UTC backup cron backs up the backups dir offsite at 07:00 UTC
        Gavin made changes -
        Assignee Gavin [ ipv6guru ]
        Hide
        jan iversen added a comment -
        We have now eliminated to need for home dir. backup. /x1/aoo_workdir is a common workdir for aoo work.

        If wanted, then I can implement the same mysql dump we run on wiki2 (generate 1 dump file every day to a backup dir, and assume the backup program removes day-2 files).

        jan I
        Show
        jan iversen added a comment - We have now eliminated to need for home dir. backup. /x1/aoo_workdir is a common workdir for aoo work. If wanted, then I can implement the same mysql dump we run on wiki2 (generate 1 dump file every day to a backup dir, and assume the backup program removes day-2 files). jan I
        jan iversen made changes -
        Status Waiting for user [ 10010 ] Waiting for Infra [ 10011 ]
        Hide
        jan iversen added a comment -
        It can for sure be moved somewhere else, once the system is upgraded. In the meantime it would be nice to have a backup of the rest.

        Please be aware the structure of the vm is undergoing a change.

        And please do not only make it happen for mysql, but for the dynamic parts of the vm as well, or learn me how to send backup to the backup server, then I can do it as part of the upgrade.

        jan I.
        Show
        jan iversen added a comment - It can for sure be moved somewhere else, once the system is upgraded. In the meantime it would be nice to have a backup of the rest. Please be aware the structure of the vm is undergoing a change. And please do not only make it happen for mysql, but for the dynamic parts of the vm as well, or learn me how to send backup to the backup server, then I can do it as part of the upgrade. jan I.
        Tony Stevenson made changes -
        Field Original Value New Value
        Status Waiting for Infra [ 10011 ] Waiting for user [ 10010 ]
        Hide
        Tony Stevenson added a comment -
        WTF are we using /home/* for anything related to services. We do not backup home folders anywhere, other than on minotaur.

        Can I please suggest this is moved elsewhere.

        As for mysql, we can make this happen. Sure.
        Show
        Tony Stevenson added a comment - WTF are we using /home/* for anything related to services. We do not backup home folders anywhere, other than on minotaur. Can I please suggest this is moved elsewhere. As for mysql, we can make this happen. Sure.
        jan iversen created issue -

          People

          • Assignee:
            Unassigned
            Reporter:
            jan iversen
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development