Now Available On-Demand | AI. The Future of Data Engineering - Today. Not Just Tomorrow.

Watch now

Upgrading your Matillion ETL for Amazon Redshift instance size

changing 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 size

The 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:   upgrading your instance size matillion etl amazon redshift   To change the Type of the Matillion instance, you’ll need to use the AWS EC2 console.

The AWS EC2 console

After 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!   upgrading your instance size matillion etl amazon redshift 2 ec2 dashboard   Select the Matillion instance, and choose Actions / Instance State / Stop.   upgrading your instance size matillion etl amazon redshift 3 actions   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”.   upgrading your instance size matillion etl amazon redshift instance 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.   upgrading your instance size matillion etl amazon redshift instance state   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.   upgrading your instance size matillion etl amazon redshift status   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 Steps

After 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.
Ian Funnell
Ian Funnell

Data Alchemist

Ian Funnell, Data Alchemist at Matillion, curates The Data Geek weekly newsletter and manages the Matillion Exchange.