This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
route53domains:RegisterDomain | |
route53domains:RenewDomain | |
route53domains:TransferDomain | |
ec2:ModifyReservedInstances | |
ec2:PurchaseHostReservation | |
ec2:PurchaseReservedInstancesOffering | |
ec2:PurchaseScheduledInstances | |
rds:PurchaseReservedDBInstancesOffering | |
dynamodb:PurchaseReservedCapacityOfferings | |
s3:PutObjectRetention |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<!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> |
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.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# 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 | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
ERROR 1146 (42S02) at line 31 in file: './views/p_s/ps_check_lost_instrumentation_57.sql': Table 'performance_schema.global_status' doesn't exist | |
ERROR 1146 (42S02) at line 32 in file: './views/p_s/memory_by_user_by_current_bytes.sql': Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist | |
ERROR 1146 (42S02) at line 32 in file: './views/p_s/x_memory_by_user_by_current_bytes.sql': Table 'performance_schema.memory_summary_by_user_by_event_name' doesn't exist | |
ERROR 1146 (42S02) at line 32 in file: './views/p_s/memory_by_host_by_current_bytes.sql': Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist | |
ERROR 1146 (42S02) at line 32 in file: './views/p_s/x_memory_by_host_by_current_bytes.sql': Table 'performance_schema.memory_summary_by_host_by_event_name' doesn't exist | |
ERROR 1146 (42S02) at line 35 in file: './views/p_s/memory_by_thread_by_current_bytes.sql': Table 'performance_schema.memory_summary_by_thread_by_event_name' doesn't exist | |
ERROR 1146 (42S02) at line 35 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Get:38 http://archive.ubuntu.com precise-security/universe i386 Packages [197 kB] | |
Fetched 28.5 MB in 42s (666 kB/s) | |
Reading package lists... | |
W: GPG error: http://repo.percona.com precise Release: The following signatures couldn't be verified because the public key is not available: NO_PUBKEY 9334A25F8507EFA5 | |
WARNING: The following packages cannot be authenticated! | |
libmysqlclient18 percona-xtrabackup | |
E: There are problems and -y was used without --force-yes | |
The command '/bin/sh -c apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A && sed -i '/repo.percona.com/d' /etc/apt/sources.list && sh -c 'echo "deb http://repo.percona.com/apt precise main" >> /etc/apt/sources.list' && sh -c 'echo "deb-src http://repo.percona.com/apt precise main" >> /etc/apt/sources.list' && apt-get -q -y update && apt-get -o Dpkg::Options::='--force-confnew' -qqy install nano wget psmisc libdbi-perl libdbd-mysql-perl libwrap0 perl libaio1 mysql-client percona-xtrabackup libssl0.9.8 libssl1.0.0 rsync netcat && wget --n |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
RUN apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A && sed -i '/repo.percona.com/d' /etc/apt/sources.list && sh -c 'echo "deb http://repo.percona.com/apt precise main" >> /etc/apt/sources.list' && sh -c 'echo "deb-src http://repo.percona.com/apt precise main" >> /etc/apt/sources.list' apt-get -q -y update && apt-get -o Dpkg::Options::='--force-confnew' -qqy install nano wget psmisc libdbi-perl libdbd-mysql-perl libwrap0 perl libaio1 mysql-client percona-xtrabackup libssl0.9.8 libssl1.0.0 rsync netcat && wget --no-check-certificate https://launchpad.net/codership-mysql/5.5/5.5.34-25.9/+download/mysql-server-wsrep-5.5.34-25.9-amd64.deb && wget --no-check-certificate https://launchpad.net/galera/2.x/25.2.8/+download/galera-25.2.8-amd64.deb && dpkg -i galera-25.2.8-amd64.deb && dpkg -i mysql-server-wsrep-5.5.34-25.9-amd64.deb |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# # MySQL Galera Cluster 5.5.34-25.9/Galera 2.8/Ubuntu 12.04 64bit | |
FROM ubuntu:12.04 | |
MAINTAINER Severalnines AB <[email protected]> | |
RUN apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A | |
RUN sed -i '/repo.percona.com/d' /etc/apt/sources.list | |
RUN sh -c 'echo "deb http://repo.percona.com/apt precise main" >> /etc/apt/sources.list' | |
RUN sh -c 'echo "deb-src http://repo.percona.com/apt precise main" >> /etc/apt/sources.list' | |
RUN apt-get -q -y update | |
RUN LC_ALL=en_US.utf8 DEBIAN_FRONTEND=noninteractive apt-get -o Dpkg::Options::='--force-confnew' -qqy install nano wget psmisc libdbi-perl libdbd-mysql-perl libwrap0 perl libaio1 mysql-client percona-xtrabackup libssl0.9.8 libssl1.0.0 rsync netcat |
NewerOlder