====Overview==== Cluster Control is commercial software, which has also Community (Free) edition, which allows us to install Galera Software using web based interface very easily. The installation of the Cluster Control can be seen below: [[https://severalnines.com/download-clustercontrol-database-management-system | Cluster Control Installation]] You can see the installation as well below: ====Installation==== The installation of the Community edition is as simple as explained, let's go through the process: [root@galera-control ~]# wget -O install-cc https://severalnines.com/scripts/install-cc?9YYmraS2iC5-6CVVopwXFyn_UriSCUdC1U-6mADd5zA, --2018-08-19 12:23:57-- https://severalnines.com/scripts/install-cc?9YYmraS2iC5-6CVVopwXFyn_UriSCUdC1U-6mADd5zA, Resolving severalnines.com (severalnines.com)... 107.154.148.155, 107.154.238.155 Connecting to severalnines.com (severalnines.com)|107.154.148.155|:443... connected. HTTP request sent, awaiting response... 200 OK ====================================================================================================================================================================================== Package Arch Version Repository Size ====================================================================================================================================================================================== Installing: clustercontrol x86_64 1.6.2-4959 s9s-repo 15 M Installing for dependencies: clustercontrol-cloud x86_64 1.6.2-141 s9s-repo 9.5 M clustercontrol-clud x86_64 1.6.2-141 s9s-repo 7.8 M clustercontrol-cmonapi x86_64 1.6.2-330 s9s-repo 2.4 M clustercontrol-notifications x86_64 1.6.2-136 s9s-repo 2.4 M clustercontrol-ssh x86_64 1.6.2-59 s9s-repo 2.6 M ====================================================================================================================================================================================== Package Arch Version Repository Size ====================================================================================================================================================================================== Installing: httpd x86_64 2.4.6-80.el7.centos.1 updates 2.7 M mariadb-server x86_64 1:5.5.56-2.el7 base 11 M ****************************************************************************************************************************** php-pdo x86_64 5.4.16-45.el7 base 99 k t1lib x86_64 5.1.2-14.el7 base 166 k ====================================================================================================================================================================================== Package Arch Version Repository Size ====================================================================================================================================================================================== Installing: s9s-tools x86_64 1.6-44.1 s9s-tools 1.5 M Transaction Summary ====================================================================================================================================================================================== Install 1 Package Total download size: 1.5 M Installed size: 7.0 M Downloading packages: warning: /var/cache/yum/x86_64/7/s9s-tools/packages/s9s-tools-1.6-44.1.x86_64.rpm: Header V3 RSA/SHA256 Signature, key ID d4871e82: NOKEY========== ] 393 kB/s | 1.5 MB 00:00:00 ETA Public key for s9s-tools-1.6-44.1.x86_64.rpm is not installed s9s-tools-1.6-44.1.x86_64.rpm | 1.5 MB 00:00:02 Retrieving key from http://repo.severalnines.com/s9s-tools/CentOS_7/repodata/repomd.xml.key Importing GPG key 0xD4871E82: Userid : "home:kedazo OBS Project " Fingerprint: 137a 4cc1 aef2 16ae dc5f 941f df4d 4bc1 d487 1e82 From : http://repo.severalnines.com/s9s-tools/CentOS_7/repodata/repomd.xml.key Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : s9s-tools-1.6-44.1.x86_64 1/1 Verifying : s9s-tools-1.6-44.1.x86_64 1/1 Installed: s9s-tools.x86_64 0:1.6-44.1 Complete! Created symlink from /etc/systemd/system/multi-user.target.wants/cmon-events.service to /etc/systemd/system/cmon-events.service. Created symlink from /etc/systemd/system/multi-user.target.wants/cmon-ssh.service to /etc/systemd/system/cmon-ssh.service. Created symlink from /etc/systemd/system/multi-user.target.wants/cmon-cloud.service to /etc/systemd/system/cmon-cloud.service. => ClusterControl installation completed! Open your web browser to http://clusterControl/clustercontrol and enter an email address and new password for the default Admin User. Determining network interfaces. This may take a couple of minutes. Do NOT press any key. Public/external IP => http://141.8.54.145/clustercontrol NOTE: Detected more than one IP: 10.0.2.15 Installation successful. If you want to uninstall ClusterControl then run install-cc --uninstall. Ensure you configure passwordless ssh to all database hosts from the cluster control server. In order to do that, generate a public key and share it with the other servers as follows: [root@galera-control ~]# ssh-keygen -t rsa Generating public/private rsa key pair. Enter file in which to save the key (/root/.ssh/id_rsa): Enter passphrase (empty for no passphrase): Enter same passphrase again: Your identification has been saved in /root/.ssh/id_rsa. Your public key has been saved in /root/.ssh/id_rsa.pub. The key fingerprint is: SHA256:5Rjeuqg5P5f0MDcbl/ZuvyUy+J6+7bwPWoIDmy0PUrA root@galera-control.dev The key's randomart image is: +---[RSA 2048]----+ | | | | | . . . | | + * | | E S o . | | .+*+o+ | | ..**=*+.+ .| | ...oo=oo Xoo.| | o+oo. .oB=*=+| +----[SHA256]-----+ [root@galera-control ~]# Once you created the rsa key, upload it to the servers to which you want to connect without password as follows: [root@galera-control ~]# ssh-copy-id -i ~/.ssh/id_rsa 192.168.0.100 /usr/bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/root/.ssh/id_rsa.pub" The authenticity of host '192.168.0.100 (192.168.0.100)' can't be established. ECDSA key fingerprint is SHA256:buPP/oO4PNoJ3wZiQ/6dl+NR6XLIDzzrV9cU4yVMGAg. ECDSA key fingerprint is MD5:be:e9:da:16:cd:7d:1c:54:58:04:b4:46:c3:a0:7e:ee. 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@192.168.0.100's password: Number of key(s) added: 1 Now try logging into the machine, with: "ssh '192.168.0.100'" and check to make sure that only the key(s) you wanted were added. [root@galera-control ~]# ssh-copy-id -i ~/.ssh/id_rsa 192.168.0.101 /usr/bin/ssh-copy-id: INFO: Source of key(s) to be installed: "/root/.ssh/id_rsa.pub" The authenticity of host '192.168.0.101 (192.168.0.101)' can't be established. ECDSA key fingerprint is SHA256:6cLdKkakdocOrb+5mOi76YlSbojXvMhmyd/O3tH5+RA. ECDSA key fingerprint is MD5:6d:96:eb:8d:55:a0:02:7e:56:ae:6f:62:3f:7b:ed:76. 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@192.168.0.101's password: Number of key(s) added: 1 Now try logging into the machine, with: "ssh '192.168.0.101'" and check to make sure that only the key(s) you wanted were added. You can test your connection to the database nodes as follows: [root@galera-control ~]# ssh 192.168.0.101 Last login: Sun Aug 19 12:23:37 2018 from 192.168.0.8 [root@galera-mysql2 ~]# logout Connection to 192.168.0.101 closed. [root@galera-control ~]#