Understand AWS Redshift Query Execution Plan  [draft]

May 9, 2018 · 0 min · 0 words · Eric

2017 AWS Summit Auckland

TL;DR There are not many valuable gifts so no need to go early Sponsor’s keynote are all like product promoting session Do check the speaker’s background before choosing any session If you just want to know technical information, try to avoid product people’s talk No need for laptop or notebook, smart phones can handle everything If you want to get more gifts, you need to talk with more sponsors If you find the keynote is boring, don’t waste your time Keynotes Modern Data Architecture on AWS / SQL Strikes Back!...

June 1, 2017 · 3 min · 614 words · Eric

AWS Concept

CloudWatch CloudWatch’s Free Tier metric update frequency is 5 minutes In the Detailed monitoring data available for your EBS volumes, provisioned IOPS volumes automatically send 1 minute metrics to CloudWatch. EBS EC2 ec2-revoke RevokeSecurityGroupIngress means remove one or more rules from a security group. The value you specify in the revoke request must be existing rule’s value for the rule to be removed. ec2-create-group CreateSecurityGroup means create a security group for use with your account....

May 7, 2017 · 3 min · 503 words · Eric

Unable to SSH AWS EC2 Instance

Yesterday when I tried to ssh to remote EMR cluster, it raised this problem 1 2 3 4 5 6 7 8 9 10 11 12 13 14 [ec2-user@ds-uat-airflow1 ~]$ ssh -i ~/YOUR_SECRET.pem hadoop@ip-YOUR_IP_ADDRESS.us-west-2.compute.internal @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ @ WARNING: REMOTE HOST IDENTIFICATION HAS CHANGED! @ @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ IT IS POSSIBLE THAT SOMEONE IS DOING SOMETHING NASTY! Someone could be eavesdropping on you right now (man-in-the-middle attack)! It is also possible that a host key has just been changed....

December 13, 2016 · 1 min · 187 words · Eric