I am managing an AWS instance of Matillion ETL for a client. They have no real IT or AWS engineers, and I am not experienced as an AWS admin. Following Matillion instructions, I installed the AMI with version 1.59.8 a few years ago. We have been stable in production during this time with no Matillion version updates since the one in-place update I did in the very beginning.
Although it is a good idea to update to the latest software in general, I have been holding off with Matillion because I do not want to do an "update in-place" which has risks. I am wondering if others have avoided updating the version, or if they have updated - can they provide me some steps on how to safely do this?
Some background: I have only one instance of Matillion. Using the Matillion UI, I scheduled nightly EBS snapshots in AWS. They have been running (and stacking up) all this time. I have never tested a restore, but I can confirm the snapshots are current. I also do full project exports when I perform a release (2x month).
I'd appreciate any instructions on how to test the update of Matillion in a parallel environment.
I have only verified that EBS snapshots are being taken nightly to backup my Matillion AWS instance. I also have used project imports and exports, but never a restore from the EBS snapshots.
There are 2 options for updating Matillion: https://documentation.matillion.com/docs/6688312
My experience has been that the in place updates work fine. I have done them many times over 3 years and never had a single issue.
Note also that if you want to upgrade to 1.69 or later, then migrate is the only option. In place updates will only take you to 1.68. 1.69 release notes