Installing MariaDB server on Red Hat Enterprise Linux 7 or CentOS 7

You must install MariaDB server on your host system before installing or upgrading the Tiebreaker software.

1. Log in as root to the host system.

   Example

   login as: root
   root@mcctb's password:
   Last login: Fri Jan  8 21:33:00 2017 from host.domain.com
   
   
2. Install MariaDB server: [root@mcctb ~]# yum install mariadb-server.x86_64

   Example

    [root@mcctb ~]# yum install mariadb-server.x86_64
   Loaded plugins: fastestmirror, langpacks
   ...
   ...
   
   =======================================================================================
    Package                      Arch   Version         Repository               Size
   =======================================================================================
   Installing:
   mariadb-server               x86_64   1:5.5.56-2.el7   base                   11 M
   Installing for dependencies:
   
   Transaction Summary
   =======================================================================================
   Install  1 Package  (+8 Dependent packages)
   Upgrade             ( 1 Dependent package)
   
   Total download size: 22 M
   Is this ok [y/d/N]: y
   Downloading packages:
   No Presto metadata available for base
   warning: /var/cache/yum/x86_64/7/base/packages/mariadb-libs-5.5.56-2.el7.x86_64.rpm:
   Header V3 RSA/SHA256 Signature, key ID f4a80eb5: NOKEY] 1.4 MB/s | 3.3 MB  00:00:13 ETA
   Public key for mariadb-libs-5.5.56-2.el7.x86_64.rpm is not installed
   (1/10): mariadb-libs-5.5.56-2.el7.x86_64.rpm  | 757 kB  00:00:01
   ..
   ..
   (10/10): perl-Net-Daemon-0.48-5.el7.noarch.rpm|  51 kB  00:00:01
   -----------------------------------------------------------------------------------------
   Installed:
     mariadb-server.x86_64 1:5.5.56-2.el7
   
   Dependency Installed:
   mariadb.x86_64 1:5.5.56-2.el7         perl-Compress-Raw-Bzip2.x86_64 0:2.061-3.el7 
   perl-Compress-Raw-Zlib.x86_64 1:2.061-4.el7 perl-DBD-MySQL.x86_64 0:4.023-5.el7 
   perl-DBI.x86_64 0:1.627-4.el7  perl-IO-Compress.noarch 0:2.061-2.el7 perl-Net-Daemon.noarch 0:0.48-5.el7          perl-PlRPC.noarch 0:0.2020-14.el7
   
   Dependency Updated:
     mariadb-libs.x86_64 1:5.5.56-2.el7
   Complete!
   
   
3. Start MariaDB server: [root@mcctb ~]# systemctl start mariadb

   Example

   [root@mcctb ~]# systemctl start mariadb
   
   
4. Verify MariaDB server has started: [root@mcctb ~]# systemctl status mariadb

   Example

   [root@mcctb ~]# systemctl status mariadb
   mariadb.service - MariaDB database server
   ...
   Nov 08 21:28:59 mcctb systemd[1]: Starting MariaDB database server...
   ...
   Nov 08 21:29:01 scspr0523972001 systemd[1]: Started MariaDB database server.
   
   

   Note

   Ensure that the enable autostart setting is turned on for MariaDB.
5. Configure the security and password settings: [root@mcctb ~]# mysql_secure_installation

   Example

   [root@mcctb ~]# mysql_secure_installation
   NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB
   SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY!
   Set root password? [Y/n] y
   New password:
   Re-enter new password:
   Password updated successfully!
   Remove anonymous users? [Y/n] y
   ... Success!
   Normally, root should only be allowed to connect from 'localhost'. This
   ensures that someone cannot guess at the root password from the network.
   Disallow root login remotely? [Y/n] y
   ... Success!
   Remove test database and access to it? [Y/n] y
   - Dropping test database...
   ... Success!
   - Removing privileges on test database...
   ... Success!
   Reload privilege tables now? [Y/n]
   ... Success!
   Cleaning up...
   All done! If you've completed all of the above steps, your MariaDB
   installation should now be secure.
   Thanks for using MariaDB!