Skip to content

Instantly share code, notes, and snippets.

View olublessed's full-sized avatar

olu olublessed

0 followers · 6 following
View GitHub Profile
@olublessed
olublessed / AWS API calls that return credentials.md
Created August 17, 2022 21:25 — forked from kmcquade/AWS API calls that return credentials.md
AWS API calls that return credentials
@olublessed
olublessed / gist:d0c8474aef81e175a094afb8219ed98c
Created August 3, 2022 15:55 — forked from iann0036/gist:b473bbb3097c5f4c656ed3d07b4d2222
List of expensive / long-term effect AWS IAM actions
route53domains:RegisterDomain
route53domains:RenewDomain
route53domains:TransferDomain
ec2:ModifyReservedInstances
ec2:PurchaseHostReservation
ec2:PurchaseReservedInstancesOffering
ec2:PurchaseScheduledInstances
rds:PurchaseReservedDBInstancesOffering
dynamodb:PurchaseReservedCapacityOfferings
s3:PutObjectRetention
@olublessed
olublessed / gist:1e95837f3e30a2a17097e80b9a8b0b2e
Created April 15, 2022 13:53 — forked from pitch-gist/gist:2999707
HTML: Simple Maintenance Page
<!doctype html>
<title>Site Maintenance</title>
<style>
body { text-align: center; padding: 150px; }
h1 { font-size: 50px; }
body { font: 20px Helvetica, sans-serif; color: #333; }
article { display: block; text-align: left; width: 650px; margin: 0 auto; }
a { color: #dc8100; text-decoration: none; }
a:hover { color: #333; text-decoration: none; }
</style>
@olublessed
olublessed / info.md
Created November 1, 2018 22:44 — forked from manicminer/info.md
RDS Production termination protection

RDS Production Termination Protection

Create a policy like this, substituting your AWS account number, then attach it to all groups and roles. It will prevent deletion of RDS instances containing the string "prod" in their name.

Note: This is intended to prevent accidental deletion, and is easily sidestepped.

@olublessed
olublessed / mysql-docker.sh
Created July 10, 2018 13:39 — forked from spalladino/mysql-docker.sh
Backup and restore a mysql database from a running Docker mysql container
# Backup
docker exec CONTAINER /usr/bin/mysqldump -u root --password=root DATABASE > backup.sql
# Restore
cat backup.sql | docker exec -i CONTAINER /usr/bin/mysql -u root --password=root DATABASE
@olublessed
olublessed / sql_backup.sh
Created August 23, 2017 19:33 — forked from niraj-shah/sql_backup.sh
Amazon S3 Backup Script for MySQL Databases
#!/bin/bash
# Shell script to backup MySql database
# CONFIG - Only edit the below lines to setup the script
# ===============================
MyUSER="root" # USERNAME
MyPASS="password" # PASSWORD
MyHOST="localhost" # Hostname
@olublessed
olublessed / Bash MySQL backupo script
Created July 27, 2017 21:21 — forked from walterheck/Bash MySQL backupo script
Backup script for MySQL backups locally, both mysqldumps and binary backupos using percona's xtrabackup
#!/bin/bash
# Configuration
. /etc/mysql/mysql_backup.conf
# Dump the mysql databases to a daily dump file.
function log()
{
logger -i -p daemon.info -t mysqldump "$1"
echo $1 >> $LOGFILE
@olublessed
olublessed / mysql_secure.sh
Created July 25, 2017 14:23 — forked from Mins/mysql_secure.sh
Automating mysql_secure_installation
#!/bin/bash
aptitude -y install expect
// Not required in actual script
MYSQL_ROOT_PASSWORD=abcd1234
SECURE_MYSQL=$(expect -c "
set timeout 10
@olublessed
olublessed / clean.sh
Created July 21, 2017 21:07 — forked from codersofthedark/clean.sh
MySQL Replication: 'Duplicate entry for PRIMARY key'
while [ 1 ]; do if ['mysql -uroot -ppassword -e"show slave status \G;" | grep "Duplicate entry" | wc -l' -eq 2 ] ; then mysql -uroot -ppassword -e"stop slave; set global sql_slave_skip_counter=1; start slave;"; fi; sleep 1; mysql -uroot -ppassword -e"show slave status\G"; done