si294r’s gists

si294r / tuneup_20161024.md

Created October 25, 2016 04:19

Hasil Eksperimen Tune Up Big Table Events_1377 - Redshift :

Setelah ditambahkan sortkey pada kolom event_time, ternyata hasil query tidak ada perubahan dan tidak menjadi lebih cepat

CREATE TABLE events_1377_2
(
   app_version  varchar(255),
   event_type   varchar(255),
 event_time bigint,

si294r / vhost_almigh_tv.md

Last active December 9, 2016 07:59

<VirtualHost *:80>
        ServerName almigh.tv
        ServerAlias alegrium2.almigh.tv

        ServerAdmin webmaster@localhost
        DocumentRoot /var/www/html_almigh_tv

        #LogLevel info ssl:warn
        #LogLevel trace8

si294r / vhost_mytower_xyz.md

Created December 16, 2016 04:20

<VirtualHost *:80>
        ServerName mytower.xyz
        ServerAlias alegrium2.mytower.xyz

        ServerAdmin webmaster@localhost
        DocumentRoot /var/www/html_mytower_xyz

        #LogLevel info ssl:warn
        #LogLevel trace8

si294r / Login_SSH_no_password.md

Last active December 21, 2017 05:13

Login ssh without password

ssh-keygen

ssh-copy-id -i ~/.ssh/id_rsa.pub [email protected]

ssh [email protected]

si294r / maxscale.cnf.md

Last active October 5, 2017 12:25

# MaxScale documentation on GitHub:
# https://github.com/mariadb-corporation/MaxScale/blob/2.1/Documentation/Documentation-Contents.md

# Global parameters
#
# Complete list of configuration options:
# https://github.com/mariadb-corporation/MaxScale/blob/2.1/Documentation/Getting-Started/Configuration-Guide.md

[maxscale]

si294r / ls_server_log.sh.md

Created November 23, 2017 08:06

#!/bin/sh

echo
echo aws s3 ls s3://alegrium-logs/alegrium2/$(date +%Y%m%d)
aws s3 ls s3://alegrium-logs/alegrium2/$(date +%Y%m%d)

echo
echo aws s3 ls s3://alegrium-logs/api/$(date +%Y%m%d)
aws s3 ls s3://alegrium-logs/api/$(date +%Y%m%d)

si294r / setup_mongodb_server.md

Created December 21, 2017 04:54

Install mongodb :

Development

file mongo.conf

storage: dbPath: /data/db directoryPerDB: true

si294r / docker_20171010.md

Created December 21, 2017 04:57

docker

mariadb

docker create --name mariadb -e MYSQL_ROOT_PASSWORD=password -p 3306:3306 mariadb:10.2

docker start mariadb

docker exec -it mariadb /bin/bash

si294r / mariadb_replication.md

Created December 21, 2017 05:04

MariaDB Replication

MASTER

docker create --name mariadb-master -e MYSQL_ROOT_PASSWORD=password -p 3316:3306 mariadb:10.2 docker start mariadb-master docker exec -it mariadb-master /bin/bash

apt-get update apt-get install nano

si294r / maxscale_and_mariadb.md

Created December 21, 2017 05:05

[MaxScale & MariaDB]

Checklist & Issue Consistency select after insert : cloudsave inbox function get_user_id in file function.php leaderboard receiptvalidation function get_user_id in file function.php referral

Chairuddinsyah Siregar si294r