####
#### 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: