Migrating data from On-Premises MySQL to Azure database for MySQL using DMS

Author- Kriti Bhardwaj(Data Engineer) In this documentation you will learn how to migrate On-premises MySQL to Azure database for MySQL using DMS. Here I have taken demo sample database to migrate with minimal downtime. Pre-requisites: Create Azure database for MySQL. Create a virtual machine. Create DMS. Install MySQL workbench. Both Azure database for MySQL and…

Migarting Different Schemas between Azure SQL database using ADF

Migarting Different Schemas between Azure SQL database using ADF

Author: Ankit Gupta (Associate Data Engineer), Hitesh Srivastava (Associate Data Engineer) This article describes how to migrate selected tables with different schema from one Azure SQL database to another Azure SQL database through Azure Data Factory. Prerequisites: Two Azure SQL databases (Source with a sample database and destination) Azure Data factory SSMS Step 1: Connect…

Database migration from Managed Instance to SQL Server with transactional replication

Author- Ashfaq Pathan (Associate Data Engineer) Transactional Replication Setup We will set up a transactional replication for migrating the database from Managed Instance to SQL Server 2017 hosted on Azure SQL-VM. Managed Instance will be both Publisher and Distributor. SQL Server will be Subscriber. Prerequisites: 1. Azure Subscription. 2. Storage account with one file-share in it…

ELK Stack

Installation of ELK Stack on CentOS

Author: Prashant Pawar, Cloud Engineer   The ELK Stack — is a collection of open-source software Elasticsearch, Logstash, and Kibana on the server side, along with Filebeat on the client side which allows you to search, analyse, and visualize logs generated from any source in any format, a practice known as centralized logging. The Elastic Stack has four main components: Elasticsearch: a distributed RESTful search…