# run inside WSL 2
# check https://www.vagrantup.com/downloads for more info
curl -fsSL https://apt.releases.hashicorp.com/gpg | sudo apt-key add -
sudo apt-add-repository "deb [arch=amd64] https://apt.releases.hashicorp.com $(lsb_release -cs) main"
sudo apt-get update && sudo apt-get install vagrant

# append those two lines into ~/.bashrc
echo 'export VAGRANT_WSL_ENABLE_WINDOWS_ACCESS="1"' >> ~/.bashrc
echo 'export PATH="$PATH:/mnt/c/Program Files/Oracle/VirtualBox"' >> ~/.bashrc

# now reload the ~/.bashrc file
source ~/.bashrc

# -*- mode: ruby -*-
# vi: set ft=ruby :

#Vagrant_API_Version = "2"
Vagrant.configure(2) do |config|
  config.vm.box = "centos/7"
  config.vm.box_check_update = false
  #test01
  config.vm.define:"neoclova01" do |cfg|
    cfg.vm.provider:virtualbox do |vb|
      vb.name="CentOS-neoclova01"
      vb.customize ["modifyvm", :id, "--cpus",2]
      vb.customize ["modifyvm", :id, "--memory",1024]
    end
    cfg.vm.host_name="neoclova01"
    cfg.vm.synced_folder ".", "/vagrant", disabled:true
#    cfg.vm.network "public_network", ip: "1.1.1.1"
    cfg.vm.network "private_network", ip: "192.168.200.101"
#    cfg.vm.network "forwarded_port", guest: 22, host:39211, auto_correct: false, id: "ssh"
#    cfg.vm.provision "shell", inline: <<-SHELL
#       echo "hello"
#       date
#    SHELL
  end
  #test02
  config.vm.define:"neoclova02" do |cfg|
    cfg.vm.provider:virtualbox do |vb|
      vb.name="CentOS-neoclova02"
      vb.customize ["modifyvm", :id, "--cpus",2]
      vb.customize ["modifyvm", :id, "--memory",1024]
    end
    cfg.vm.host_name="neoclova02"
    cfg.vm.synced_folder ".", "/vagrant", disabled:true
#    cfg.vm.network "public_network", ip: "8.8.8.8"
    cfg.vm.network "private_network", ip: "192.168.200.102"
#    cfg.vm.network "forwarded_port", guest: 22, host:39212, auto_correct: false, id: "ssh"
  end
end

vagrant plugin install virtualbox_WSL2

vagrant up

# yum install epel-release
# yum install freetds
# yum install unixODBC

# cat /etc/odbcinst.ini
[FreeTDS]
Description = FreeTDS Driver
Driver = /usr/lib64/libtdsodbc.so.0
Setup = /usr/lib64/libtdsS.so.2
FileUsage = 1
CPTimeout = 5
CRReuse = 5

# cat /etc/odbc.ini
[NEOCLOVA]
driver=FreeTDS
server=127.0.0.1
port=1433
database=ssauravy
client_charset = UTF-8
tds_version = 8.0

> install soname 'ha_connect';

> CREATE TABLE t_test1 ENGINE=CONNECT, TABLE_TYPE=ODBC, TABNAME='dbo.test' CONNECTION='Driver=FreeTDS;Server=127.0.0.1;Database=dbtest;UID=neoclova;PWD=welcome;Port=1433';
> CREATE TABLE t_test2 ENGINE=CONNECT TABLE_TYPE=ODBC TABNAME='dbo.test' CONNECTION='DSN=NEOCLOVA;UID=neoclova;PWD=welcome';

select concat('alter table ', table_schema, '.', table_name, ' import tablespace;') as sql_alter
from information_schema.tables
where table_schema = 'ohnew';

# port 7901

dir "/data"
logfile "redis.log"

maxclients 1128
maxmemory 1000000000
maxmemory-policy volatile-lru

appendonly yes
appendfsync everysec
repl-backlog-size 50mb

port 8179
sentinel monitor rsmaster redis-snt-1 6379 1
sentinel down-after-milliseconds rsmaster 3000

bind 0.0.0.0
protected-mode yes
dir "/data/sentinel"
logfile "sentinel.log"
daemonize yes

#!/bin/sh
set -e

[ -d /data/sentinel ] || mkdir -p /data/sentinel && chown -R redis:redis /data

gosu redis redis-sentinel /usr/local/etc/redis/sentinel.conf
gosu redis redis-server /usr/local/etc/redis/redis.conf --slaveof redis-snt-1 6379

for ind in `seq 1 4`; do \
 mkdir -p $PWD/data/conf/node$ind
 cp redis-master.conf data/conf/node$ind/redis.conf
 cp sentinel.conf data/conf/node$ind/sentinel.conf
 cp redis-start.sh data/conf/node$ind/start.sh
done

# chown 999:999 data/conf/node*/*.conf
# sed -e 's/gosu redis redis-sentinel/#gosu redis redis-sentinel/' redis-start.sh > data/conf/node1/start.sh
# sed -e 's/--slaveof redis-snt-1 6379//' redis-start.sh > data/conf/node1/start.sh

### docker run
for ind in `seq 1 4`; do \
 docker run -d \
 -v $PWD/data/conf/node$ind:/usr/local/etc/redis \
 -v $PWD/data/node$ind:/data \
 --name redis-snt-$ind --net redis-cluster \
 redis /usr/local/etc/redis/start.sh
done

####
#### Ohnew Innovation
#### MariaDB my.cnf
####

[client]
port		= 3306
socket		= /var/run/mysqld/mysqld.sock

[mysqld_safe]
socket		= /var/run/mysqld/mysqld.sock
nice		= 0
# syslog
#skip_log_error
#syslog

[mysqld]
# basic setting
#user		= mysql
pid-file	= /var/run/mysqld/mysqld.pid
socket		= /var/run/mysqld/mysqld.sock
port		= 3306
basedir		= /usr
datadir		= /MariaDB/data
tmpdir		= /tmp
lc_messages_dir	= /usr/share/mysql
lc_messages	= en_US
skip-external-locking
bind-address=0.0.0.0

skip-host-cache
skip-name-resolve

#server-id=2179

#query_cache setting
query_cache_type    = 0
query_cache_size    = 0
query_cache_limit   = 0

# Log file setting
log-error           = /MariaDB/log/mariadb.err
slow_query_log      = 1
slow_query_log_file = /MariaDB/log/slow-query.log
long_query_time     = 3
#log-queries-not-using-indexes
#log_slow_admin_statements

log-bin             = /MariaDB/log/binary/mariadb-bin
binlog_cache_size   = 2M
max_binlog_size     = 100M
expire_logs_days    = 10
sync_binlog		    = 1
binlog_format       =row

# slaves
relay_log           = /MariaDB/log/binary/relay-bin
#log_slave_updates
#read_only

# Time-out setting
wait_timeout         = 600
interactive_timeout  = 3600
connect_timeout		 = 5

# transaction isolation setting
transaction_isolation = READ-COMMITTED

# etc setting
back_log            = 1024
max_connections     = 1024
max_connect_errors  = 1024
table_open_cache    = 2048
max_allowed_packet  = 1024M
max_heap_table_size = 1024M
sort_buffer_size    = 8M
join_buffer_size    = 8M
thread_cache_size   = 128
#thread_concurrency = 36
tmp_table_size      = 1024M

# character set setting
#init_connect = "SET collation_connection = utf8_general_ci"
#init_connect = "SET NAMES utf8"
character-set-server = utf8mb4
#collation-server     = utf8mb4_general_ci 
#character_set_server = utf8mb4 
#collation_server     = utf8mb4_general_ci

# innodb setting
innodb_file_per_table          = 1
innodb_buffer_pool_size        = 512M
innodb_log_buffer_size         = 16M
innodb_lock_wait_timeout       = 50
innodb_thread_sleep_delay      = 0
innodb_commit_concurrency      = 36
innodb_doublewrite             = 0
innodb_flush_log_at_trx_commit = 2
innodb_thread_concurrency      = 36
#innodb_log_files_in_group      = 3
innodb_flush_method	           = O_DIRECT
innodb_log_file_size           = 256M
#innodb_data_file_path    = ibdata1:1024M;ibdata2:1024M;ibdata3:10M:autoextend

# use MyISAM
key_buffer_size          = 128M
read_buffer_size         = 2M
read_rnd_buffer_size     = 16M
bulk_insert_buffer_size  = 64M
myisam_sort_buffer_size  = 512M
myisam_max_sort_file_size= 512M
myisam_repair_threads    = 1
myisam_recover

# Galera
#wsrep_on=ON
#wsrep_provider=
#wsrep_cluster_address=
#default_storage_engine=InnoDB
#innodb_autoinc_lock_mode=2
#wsrep_slave_threads=1

[mysqldump]
max_allowed_packet	= 1024M
quick
#quote-names

[mysqld_safe]
open_files_limit = 8192

#!/bin/bash
####
#### Ohnew Innovation
#### MariaDB Replication : Docker
####


Nodes=4 
NodeMaster=3
MyPass="ohnew21&("

for i in `seq 1 $Nodes`; do 
    mkdir -p $PWD/conf/node$i $PWD/data/node$i $PWD/log/node$i/binary
    cp my.cnf $PWD/conf/node$i
    sed -i "s/#server-id=2179/server-id=$i/g" conf/node$i/my.cnf
done

chown -R 999:999 ./data/*
chown -R 999:999 ./log/*

for i in `seq 1 $Nodes`; do 
    docker run -d -it \
    --network=maria --name=maria$i --memory-swappiness=1 \
    --mount type=bind,src=$PWD/conf/node$i,dst=/etc/mysql \
    --mount type=bind,src=$PWD/data/node$i,dst=/MariaDB/data \
    --mount type=bind,src=$PWD/log/node$i,dst=/MariaDB/log \
    -e MYSQL_ROOT_PASSWORD="$MyPass" \
    mariadb
done

echo -ne "maria$NodeMaster "
while true; do
  chkPing=`docker container exec maria$NodeMaster mysqladmin -s -p"$MyPass" ping > chk.ping`
  if grep "mysqld is alive" chk.ping ; then
    break
  fi
  echo -ne "."
  sleep 1
done

docker container exec maria$NodeMaster \
    mysql -p"$MyPass" -e \
      "CREATE USER 'repl'@'%' IDENTIFIED BY '$MyPass'; GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%';"

GTIDpos=`docker container exec maria$NodeMaster mysql -s -p"ohnew21&(" -e "select @@global.gtid_binlog_pos"`

for i in `seq 1 $Nodes`; do 
  if [ "$i" -eq "$NodeMaster" ] ; then
    echo -ne ""
  else

    echo -ne "maria$i "
    while true; do
      chkPing=`docker container exec maria$i mysqladmin -s -p"$MyPass" ping > chk.ping`
      if grep "mysqld is alive" chk.ping ; then
        break
      fi
      echo -ne "."
      sleep 1
    done

    docker container exec maria$i \
      mysql -hmaria$i -p"$MyPass" -e \
      "SET GLOBAL read_only = 1; SET GLOBAL gtid_slave_pos = '$GTIDpos'; CHANGE MASTER TO MASTER_HOST='maria$NodeMaster', MASTER_USER='repl', MASTER_PASSWORD='$MyPass', MASTER_USE_GTID = current_pos; START SLAVE;"
    
    NodeSlave=$i

  fi
done

docker container exec maria$NodeSlave mysql -s -p"ohnew21&(" -e "show slave status\G" | grep Running: