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 … Continue reading 10 New Functions for JSON Columns in MySQL 8.

GeoSpatial data handling made easy with MySQL 8.0

Human geography examines the dynamics of cultures, societies and economies, and physical geography examines the dynamics of physical landscapes and the environment. In this blog i am going to explain what are the new Geography features available in MySQL 8.0 Major Difference in MySQL 5.7 & 8.0 Geography : There is a big change from … Continue reading GeoSpatial data handling made easy with MySQL 8.0

Security: Data Masking in MySQL 8.0 server

Data security plays a major role in current age. Privacy matters a lot. Data masking is one of the Key Features when comes to security. In MySQL community versions if you want to mask your data, You can go with a Maxscale load balancer. They introduced a new masking filter on the Maxscale 2.1 version. … Continue reading Security: Data Masking in MySQL 8.0 server

MySQL Clone Plugin Speed Test

In my previous blog, I have explained how the MySQL clone plugin works internally. In this blog, I am going to do a comparison of  Backup and Recovery speed of MySQL clone plugin with other available mysql open source backup tools. Below tools are used for speed comparison of Backup and Recovery, Clone-Plugin Xtrabackup mysqldump … Continue reading MySQL Clone Plugin Speed Test

MySQL 8.0 Clone Plugin and its internal process.

MySQL 8 has recently released clone plugin which makes DBA's task of rebuilding the DB servers more easy. Cloning is a process of creating an exact copy of the original. In technical terms cloning alias to (Backup + Recovery), MySQL database cloning requires a sequence of actions to be performed manually or in a scripted fashion … Continue reading MySQL 8.0 Clone Plugin and its internal process.

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

Common Table Expression (CTE) MySQL 8.0.

1.0. Introduction: MySQL 8.0 was released with awesome features. One of its most prominent features is CTE (Common Table Expression). The Common Table Expression can be used to construct complex queries in a more readable manner. In this blog, I have described how the CTE works with some useful examples. 1.1 What is CTE? A Common … Continue reading Common Table Expression (CTE) MySQL 8.0.

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

MySQL to Amazon Redshift Replication.

In our work, We used to get a lot of requirements for replicating data from one data source to another. Our team provided solutions to replicate data from MySQL to Vertica, Amazon Redshift, Hadoop. Out of which Amazon Redshift replication is a bit complicated as Amazon Redshift is a Database as a service (DBaaS) and the … Continue reading MySQL to Amazon Redshift Replication.

Invisible Indexes – MySQL 8.0

MySQL 8.0 has a rich set of features. One of the feature which interests DBA's more is invisible index What is an index in MySQL ? The indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table … Continue reading Invisible Indexes – MySQL 8.0