Alexey Baikov sysboss

DevOps Engineer

sysboss / query_athena.py

Created May 21, 2018 15:41

SQL Query Amazon Athena using Python

	#!/usr/bin/env python3
	#
	# Query AWS Athena using SQL
	# Copyright (c) Alexey Baikov <sysboss[at]mail.ru>
	#
	# This snippet is a basic example to query Athen and load the results
	# to a variable.
	#
	# Requirements:
	# > pip3 install boto3 botocore retrying

sysboss / ec2_tags_as_bash_variables.sh

Created August 21, 2017 10:24

Get all EC2 tags and set them as Bash variables

	#!/bin/bash
	#
	# EC2 tags to variables
	# Copyright (c) Alexey Baikov <sysboss[at]mail.ru>
	#
	# Description:
	# Gets all EC2 tags and converts them to Bash variables
	# Based on 'jq' (https://stedolan.github.io/jq/)

	INSTANCE_REGION="$(curl -s http://169.254.169.254/latest/dynamic/instance-identity/document \| grep region \| tr -d ' ' \| cut -f2 -d: \| tr -d '"' \| tr -d ',')"

gene1wood / role_arn_to_session.py

Created December 29, 2016 17:38

Simple python function to assume an AWS IAM Role from a role ARN and return a boto3 session object

	import boto3

	def role_arn_to_session(**args):
	"""
	Usage :
	session = role_arn_to_session(
	RoleArn='arn:aws:iam::012345678901:role/example-role',
	RoleSessionName='ExampleSessionName')
	client = session.client('sqs')
	"""

eladnava / mongodb-s3-backup.sh

Last active September 13, 2024 11:42

Automatically backup a MongoDB database to S3 using mongodump, tar, and awscli (Ubuntu 14.04 LTS)

	#!/bin/sh

	# Make sure to:
	# 1) Name this file `backup.sh` and place it in /home/ubuntu
	# 2) Run sudo apt-get install awscli to install the AWSCLI
	# 3) Run aws configure (enter s3-authorized IAM user and specify region)
	# 4) Fill in DB host + name
	# 5) Create S3 bucket for the backups and fill it in below (set a lifecycle rule to expire files older than X days in the bucket)
	# 6) Run chmod +x backup.sh
	# 7) Test it out via ./backup.sh

glamp / modify-docker-image.md

Created July 23, 2015 20:19

Modifying an Existing Docker Image

To install a custom package or modify an existing docker image we need to