|
Running columnstoreBackup on a root install. It failed the first time I ran it wil ssh login failed.
I then logged into the PM1 with ssh-keys and got the prompt for first time login.
Then columnstoreBackup worked after that.
root@ip-172-31-38-221:~# ./columnstoreBackup -zv 172.31.38.221 columnstoreBackupData
[2019-08-14 15:29:44] [root] ./columnstoreBackup -zv 172.31.38.221 columnstoreBackupData
[2019-08-14 15:29:44] ERROR: Cannot connect to root@172.31.38.221
[2019-08-14 15:29:44] Check that ssh and passwordless login are available.
[2019-08-14 15:29:44] Backup Status: Failed
[2019-08-14 15:29:44] Runtime: 00:00:00
root@ip-172-31-38-221:~# ssh root@172.31.38.221
The authenticity of host '172.31.38.221 (172.31.38.221)' can't be established.
ECDSA key fingerprint is SHA256:7zNh5Q6ZWOnqNU3VxlsiSqIPPeGZBxUUOvrUoTEocvU.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '172.31.38.221' (ECDSA) to the list of known hosts.
Welcome to Ubuntu 18.04.1 LTS (GNU/Linux 4.15.0-1044-aws x86_64)
- Reduce system reboots and improve kernel security. Activate at:
https://ubuntu.com/livepatch
152 packages can be updated.
0 updates are security updates.
-
- System restart required ***
Last login: Wed Aug 14 15:18:57 2019 from 47.186.101.176
root@ip-172-31-38-221:~#
root@ip-172-31-38-221:~#
root@ip-172-31-38-221:~#
root@ip-172-31-38-221:~# exit
logout
Connection to 172.31.38.221 closed.
root@ip-172-31-38-221:~#
root@ip-172-31-38-221:~#
root@ip-172-31-38-221:~#
root@ip-172-31-38-221:~#
root@ip-172-31-38-221:~#
root@ip-172-31-38-221:~# ./columnstoreBackup -zv 172.31.38.221 columnstoreBackupData
[2019-08-14 15:30:07] [root] ./columnstoreBackup -zv 172.31.38.221 columnstoreBackupData
[2019-08-14 15:30:08] rsync -a -z --delete --link-dest=./backup.1 root@172.31.38.221:/usr/local/mariadb/columnstore/etc/Columnstore.xml columnstoreBackupData
[2019-08-14 15:30:08] rsync -a -z --delete --link-dest=./backup.1 root@172.31.38.221:/usr/local/mariadb/columnstore/releasenum columnstoreBackupData
[2019-08-14 15:30:12]
[2019-08-14 15:30:12] Configuration:
[2019-08-14 15:30:12]
[2019-08-14 15:30:12] Server PM1 address = 172.31.38.221
[2019-08-14 15:30:12] Backup Server location = columnstoreBackupData
[2019-08-14 15:30:12] SystemName: columnstore-1
[2019-08-14 15:30:12] SingleServerInstall: n
[2019-08-14 15:30:12] serverTypeInstall: 1
[2019-08-14 15:30:12] PMwithUM: y
[2019-08-14 15:30:12] DBRootStorageType: internal
[2019-08-14 15:30:12]
[2019-08-14 15:30:12] UMs: 2
[2019-08-14 15:30:12] PMs: 2
[2019-08-14 15:30:12] um1 ip 172.31.43.170
[2019-08-14 15:30:12] um1 host 172.31.43.170
[2019-08-14 15:30:12]
[2019-08-14 15:30:12] um2 ip 172.31.34.20
[2019-08-14 15:30:12] um2 host 172.31.34.20
[2019-08-14 15:30:12]
[2019-08-14 15:30:12] pm1 ip 172.31.38.221
[2019-08-14 15:30:12] pm1 host ip-172-31-38-221
[2019-08-14 15:30:12] pm1 DBRootCount: 1
[2019-08-14 15:30:12]
[2019-08-14 15:30:12] pm2 ip 172.31.35.18
[2019-08-14 15:30:12] pm2 host 172.31.35.18
[2019-08-14 15:30:12] pm2 DBRootCount: 1
[2019-08-14 15:30:12]
[2019-08-14 15:30:12] DBRootCount: 2
[2019-08-14 15:30:12] DBRoot1: /usr/local/mariadb/columnstore/data1
[2019-08-14 15:30:12] DBRoot2: /usr/local/mariadb/columnstore/data2
[2019-08-14 15:30:12] WARNING: Disk Space NOT verified for backup system.
[2019-08-14 15:30:12] Run with -d option to collect disk space requirement information via rsync.
[2019-08-14 15:30:12] ssh root@172.31.38.221 du -s -b /usr/local/mariadb/columnstore/data1
[2019-08-14 15:30:13] ssh root@172.31.38.221 du -s -b /usr/local/mariadb/columnstore/mysql/db
[2019-08-14 15:30:14] ssh root@172.31.35.18 du -s -b /usr/local/mariadb/columnstore/data2
[2019-08-14 15:30:14] ssh root@172.31.35.18 du -s -b /usr/local/mariadb/columnstore/mysql/db
[2019-08-14 15:30:21] rsync -a -z --delete --link-dest=../backup.1/cnf root@172.31.38.221:/usr/local/mariadb/columnstore/mysql/my.cnf columnstoreBackupData/cnf/
[2019-08-14 15:30:21] rsync -a -z --delete --link-dest=../backup.1/cnf root@172.31.38.221:/usr/local/mariadb/columnstore/mysql/my.cnf.d columnstoreBackupData/cnf/
[2019-08-14 15:30:22] Backing up PMs
[2019-08-14 15:30:22] Backing up pm1dbroot1
[2019-08-14 15:30:22] rsync -a -z --delete --copy-links --link-dest=../backup.1/pm1dbroot1 root@172.31.38.221:/usr/local/mariadb/columnstore/data1 columnstoreBackupData/pm1dbroot1
[2019-08-14 15:30:22] Backing up pm1dbroot1 local query data
[2019-08-14 15:30:22] rsync -a -z --delete --link-dest=../backup.1/pm1DB root@172.31.38.221:/usr/local/mariadb/columnstore/mysql/db columnstoreBackupData/pm1DB
[2019-08-14 15:30:24] Backing up pm2dbroot1
[2019-08-14 15:30:24] rsync -a -z --delete --copy-links --link-dest=../backup.1/pm2dbroot1 root@172.31.35.18:/usr/local/mariadb/columnstore/data2 columnstoreBackupData/pm2dbroot1
[2019-08-14 15:30:24] Backing up pm2dbroot1 local query data
[2019-08-14 15:30:24] rsync -a -z --delete --link-dest=../backup.1/pm2DB root@172.31.35.18:/usr/local/mariadb/columnstore/mysql/db columnstoreBackupData/pm2DB
[2019-08-14 15:30:26] Waiting for backups to complete...
Progress [=========================>] (100%) 13 Mbps 00:00:25 Approx Time Remaining
[2019-08-14 15:30:36] DONE
[2019-08-14 15:30:36] Backing up UMs
[2019-08-14 15:30:36] Backing up um1
[2019-08-14 15:30:36] rsync -a -z --delete --link-dest=../backup.1/um1 root@172.31.43.170:/usr/local/mariadb/columnstore/mysql/db columnstoreBackupData/um1
[2019-08-14 15:30:38] Backing up um2
[2019-08-14 15:30:38] rsync -a -z --delete --link-dest=../backup.1/um2 root@172.31.34.20:/usr/local/mariadb/columnstore/mysql/db columnstoreBackupData/um2
[2019-08-14 15:30:40] DONE
[2019-08-14 15:30:40] Backup Status: Success
[2019-08-14 15:30:40] Runtime: 00:00:33
root@ip-172-31-38-221:~#
|