Tag: ansible

Harnessing the power of Jinja2 with Ansible

Configuration files management is the core component of every configuration management tool. Templates are one of the best methods for creating configuration files as they allow dynamic variables. Ansible has a template module that uses Jinja2 in its core. Jinja2…

Read More >

RDS provisioning: A comparision between Ansible and Terraform

I recently had to compare these two configuration managers to provision MySQL environments in RDS. I had previous Ansible knowledge but I was fairly new to Terraform. With that in mind, I put together a list of resources to see…

Read More >

Automating Tungsten upgrades using Ansible

Continuent Tungsten is one of the few all-in-one solutions for MySQL high availability. In this post I will show you how to automate the upgrade process using Ansible. I will walk you through the individual tasks and, finally, give you…

Read More >

Automating Oracle patching with an Ansible module

This is a blog post I had on my To Do list for quite some time. I finally found some time to write about it. I will try to keep it short and clear. In 2017 when I discovered Ansible,…

Read More >

Using Ansible role to setup Oracle ACFS on multiple nodes

This post contains step by step instructions for creating an Ansible role acfssetup to setup Oracle ASM Cluster Filesystem (ACFS) on multiple nodes of a cluster. This assumes that Grid Infrastructure 12.1.0.2.0 is already installed on the nodes, and ASM…

Read More >

Interesting happenstance when installing Ansible dependencies in a MySQL Docker container

I’ve been posting quite a bit about Docker as I’ve been working with it a lot as of late. I thought I would share something interesting I discovered a couple weeks ago while working on setting up a Docker container-based…

Read More >

Neo4j cluster using Vagrant, Ansible and Virtualbox

Recently, I was faced with the need to create and configure a Neo4j cluster. In order to be able to easily experiment with different settings and configurations, I decided I needed to create a local to Neo4j cluster using Vagrant,…

Read More >

Creating Ansible Custom Module for AWR report generation

Creating AWR reports is a common task for many DBAs. At times, you may need to generate multiple AWR reports from multiple databases for performance audit; Ansible allows you to automate these types of tasks. You can, for example, generate…

Read More >

Automating Oracle RMAN backup configuration on Linux with Ansible

Having valid backup of the databases is one of the most important tasks for every DBAs. Having proper RMAN backup scripts on place and covering all aspects to protect your databases can be lifesaving in the event that a crisis hits. However, when you’re…

Read More >

Automating password rotation for Oracle databases

Password rotation is not the most exciting task in the world, and that’s exactly why it’s a perfect candidate for automation. Automating routine tasks like this are good for everyone – DBAs can work on something that’s more exciting, companies…

Read More >
Page 1 of 212