PstSystems

result=$($mysql -u $user -p$pass -e 'show slave status\G' | grep Last_SQL_Error: | sed -e 's/ *Last_SQL_Error: //')

seconds_behind=$($mysql -u $user -p$pass -e 'show slave status\G' | grep Seconds_Behind_Master: | sed -e 's/ *Seconds_Behind_Master: //')

if [[ -n "$result" || $seconds_behind -ge...

Login to the server you want to connect from

Run the following command to see if existing SSH keys are present:

ls -al ~/.ssh/id_*.pub

Generate a new SSH key pair.

ssh-keygen -t rsa -b 4096

In order to be able to login to your server without a password, copy the public key to the server

s...

As the root user, edit the sshd_config file found in /etc/ssh/sshd_config

Add the following line to the file

PermitRootLogin yes

Restart the SSH server:

systemctl restart sshd

or

service sshd restart

Login as root and Create keys on Master

make a directory to hold SSL certs

mkdir -p /var/lib/mysql
cd /var/lib/mysql

Use openssl to generate a key file.

openssl genrsa 2048 > ca-key.pem

set CA common name to "MariaDB admin"

openssl req -new -x509 -nodes -days 730 -key ca-key.pem -out ca-...

Using a 547Mb MySQL backup file I observed the following compression times for the respective compression settings.

1 > 30.18 Mb in 22s
2 > 30.18 Mb in 23s
3 > 29.12 Mb in 26s
4 > 29.12 Mb in 26s
5 > 22.03 Mb in 4m10s
6 > 22.03 Mb
7 > 19.51 Mb in 6m3s
8 > 19.51 Mb
9 > 17.31 Mb in 6m10s