old wip

1 files changed, 80 insertions, 0 deletions

diff --git a/wip/mariadb-push-replica.sh b/wip/mariadb-push-replica.sh
new file mode 100755
index 0000000..fbf9402
--- /dev/null
+++ b/wip/mariadb-push-replica.sh
@@ -0,0 +1,80 @@
+#!/bin/bash
+set -ex
+
+default_slave_remote_file=data/default-slave-remote
+master_password_file=data/mysql-master-password
+
+if [ -r "$default_slave_remote_file" ]
+then
+        read default_remote_host < "$default_slave_remote_file"
+fi
+
+gen_password()
+{
+        generated_password_length=32
+        generated_password=$(tr -cd a-zA-Z0-9 < /dev/urandom | head -c "$generated_password_length")
+        [ "${#generated_password}" -eq "$generated_password_length" ]
+        printf '%s\n' "$generated_password"
+}
+
+if ! [ -e "$master_password_file" ]
+then
+        gen_password > "$master_password_file"
+fi
+
+if [ -r "$master_password_file" ]
+then
+        read master_password < "$master_password_file" 
+        [ "${#master_password}" -ge 30 ]
+fi
+
+our_host=$(hostname --fqdn)
+remote_host=${1:-$default_remote_host}
+
+rpc_funcs=
+
+rpc()
+{
+        read shellscript < <(declare -f $rpc_funcs; echo $*)
+        set -- $shellscript
+        ssh -l "$remote_user" -- "$remote_host" ${*@Q}
+}
+
+[ "$our_host" ]
+[ "$remote_host" ]
+[ "$master_password" ]
+
+primarydb_create_user()
+{
+        :
+}
+
+mariabackup_target_dir=/var/mariadb/backup
+primarydb_export_backup()
+{
+        mkdir -p "$mariabackup_target_dir"
+        mariabackup --backup --target-dir="$mariabackup_target_dir"
+}
+
+primarydb()
+{
+        ssh -l root "$remote_host" -- "$@"
+}
+remote_user=root
+rpc uptime
+exit 1
+
+ssh -l root "$remote_host" -- mariadb -t <<END
+select @@hostname, @@server_id, @@gtid_slave_pos, @@sql_log_bin;
+SELECT VARIABLE_NAME,SESSION_VALUE,GLOBAL_VALUE  FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES WHERE VARIABLE_NAME='sql_log_bin' OR VARIABLE_NAME='HOSTNAME' \G
+SELECT VARIABLE_NAME,SESSION_VALUE,GLOBAL_VALUE  FROM INFORMATION_SCHEMA.SYSTEM_VARIABLES \G
+END
+
+exit 0
+
+ssh -l root "$remote_host" -- mariadb <<END
+CHANGE MASTER TO
+  MASTER_HOST='$our_host',
+  MASTER_USER='replication',
+  MASTER_PASSWORD='$master_password'
+END