Day 18: Install and Configure DB Server
In this session of the DevOps Series (Day 18), the goal was to set up a robust database backend on the Nautilus DB Server located in the Stratos data center to support future application deployments.
Lab Objectives
The primary objective was to install the MariaDB server, secure the installation, and configure a specific database with associated user permissions.
Key Procedural Steps
Server Access:
Logged into the database server (stdb01) as the user peter.
Verified the environment and prepared to install the database engine.
MariaDB Installation:
Confirmed that MariaDB was not already installed using the package manager.
Installed the MariaDB Server package using the command: sudo yum install mariadb-server -y.
Service Management:
Started the MariaDB service using sudo systemctl start mariadb.
Enabled the service to ensure it starts automatically upon system boot: sudo systemctl enable mariadb.
Database Configuration:
Accessed the MariaDB monitor using the mysql command.
Created a new database named kodekloud_db5.
Created a dedicated database user named kodekloud_top with a secure password.
Permission Management:
Granted all privileges on the ccloud_db5 database to the new user for local access: GRANT ALL PRIVILEGES ON kodekloud_db5.* TO 'kodekloud_top'@'localhost';.
Applied the changes by executing the FLUSH PRIVILEGES; command.
Verification
The setup was verified by successfully logging into the database as the new user and confirming that the required database was visible and accessible.
#LinuxAdmin #MariaDB #DatabaseAdmin #DevOps #Nautilus #100DaysOfDevOps #OtterTech