MySQL Schema change With Skeema – Part 2 “Production use cases”

In the previous blog, we have gone through the Basic operation of the Skeema tool. In this blog, we will see the production use case of the Skeema tool. Selective schema setup :All (Global) servers :Selective server execution:Selective schema validation of production server :Concurrency and other notable options :Environment based Execution:Conclusion : Selective schema setup …

Exploring Aurora Serverless V2 for MySQL

Aurora Serverless V2 is generally available around the corner recently 21-04-22 for MySQL 8 and PostgreSQL, with promising features that overcome the V1 disadvantages. Below are those major features Features Online auto instance upsize (vertical scaling)Read scaling (Supports up to 15 Read-replica)Supports mixed-configuration cluster ie, the master can be normal Aurora(provisioned) and readers can be …

Dockerizing MySQL step by step.

As a Database Engineer in Mydbops. We tend to solve multiple complex problems for our esteemed customers. To control the System resources and scale up /down based on needed we are evaluating Dockers and Kubernetes. Docker is a set of platform as a service products that uses OS-level virtualization to deliver software in packages called …

10 New Functions for JSON Columns in MySQL 8.

 MySQL has come a long way, and keeps on bringing in new improvements and new collections of JSON functions. Here are a few techniques to store data in JSON columns. MySQL Vs MariaDB JSON Implementation : There is a key difference on how JSON is implemented in MySQL and in MariaDB. MySQL has implemented JSON …

Automate MySQL 8.0 Installation with Ansible

Introduction : Ansible is an open-source IT automation engine which can remove drudgery from your work life, and will also dramatically improve the scalability, consistency, and reliability of your IT environment. Nowadays without automation to manage the Databases is very tricky. We are using Ansible as an infra automation tool to install, configure and manage …

Replicating data from MySQL to Oracle

In our work, We used to get a lot of requirements for replicating data from one data source to another.Previously I wrote replication from MySQL to Red-shift. In this blog I am going to explain about replicating the data from MySQL to Oracle using Tungsten replicator. 1.0. Tungsten Replicator : It is an open source …

How To design a better Ansible Role for MySQL Environment ?

In our earlier stage of Ansible, we just wrote simple playbook and ad-hoc command with very long ansible hosts file. When we plan to use Ansible extensively in our daily production use case, we understand that simple playbooks don't help to scale up to our expectation. Even though we had options for separate variables, handlers and template …

Presentation : MySQL Load balancers and its solution

MySQL load balancers becomes a trend setters in Market for High availability and Scalability. They offer variety of solutions for database. What can be the best load balancer ? It varies from case to case. This presentation was made at Mydbops meetup on 04-08-2018 covers the basics of load balancers with their advantages/ disadvantages and …

Presentation : Handling Schema Changes Via Percona Toolkit

The schema changes in production can cause lock at time and makes the slave to lag. It is more tedious and troublesome with PXC ( Galera ) cluster which can be made smoother with Percona online schema change. Image Courtesy : Photo by Andrew Ruiz on Unsplash

Ansible Best Practices

Managing Heterogeneous environment without automation can be tricky. We are using Ansible as an automation tool for install, configure and manage DB infra for Mydbops. Using Ansible, we overcome a lot of obstacle's and we would like to share our learning with the community ( Our Presentation on Ansible )   Best Practices to write …