committing old WIP

1 files changed, 44 insertions, 0 deletions

diff --git a/mariadb-push-replica.sh b/mariadb-push-replica.sh
new file mode 100755
index 0000000..d645c91
--- /dev/null
+++ b/mariadb-push-replica.sh
@@ -0,0 +1,44 @@
+#!/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}
+
+[ "$our_host" ]
+[ "$remote_host" ]
+
+master_password=$(false)
+
+ssh -l root "$remote_host" -- mariadb <<END
+CHANGE MASTER TO
+  MASTER_HOST='$our_host',
+  MASTER_USER='replication',
+  MASTER_PASSWORD='$master_password'
+END