Upgrading your Matillion ETL for Amazon Redshift instance size
When you first launch Matillion ETL for Amazon Redshift, you must choose which instance size you’d like to use. This is the main factor which determines the hourly cost. Different instance sizes have different capabilities and limits, which are documented in our “Choosing an Instance Size” page. Some of Matillion’s enterprise features are only available on the larger instance sizes. You’re not stuck with one choice forever: the EC2 platform makes it easy to change your mind and scale up or down.
Changing your instance sizeThe first thing to check is what instance size you’re currently using. To do this go to the Help / Support Information menu, and scroll down to the Type: To change the Type of the Matillion instance, you’ll need to use the AWS EC2 console.
The AWS EC2 consoleAfter logging in to the main AWS Management Console, use the Services menu to go to the EC2 dashboard, and click the Instances option. The screenshot below shows one running EC2 instance, which is Matillion ETL for Amazon Redshift. You may have more than one running instance, in which case it’s important that you identify the right one! Select the Matillion instance, and choose Actions / Instance State / Stop. Do not choose Terminate at this point! The Terminate option would permanently remove the instance: it would be lost and you would never have the opportunity to re-start it. It should take a few seconds for the instance state to change to “stopped”. At this point the instance is no longer running, but its state has been saved and you can make changes to the virtual hardware. Choose Actions / Change Instance Type and select the desired instance type from the dropdown: for example m4.large. Now the instance can be started again, using the Actions / Instance State menu. This step might take a couple of minutes, and you should wait until the Instance State is shown as Running, and the status checks are green. Once this has happened, you should be able to log back into Matillion using the web interface. The new instance will have all the same jobs and metadata that were there before, although the public and private IP addresses will probably have changed. If you’ve upgraded from a t2.medium to one of the m4 types, you’ll now have access to all of Matillion’s enterprise features. The steps are identical if you want to change to a smaller instance size: simply choose one of the supported types from the “Change Instance Type” menu while the instance is in a “stopped” state. You can change instance size up or down as required.
Next StepsAfter changing instance size, Annual customers need to perform one extra step to keep their subscription in line with the running instance size. Please take a look at the technical document for more detailed instructions. There’s also a video guide on our YouTube channel which shows all the above steps. https://www.youtube.com/watch?v=DKsmnoPtwF8
Manager of Developer Relations
Data Mesh vs. Data Fabric: Which Approach Is Right for Your Organization? Part 3
In our recent exploration, we've thoroughly analyzed two key ...eBooks
10 Best Practices for Maintaining Data Pipelines
Mastering Data Pipeline Maintenance: A Comprehensive GuideBeyond ...News
Matillion Adds AI Power to Pipelines with Amazon Bedrock
Data Productivity Cloud adds Amazon Bedrock to no-code generative ...