Skip to content

Instantly share code, notes, and snippets.

View si294r's full-sized avatar

Chairuddinsyah Siregar si294r

7 followers · 1 following
  • Indonesia
View GitHub Profile
@si294r
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
si294r / setup_mongodb_server.md
Created December 21, 2017 04:54

Install mongodb :

Development

file mongo.conf

storage: dbPath: /data/db directoryPerDB: true

@si294r
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
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
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 chairuddinsyah@10.0.4.13

ssh chairuddinsyah@10.0.4.13
@si294r
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
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
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
si294r / autoindex_php_fpm.md
Created October 24, 2016 11:56

autoindex is not working when using php-fpm. The solution is to remove 'index.php' from DirectoryIndex.

@si294r
si294r / logrotate.md
Last active November 21, 2017 11:37

logrotate

logrotate -f /etc/logrotate.d/apache2

copy log files to /root/logs with "scp" or "docker cp"

scp /var/log/apache2/*.log.1 root@localhost:/root/logs/20170206/
rm /var/log/apache2/*.log.1