diff options
author | root <root@vps-18a7a2b7.vps.ovh.ca> | 2024-02-17 11:00:14 -0500 |
---|---|---|
committer | root <root@vps-18a7a2b7.vps.ovh.ca> | 2024-02-17 11:00:14 -0500 |
commit | fa908328e44a41d6ca677a9aceefba96bc1b0e01 (patch) | |
tree | 9582e498115dd597b951643393e81d3cf3be81c6 /mariadb | |
parent | 9a6fa8bea2ac46622d9d7b30796530c03b835953 (diff) |
improve display output
Diffstat (limited to 'mariadb')
-rwxr-xr-x | mariadb/mariadb-push-databases-to-empty-replica | 10 |
1 files 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 | |||
168 | ; | 168 | ; |
169 | select | 169 | select |
170 | @@hostname | 170 | @@hostname |
171 | as | ||
172 | 'primary host' | ||
173 | , concat (user, '@', host) | 171 | , concat (user, '@', host) |
174 | as | 172 | as |
175 | login | 173 | login |
@@ -179,7 +177,9 @@ select | |||
179 | from | 177 | from |
180 | mysql.user | 178 | mysql.user |
181 | where | 179 | where |
182 | repl_slave_priv = 'Y' | 180 | user = '$2' |
181 | and | ||
182 | host = '$1' | ||
183 | ; | 183 | ; |
184 | . | 184 | . |
185 | } | 185 | } |
@@ -499,7 +499,9 @@ start | |||
499 | echo "trying primary_gtid_wait()... " >&2 | 499 | echo "trying primary_gtid_wait()... " >&2 |
500 | mariadb -t --skip-reconnect <<. | 500 | mariadb -t --skip-reconnect <<. |
501 | select | 501 | select |
502 | master_gtid_wait('$gtid') | 502 | @@hostname |
503 | , @@gtid_slave_pos as 'replica gtid' | ||
504 | , master_gtid_wait('$gtid') | ||
503 | as \`primary_gtid_wait('$gtid')\` | 505 | as \`primary_gtid_wait('$gtid')\` |
504 | ; | 506 | ; |
505 | . | 507 | . |