| #!/bin/bash | |
| PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin | |
| netcat=$(which nc) | |
| host='<carbon IP>' | |
| port='2003' | |
| nc_cmd="$netcat -q0 $host $port" | |
| get_month(){ | |
| f="<your id>-aws-billing-detailed-line-items-with-resources-and-tags-${1}" |
| #!/bin/bash | |
| # currently support server_audit only!! | |
| # Requires: | |
| # working awscli | |
| # apt-get install lockfile-progs | |
| # required monitoring: | |
| # logwatch on $admin_log for the word 'ERROR' | |
| # log integrity check | |
| # locations: | |
| # script log - /var/log/rds/rds_getlogs.log |
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/SQLServer.Procedural.Importing.html
To back up your database, you call the rds_backup_database stored procedure.
Note You can't back up a database during the maintenance window, or any time Amazon RDS is in the process of taking a snapshot of the database. The following parameters are required:
| $ dm create -d virtualbox --virtualbox-boot2docker-url="file://$HOME/.docker/machine/cache/boot2docker.iso" machine-name |
| #!/bin/bash | |
| #set -x | |
| curl -s "$@" -w "\r\n=> total: %{time_total}s\r\n" |
| #!/bin/bash | |
| cat >> ~ec2-user/.ssh/authorized_keys << EOF | |
| ssh-rsa AAAAB3NzaC1yc2EAAAADAQABAAABAQC0QIiv+QYlGIlBc6FFNMQ1WDWfqV2DrpxK2owdDCXsofIoMEhR+QUU4crJ6sNrIe7hMtYbT8c8t487zZHqPbiktjH3rhDq5soeKpUpbcQAbVo9eIC5y4nSr4FoPxonhF0vF0e7keTzquoAVWGYzyyLqsTN8AuJ0aHpsuWrJSLRNoPE/jYkM+gQjp3qecKlgZ1WxOokBGzebufUhszBYwGCD0CT4iKiU4HIQXf+einBq/cEJvtDX5bbttsfaU4pPZ2EjM37o2RTzHpyzO42fn6nHi01Hw2xInPiEGlmwQGV1EK9hA7S77ZriYaVlWEsKWNsBfcjbkS3J4J+UMJBoxFB pahud@pahud-mb12.2016 | |
| EOF |
| instId=$(curl -s http://169.254.169.254/latest/meta-data/instance-id) | |
| deviceName='/dev/sdz' | |
| volId='vol-97f21469' | |
| region='ap-northeast-1' | |
| mountPoint='/o' | |
| aws --region $region ec2 attach-volume --device $deviceName --volume-id $volId --instance-id $instId && \ | |
| mount $deviceNmae $mountPoint |
| #!/bin/bash | |
| machine='docker-builder' | |
| export AWS_PROFILE='pahud' | |
| AWS_ACCESS_KEY_ID=$(aws configure get aws_access_key_id) | |
| AWS_SECRET_ACCESS_KEY=$(aws configure get aws_secret_access_key) | |
| VPC='vpc-xxxxxx' | |
| docker-machine create --driver amazonec2 \ |
| #!/bin/bash | |
| instanceid=$(curl -s http://169.254.169.254/latest/meta-data/instance-id) | |
| region=$(curl -s http://169.254.169.254/latest/dynamic/instance-identity/document | awk -F\" '/region/ {print $4}') | |
| ip=$(curl -s http://169.254.169.254/latest/meta-data/local-ipv4) | |
| free_space=$(docker info |grep "Data Space Available" |grep G |awk -F "." {'print $1'} |awk {'print $NF'}) | |
| metric_name='DockerFreeSpace' | |
| #!/bin/bash | |
| aws iam upload-server-certificate \ | |
| --server-certificate-name my-cert-name \ | |
| --certificate-body file://cert.pem \ | |
| --private-key file://privkey.pem \ | |
| --certificate-chain file://chain.pem |