Skip to content

Changes

Page history
Update Aliases authored by Jason Buckner's avatar Jason Buckner
Show whitespace changes
Inline Side-by-side
Home/Aliases.md
View page @ d292cf9b
...@@ -114,4 +114,16 @@ $ profileBListInstances --output json ...@@ -114,4 +114,16 @@ $ profileBListInstances --output json
``` ```
# TODO:
* Info on how to use mysql_config_editor
* Info on how ton configure mysql prompt
* Put together documentation on ssh-tunnel for connecting to RDS instances
* https://stackoverflow.com/questions/2241063/bash-script-to-setup-a-temporary-ssh-tunnel/15198031#15198031
```
alias demo-rds-connect="ssh -M -S pops-rds-ctrl-socket -fnNT -L 3307:popsdemo.cv47gypka7vd.us-east-1.rds.amazonaws.com:3306 -i ~/.ssh/keys/podium-ec2-keypair.pem ec2-user@35.153.126.149 pops@demo.com ; mysql --login-path=demo-podium podium_empty --prompt=\"\u@popsdemo> \""
alias demo-rds-check-tunnel="ssh -S pops-rds-ctrl-socket -O check pops@demo.com"
alias demo-rds-kill-tunnel="ssh -S pops-rds-ctrl-socket -O exit pops@demo.com"
```
[^1]: Note that the '--query' parameter to the `aws ec2 describe-instances` call is based on JMESPath query http://jmespath.org/specification.html#. This query is extracting the instance state, instance-id, and name. The name is extracted from the value of a 'tag' added to the EC2 instances. If your instances have not been tagged, the name will not appear in the output. [^1]: Note that the '--query' parameter to the `aws ec2 describe-instances` call is based on JMESPath query http://jmespath.org/specification.html#. This query is extracting the instance state, instance-id, and name. The name is extracted from the value of a 'tag' added to the EC2 instances. If your instances have not been tagged, the name will not appear in the output.
\ No newline at end of file