Skip to content

Instantly share code, notes, and snippets.

View dedunumax's full-sized avatar

Dedunu Dhananjaya dedunumax

21 followers · 2 following
View GitHub Profile
@dedunumax
dedunumax / RDS.tf
Created February 5, 2020 13:20
resource "aws_db_instance" "mydb" {
engine = "mysql"
engine_version = "5.6.40"
instance_class = "db.t1.micro"
name = "initial_db"
username = "example"
password = "1234"
allocated_storage = "20"
publicly_accessible = "true"
}
@dedunumax
dedunumax / blogger-theme.xml
Last active August 24, 2020 12:01
Theme used in https://travel.dedunu.info
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE html>
<html b:version='2' class='v2' expr:dir='data:blog.languageDirection' expr:lang='data:blog.locale' xmlns='http://www.w3.org/1999/xhtml' xmlns:b='http://www.google.com/2005/gml/b' xmlns:data='http://www.google.com/2005/gml/data' xmlns:expr='http://www.google.com/2005/gml/expr'>
<head>
<meta content='width=device-width, initial-scale=1.0' name='viewport'/>
<meta content='A travel blog.' name='description'/>
<b:include data='blog' name='all-head-content'/>
<link href='{{ site.baseurl }}/favicon.png' rel='shortcut icon'/>
<link href='https://cdn.rawgit.com/dreampulse/computer-modern-web-font/master/fonts.css' rel='stylesheet' type='text/css'/>
<title>travel - Dedunu Dhananjaya</title>
@dedunumax
dedunumax / production_bridge.sh
Last active April 20, 2020 21:28
function prod() {
ssh -A luser@laptop -C 'osascript -e "tell application \"Terminal\" to set current settings of front window to settings set \"Red Alert\""'
ssh -A buser@bridge.company.org
ssh -A luser@laptop -C 'osascript -e "tell application \"Terminal\" to set current settings of front window to settings set \"Ubuntu\""'
}
@dedunumax
dedunumax / virtual.sh
Created April 20, 2020 21:27
function virt() {
osascript -e "tell application \"Terminal\" to set current settings of front window to settings set \"Ubuntu\""
ssh -Ap 5001 vuser@virtual-server
osascript -e "tell application \"Terminal\" to set current settings of front window to settings set \"One Dark\""
}
@dedunumax
dedunumax / pg_loader_sample.load
Created March 5, 2020 10:43
LOAD DATABASE
FROM mysql://root:Password123@mysqldb.example.com/real_db
INTO pgsql://postgres:Password456@pgserver101.example.com/adventure_db
WITH include drop, create tables
SET search_path to 'public'
INCLUDING ONLY TABLE NAMES MATCHING 'user'
@dedunumax
dedunumax / pg_loader_example.load
Created March 5, 2020 10:40
LOAD DATABASE
FROM mysql://<mysql_user>:<mysql_password>@<mysql_host>/<source_databases>
INTO pgsql://<postgres_user>:<postgres_password>@<postgres_host>/<target_database>
WITH INCLUDE DROP, CREATE TABLES
SET search_path to 'public'
INCLUDING ONLY TABLE NAMES MATCHING 'sample_table'
@dedunumax
dedunumax / terraform_err.tf
Created February 26, 2020 18:50
Acquiring state lock. This may take a few moments...
Error: Error locking state: Error acquiring the state lock: ConditionalCheckFailedException: The conditional request failed
status code: 400, request id: L2CH7KK3QCAEHSC1TJ1VLBMNBRVV4CQNSO5AEMVJY66Q9ASUAAJN
Lock Info:
ID: 21e2b2bb-c123-2383-eece-7a5eaab4f645
Path: s3/path/to/the/state/file
Operation: OperationTypePlan
Who: username@hostname
Version: 0.11.14
@dedunumax
dedunumax / current_trx.sql
Last active February 26, 2020 18:42
SELECT *
FROM information_schema.innodb_trx
WHERE trx_mysql_thread_id = CONNECTION_ID()\G
@dedunumax
dedunumax / slow_postgres.sql
Created February 6, 2020 09:23
SELECT
pid,
now() - pg_stat_activity.query_start AS duration,
query,
state
FROM pg_stat_activity
WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes'
ORDER BY duration DESC;
@dedunumax
dedunumax / stop_mysql.sql
Created May 29, 2019 20:55
CALL mysql.rds_reset_external_master;