Research about amazon server

https://namvuhn.wordpress.com/2015/08/04/aws-tim-hieu-ve-dich-vu-amazon-ec2/
http://codingsoup.com/2014/02/aws-tu-khi-dang-ky-dich-vu-den-hoan-thanh-website-phpapache/
http://quantrimang.com/tim-hieu-ve-dich-vu-amazon-ec2-83626

http://www.ibm.com/developerworks/vn/library/ar-cloudaws1/
http://www.ibm.com/developerworks/vn/library/ar-cloudaws2/



Compute
EC2
Virtual Servers in the Cloud

EC2 Container Service
Run and Manage Docker Containers

Elastic Beanstalk
Run and Manage Web Apps

Lambda
Run Code in Response to Events

Storage & Content Delivery 
S3
Scalable Storage in the Cloud

CloudFront
Global Content Delivery Network

Elastic File System
Fully Managed File System for EC2

Glacier
Archive Storage in the Cloud

Import/Export Snowball
Large Scale Data Transport

Storage Gateway
Integrates On-Premises IT Environments with Cloud Storage

Database
 RDS
Managed Relational Database Service

DynamoDB
Predictable and Scalable NoSQL Data Store

ElastiCache
In-Memory Cache

Redshift
Managed Petabyte-Scale Data Warehouse Service

Networking
 VPC
Isolated Cloud Resources

Direct Connect
Dedicated Network Connection to AWS

Route 53
Scalable DNS and Domain Name Registration

Developer Tools
 CodeCommit
Store Code in Private Git Repositories

CodeDeploy
Automate Code Deployments

CodePipeline
Release Software using Continuous Delivery

Management Tools
 CloudWatch
Monitor Resources and Applications

CloudFormation
Create and Manage Resources with Templates

CloudTrail
Track User Activity and API Usage

Config
Track Resource Inventory and Changes

OpsWorks
Automate Operations with Chef

Service Catalog
Create and Use Standardized Products

Trusted Advisor
Optimize Performance and Security

Security & Identity
 Identity & Access Management
Manage User Access and Encryption Keys

Directory Service
Host and Manage Active Directory

Inspector
Analyze Application Security

WAF
Filter Malicious Web Traffic

Analytics
EMR
Managed Hadoop Framework

Data Pipeline
Orchestration for Data-Driven Workflows

Elasticsearch Service
Run and Scale Elasticsearch Clusters

Kinesis
Work with Real-time Streaming data

Machine Learning
Build Smart Applications Quickly and Easily

Internet of Things
AWS IoT
Connect Devices to the cloud


Mobile Services
Mobile Hub
Build, Test, and Monitor Mobile apps

Cognito
User Identity and App Data Synchronization

Device Farm
Test Android, Fire OS, and iOS apps on real devices in the Cloud

Mobile Analytics
Collect, View and Export App Analytics

SNS
Push Notification Service

Application Services
API Gateway
Build, Deploy and Manage APIs

AppStream
Low Latency Application Streaming

CloudSearch
Managed Search Service

Elastic Transcoder
Easy-to-use Scalable Media Transcoding

SES
Email Sending Service

SQS
Message Queue Service

SWF
Workflow Service for Coordinating Application Components


Enterprise Applications
WorkSpaces
Desktops in the Cloud

WorkDocs
Secure Enterprise Storage and Sharing Service

WorkMail
Secure Email and Calendaring Service

Enabling Slow Query Log for MySQL on Amazon AWS EC2 Ubuntu Based AMI

There are two methods using which slow query logs can be enabled for MySQL.

Changing Global Variables

This is runtime approach for logging slow query. MySQL server restart is not needed in this case. But, these changes go away with MySQL server restart or machine reboot.

These are the steps to log slow MySQL queries:

1. Login to MySQL shell

$ mysql -p -u root
Welcome to the MySQL monitor.  Commands end with ; or g.
mysql>

2. Enable slow query logging

mysql> set global slow_query_log = 1;

0=logging disabled, 1= logging enabled, default is 0.

3. Set log file location

mysql> set global slow_query_log_file='/location/of/log/file/mysql-slow.log';

Default location of file is “/var/log/mysql/mysql-slow.log”. Make sure the file has the appropriate permissions.

4. Set Long Query Time

mysql> set global long_query_time=integer_time_in_seconds;

SQL statements that took more than ‘long_query_time’  seconds to execute will be logged to the log file specified above.

Changing Config File (my.cnf)

This will require MySQL server to restart. These changes persist when the MySQL server restart or machine reboot.

We need to edit my.cnf file. It is usually located in /etc/mysql/ directory

$ sudo vi /etc/mysql/my.cnf

Go to “[mysqld]” section and uncomment following lines and make change

log_slow_queries = /location/of/log/file/mysql-slow.log
long_query_time = integer_time_in_seconds

ERROR 29 (HY000)

Make sure the log file (/location/of/log/file/ in above example) has proper permission. Else or following error may appear:

ERROR 29 (HY000): File '/location/of/log/file/mysql-slow.log' not found (Errcode: 13)

Ensuring right permissions is sufficient

$ sudo chmod -R o+w /location/of/log/file/

AppArmor Related Issues

Recent Ubuntu Server Editions comes with AppArmor and MySQL’s profile might be in enforcing mode by default. This is common in some of AWS EC2 AMIs.

1. Run following command to check

$ sudo aa-status
Apparmor module is loaded.
 5 profiles are loaded.
 5 profiles are in enforce mode.
 /sbin/dhclient
 /usr/lib/NetworkManager/nm-dhcp-client.action
 /usr/lib/connman/scripts/dhclient-script
 /usr/sbin/mysqld
 /usr/sbin/tcpdump
 0 profiles are in complain mode.
 2 processes have profiles defined.
 2 processes are in enforce mode.
 /sbin/dhclient (646)
 /usr/sbin/mysqld (2062)
 0 processes are in complain mode.
 0 processes are unconfined but have a profile defined.

2. If mysqld is listed as in above output, make following change: Edit /etc/apparmor.d/usr.sbin.mysqld

$ sudo vi  /etc/apparmor.d/usr.sbin.mysqld

3. Enter following line at the end of file:

/location/of/log/file/* rw,

4. Now reload apparmor

sudo /etc/init.d/apparmor reload

How to sftp to amazon EC2

1. add new user for your amazon server ec2:

sudo adduser paul

sudo adduser paul sudo 

2. Connect with sftp:

sftp -o IdentityFile=keyfile.pem paul@yourdomainname