Announcement

Collapse
No announcement yet.

Worst Nightmare during maintenance

Collapse
This topic is closed.
X
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Worst Nightmare during maintenance

    Apologies for the site being down all weekend! I ran into an issue with the database and I ended up having to restore from the daily backups which today is a bit of a process to unzip the base and then all the incremental backups. The good news is that the restore procedure works. The bad news is that the system maintenance that I was trying to do was an epic fail and I will have to open a support ticket with vb to see why I have duplicate keys in one of the tables that breaks the patch they provided.

    That was quite the scare for me! Always have a good backup strategy and procedures on how to restore.

    Time for bed now, I'm exhausted after this exercise 😅
    Painter in training

  • #2
    It's always wise to back up the database (full backup/dump) and any other files before doing maintenance. That way if anything goes sideways you have an easier restore path.

    If you're running VMs you could use snapshots too, for an even quicker restore path.

    Comment


    • #3
      Originally posted by Kevin P View Post
      It's always wise to back up the database (full backup/dump) and any other files before doing maintenance. That way if anything goes sideways you have an easier restore path.

      If you're running VMs you could use snapshots too, for an even quicker restore path.
      I'm using AWS now to host the website and working towards automating the deployment of it to be able to rebuild on the fly. I use a VM for local testing at this time. Containers are where I would like to go to be able to upgrade or downgrade on the fly. It would be cool to leverage Kubernetes for the auto scaling and rolling upgrades.
      Painter in training

      Comment

      Working...
      X