Common: add NAT Gateway fix script

[chuwy]

A long-standing issue when RDB Loader behind NAT Gateway failed each time after 2 hours with Connection reset by peer message was fixed by following script:

#!/bin/sh

sudo /sbin/sysctl -w net.ipv4.tcp_keepalive_time=200 net.ipv4.tcp_keepalive_intvl=200 net.ipv4.tcp_keepalive_probes=5

This should live probably in this repository as issue appeared only for RDB Loader. Or snowplow/snowplow along with snowplow-ami4-bootstrap-0.2.0.sh, @alexanderdean?

[alexanderdean]

Let's go for the second option - in snowplow/snowplow, as this is only a problem when running RDB Loader from EMR.

I don't know if this should go alongside snowplow-ami4-bootstrap-0.2.0.sh, or if we should create a snowplow-ami5-bootstrap-0.3.0.sh and include this in it...

[chuwy]

in snowplow/snowplow, as this is only a problem when running RDB Loader from EMR

Not sure what connection between snowplow/snowplow and EMR was assumed, but moving this ticket there snowplow/snowplow#3601

[alexanderdean]

Not sure what connection between snowplow/snowplow and EMR was assumed

The code that hosts the operation of Snowplow apps on EMR is all in EmrEtlRunner, in snowplow/snowplow...