Teguh Triharto Learning Center: .::: Importing Exsiting server or cluster MySQL/MariaDB using Severalnines :::.

Thursday, July 8, 2021

.::: Importing Exsiting server or cluster MySQL/MariaDB using Severalnines :::.

1. Generate an SSH key to be used by ClusterControl when connecting to all managed hosts. In this example, we are using the root user to connect to the managed hosts. To generate an SSH key for the root user

[root@teguhth ~]# ssh-keygen -t rsa

2. Before creating or importing a database server/cluster into ClusterControl, set up passwordless SSH from the ClusterControl host to the database host(s). Use the following command to copy the SSH key to the target hosts

ssh-copy-id -i ~/.ssh/id_rsa root@10.10.10.40

[root@teguhth ~]# ssh-copy-id -i ~/.ssh/id_rsa root@10.10.10.40

/usr/bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/root/.ssh/id_rsa.pub"

The authenticity of host '10.10.10.40 (10.10.10.40)' can't be established.

ECDSA key fingerprint is SHA256:51kbyQK62E7vkLWExPDeLjK81WrXwCiulQ3V9U4VKak.

ECDSA key fingerprint is MD5:eb:6c:f4:0e:0e:d0:70:5b:40:2d:f0:7c:5e:f3:6a:02.

Are you sure you want to continue connecting (yes/no)? yes

/usr/bin/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed

/usr/bin/ssh-copy-id: INFO: 1 key(s) remain to be installed -- if you are prompted now it is to install the new keys

root@10.10.10.40's password:

Number of key(s) added: 1

Now try logging into the machine, with: "ssh 'root@10.10.10.40'"

and check to make sure that only the key(s) you wanted were added.

[root@teguhth ~]#

3. Open ClusterControl UI at https://ClusterControl_host/clustercontrol and create the default admin password by providing a valid email address and password.

https://10.10.10.100/clustercontrol

4. Select import existing server database