Daily Tips for MySQL

Dear Readers, In this article, we will see the following Daily Tips for MySQL . MySQL Tips: 👉 In MySQL Replication Master can be ib RHEL and Slave can be on SUSE Linux.   Thank you for giving your valuable time to read the above… Read More

Group Replication Setup in MySQL

Group Replication in MySQL: MySQL Group Replication and how to install, configure and monitor groups. MySQL Group Replication enables you to create elastic, highly-available, fault-tolerant replication topologies. MySQL Group Replication is a MySQL Server plugin that provides distributed state machine replication with strong coordination between… Read More

MySQL Identifying unused indexes

Dear Readers, In this article, we will see MySQL Identifying unused indexes. Identifying unused indexes: MySQL doesn’t provide completely reliable options to get the accurate index usage details. Below listed are the some of the options available and some of the options are version specific… Read More

Migrating Table data from MySQL to Oracle Using SQL* LOADER

Hi Readers, In this article,we will see Migrating Table data from MySQL to Oracle Using SQL* LOADER. Step 1 : Connect to Mysql DB and create a table

Insert data into a table

Crosscheck the data in C_EMP TABLE

Step 2 : … Read More

Oracle to MySQL Heterogeneous Unidirectional Replication

Oracle to MySQL Heterogeneous Unidirectional Replication Hello Readers, In this article we will see how to make Heterogeneous Unidirectional Replication between Oracle and  MySQL. Source : Oracle DB(12.1.0) Target :  MySQL(5.7) Download Goldengate Binaries  Download GoldenGate binaries from Oracle.com using below link(Oracle) https://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html Make sure that you… Read More

INTRODUCTION TO SQL(Article -1)

INTRODUCTION TO SQL Overview : SQL is a language of database, it includes database creation, deletion, fetching rows and modifying rows etc. What is SQL? SQL is Structured/Syntax/Sequential Query Language, which is a language for storing, manipulating and retrieving data stored in relational database. SQL… Read More