From fa908328e44a41d6ca677a9aceefba96bc1b0e01 Mon Sep 17 00:00:00 2001 From: root Date: Sat, 17 Feb 2024 11:00:14 -0500 Subject: improve display output --- mariadb/mariadb-push-databases-to-empty-replica | 10 ++++++---- 1 file changed, 6 insertions(+), 4 deletions(-) diff --git a/mariadb/mariadb-push-databases-to-empty-replica b/mariadb/mariadb-push-databases-to-empty-replica index dc5bfa0..5d9590b 100755 --- a/mariadb/mariadb-push-databases-to-empty-replica +++ b/mariadb/mariadb-push-databases-to-empty-replica @@ -168,8 +168,6 @@ to ; select @@hostname - as - 'primary host' , concat (user, '@', host) as login @@ -179,7 +177,9 @@ select from mysql.user where - repl_slave_priv = 'Y' + user = '$2' +and + host = '$1' ; . } @@ -499,7 +499,9 @@ start echo "trying primary_gtid_wait()... " >&2 mariadb -t --skip-reconnect <<. select - master_gtid_wait('$gtid') + @@hostname +, @@gtid_slave_pos as 'replica gtid' +, master_gtid_wait('$gtid') as \`primary_gtid_wait('$gtid')\` ; . -- cgit v1.2.3