I have done many automations MySQL Automations with Rundeck. This blog series will explain about the DevOps In MySQL with Rundeck.
Rundeck is one of my favourite Automation tools. Here we are going to see how can we install and configure rundek on a CentOS server with mysql as a backend. Even I like Jenkins, but as a SYSadmin, I like the Rundeck a lot.You may think like both can do automation. But as per my understanding is,
Jenkins - is for Development and CI/CD purpose.
Rundeck - Operation related automations
Im using Rundeck to automate my day to day DBA jobs. The recent version of Rundeck has few major changes in adding nodes and some other places. In this blog, I have mentioned the steps to configure Rundeck with MySQL as a Backend.
A Server(or VM) with CentOS 7
MySQL 5.7 or 8.0 (5.6 is old)
To verify the rundeck status run the below command.
Before accessing rundeck through browser, You need do the below changed in the config file.
If you want to access the Rundeck privately (through VPN), Use private IP to the configuration. You can also assign some CNAME URL for this.
Open any browser and type the URL as IP_address:4440
Change Default Password:
Rundeck using the default username as admin and its password as admin. To change this edit the realm.properties file and restart rundeck.
To learn more about authentication and adding new users, click here.
Add MySQL as a Backend:
By default, rundeck is using some DB file for storing the jobs and other information. But its not a better database for a Production environment. Rundeck supports MySQL and PostgreSQL as backends.
Install MySQL Repository
Enable MySQL 5.7 Repo
This repository will enable 8.0 as default installation. So we need to disable all versions and enable only on 5.7