ilhnctn

<?php

echo "----------------------------------\n";
echo "| PHP to Swig Template Converter |\n";
echo "|                                |\n";
echo "| @yasinaydin @edigu             |\n";
echo "----------------------------------\n";

// User settings

ilhnctn

Terminal/Emilator Kurulumu

Mac-iTerm'e alışıksanız Terminator daha uyumludur.

sudo apt-get install guake

# Oh-my-god :)
apt-get install zsh
apt-get install git-core # if not installed
wget https://github.com/robbyrussell/oh-my-zsh/raw/master/tools/install.sh -O - | zsh

ilhnctn

#Install brew 
/usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"

brew update

# Change default shell to zsh :)
sh -c "$(curl -fsSL https://raw.githubusercontent.com/robbyrussell/oh-my-zsh/master/tools/install.sh)"

# To Install PHP 5.6
#Setup the homebrew/dupes tap which has dependencies we need:

ilhnctn

eval_docker_machine(){
        MACHINE_NAME = $1
        if [[ $# -eq 0 ]] ; then
                echo "\033[41;37;1m Usage: edm name_of_machine_env !!! \033[0m"
                exit(1)
        fi

        echo "\033[41;37;1m Eval to Docker-machime for $MACHINE_NAME !!! \033[0m"
        docker-machine ls -t 30
        docker-machine env $MACHINE_NAME

ilhnctn

[program:gunicorn]
command=/bin/gunicorn -w 4 myapp:app
environment=MY_ENV=/var/null
user=www-data

ilhnctn

Docker

Agenda

• What is docker?
• Docker vocabulary & commands
• Compose & usage
• Demo (dockerise Omnishop)
• Docker for Dev & CI/CD (next session ?)
• Kubernetes/AWS (next session)

ilhnctn

master_merge(){
        TARGET_BRANCH = $1
        if [[ $# -eq 0 ]] ; then
                echo "\033[41;37;1m Usage: mm name_of_branch !!! \033[0m"
                exit(1)
        fi

        echo "\033[41;37;1m Fetch/pull master and merge into $TARGET_BRANCH !!! \033[0m"
        git checkout master 
        git pull 

ilhnctn

Local Installation

You can refer to oficial documentations to install related component (or all of them)

• Docker For Desktop (MacOS, Windows)
• minikube
• Helm
• Kind

Minikube

ilhnctn

Identify Slow Queries

See talk

• use application_name in qs (if more than one app connects to db)
• Native Partitioning is better than pg_partman

Logging

=> The more you log, the better you locate performance battlenecks. Also the mor you log, the more you slow down your system.
=> pgbadger, pg_stat_statements (what is currently happening)

ilhnctn

This document tries to combine basic/general query and commands that can be useful for database maintenance and monitoring.

Get Info About Current Active Connections

Here you can list active/iddle connections to the database and see the actual queries that hit the DB.

Note: If there are too much concurrent requests to your database server (not to a single DB instance), than you should consider reducing iddle connections. Especially if there are too much old iddle connections.

SELECT * FROM pg_stat_activity;