Tuesday, June 18, 2019

Redshift

Tool: https://app.jackdb.com   2. Copy data from S3 copy supplier from 's3://us-west-2-aws-training/awsu-spl/redshift-quest/supplier/supplier.json' CREDENTIALS 'aws_access_key_id=<YOUR-ACCESS-KEY-ID>;aws_secret_access_key=<YOUR-SECRET-ACCESS-KEY>' lzop delimiter '|' COMPUPDATE ON manifest; Check collum:   3. Debug select * from stl_load_errors; // Create view create view...

How To Set Up Automatic Deployment with Git with a VPS

When you use Git, the workflow generally is toward version control only. You have a local repository where you work and a remote repository...

Adminstering RDS for SQL Server

Task: + Create DB instance + Scale DB + Access DB + Perform migration of large data to RDS   + DB backup + Recover from backup + Configure Cloudwatch to monitor...

Autoscaling with spot instance and cloudwatch

Sample cli:  

Using PowerShell to manage AWS Service

get-ec2instance Create ec2 instance: New-EC2Instance -ImageId <AMI_ID> -KeyName <Key_Name> -SecurityGroups launch-wizard-1 -InstanceType m3.medium Modify instance: $instance1 = Get-EC2Instance -Filter @{Name = "reservation-id"; Values = "<ReservationID>"} Delete instance: Stop-EC2Instance $instance1 –Terminate   2....

Protected: Blue/Green Deployment Pattern with AWS Elastic Beanstalk

Sample code: Using EB CLI to manage application deployment process http://docs.aws.amazon.com/elasticbeanstalk/latest/dg/command-options-general.html Rolling update: http://docs.aws.amazon.com/elasticbeanstalk/latest/dg/command-options-general.html#command-options-general-autoscalingupdatepolicyrollingupdate  

Deploying an HTML5 and WebSocket Game on AWS

Deploy web app using EBeanTalk using CLI. Configure Auto Scaling and Load Balancing. Manage game and session data using SQS and Elastic Cache. Sample code:  

Protected: Building Scalable Web Applications with AWS Elastic Beanstalk – Linux

Using git and AWS CLI to deploy web application on Elastic BeanTalk Sample code: http://docs.aws.amazon.com/elasticbeanstalk/latest/dg/ebextensions.html http://docs.aws.amazon.com/elasticbeanstalk/latest/dg/customize-containers-windows-ec2.html   Management: Blue and Green Pattern https://run.qwiklab.com/focuses/2609?locale=en S3 CLIs EC2: aws ec2 create-snapshot --description CLI --volume-id <your-volume-id> Cloud...

Protected: Introduction to Amazon DynamoDB

Programming with .NET