Skip to content

Instantly share code, notes, and snippets.

View dtest's full-sized avatar

Derek Downey dtest

View GitHub Profile
@dtest
dtest / proxysql.sql
Created September 27, 2016 14:55
Mirror query rules
mysql> SELECT * FROM mysql_query_rules\G
*************************** 1. row ***************************
rule_id: 1
active: 1
username: plam_rewrite
schemaname: NULL
flagIN: 0
client_addr: NULL
proxy_addr: NULL
proxy_port: NULL
@dtest
dtest / configure-replication.sql
Last active July 11, 2016 20:33
Slave-Running-MySQL-5.7
# on master
mysql> SHOW MASTER STATUS\G
*************************** 1. row ***************************
File: mysql1-bin.000001
Position: 154
Binlog_Do_DB:
Binlog_Ignore_DB:
Executed_Gtid_Set:
1 row in set (0.00 sec)
vault:
container_name: vault
image: dtestops/vault
volumes:
- ./vault.hcl:/etc/vault.hcl
links:
- "mysql:mysql"
ports:
- "8200:8200"
command: "server -config=/etc/vault.hcl"
@dtest
dtest / clone-repo.sh
Last active March 20, 2016 13:23
Visualizing MySQL with Docker Compose
$ git clone git@github.com:dtest/visualize-mysql.git
$ cd visualize-mysql
@dtest
dtest / aliases.sh
Last active October 26, 2019 04:33
Docker Aliases
# Docker
function dm-env() {
eval "$(docker-machine env "${1:-default}")"
}
function docker-clean() {
docker rmi -f $(docker images -q -a -f dangling=true)
}
alias de="env | grep DOCKER_"
alias dm-list="docker-machine ls"