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 … Continue reading Dockerizing MySQL step by step.
Creating a Simple MySQL Binlog Server
In my previous Blog i have explained how we can integrate MySQL tools ( Percona Tool kit ) with systemd service, At Mydbops works with multiple clients ,we get various requirements from customers a few may be a complex ones ,one of the requirement was to setup a binlog server and copy the Production binlogs … Continue reading Creating a Simple MySQL Binlog Server
Jinja2 for better Ansible
Jinja2 is a modern and designer-friendly templating language for Python frameworks. It is fast, reliable and widely used for dynamic file generation based on its parameter. In this blog, I like to share how and where jinja2 template language used in Ansible and how we can create better Ansible playbook. How it works The Jinja … Continue reading Jinja2 for better Ansible
Configuring efficient MySQL Logrotate
I am a Junior DBA at Mydbops. This is my first blog professionally, I would like to brief my encounter with Log-rotate in first few weeks of my work, Hope it will help other beginners as well. This Blog will cover the following sections. Introduction to Log-rotate Issues FacedSolutions (Fix for the above issues)Best practicesHow … Continue reading Configuring efficient MySQL Logrotate
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 … Continue reading Automate MySQL 8.0 Installation with Ansible
Migrate MySQL data to RDS/Aurora Using Xtrabackup
In this blog, I will provide a step by step procedure to migrate from on-premise MySQL to Amazon RDS/Aurora using Percona-xtrabackup Both RDS and Aurora is a DBAAS provided by Amazon. To know more on DBAAS you can view our presentation here. When you are having a database in size of few GB, it would … Continue reading Migrate MySQL data to RDS/Aurora Using Xtrabackup
MySQL Partition Manager (Yahoo!) in a nutshell
Partitioning is a way of splitting the actual data down into separate .ibd files (data compartments) in the file system based on the defined ranges using the partitioning key. It can help us with maintaining the enormous amount of data in different partitions without much hassle. In this blog post, we are going to see how … Continue reading MySQL Partition Manager (Yahoo!) in a nutshell
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 … Continue reading Replicating data from MySQL to Oracle
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 … Continue reading How To design a better Ansible Role for MySQL Environment ?
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 … Continue reading Ansible Best Practices