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
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
Dear Readers, in this article , we will see, Connecting to MySQL without entering the password using mysql_config_editor The mysql_config_editor utility enables you to store authentication credentials in an obfuscated login path file named.mylogin.cnf. The file location is the %APPDATA%\MySQL directory on Windows and the… Read More
Dear Readers, In this article,we will see Creating a MySQL DB Instance in Amazon RDS (Relational Database Service) . Implementation steps : Create MySQL DB Instance. Download connect.php file. open connect.php file and replace username, password, hostname and DB name. Create S3 Bucket. Upload connect.php file… Read More
Dear Readers, In this article,we will see brief explanation regarding to RDS(Relational Database Service). What is AWS RDS? Amazon Relational Database Service (Amazon RDS) is a web service that makes it easier to set up, operate, and scale a relational database in the cloud. It… Read More
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
MySQL to Oracle Heterogeneous Unidirectional Replication using Slave Server Bin log In this article we will see MySQL to Oracle Heterogeneous Unidirectional Replication using Slave Server Bin log First setup Master -slave replication between two mysql servers. Use below link to setup Master-slave Replication MySQL… Read More
MySQL to Oracle Heterogeneous GoldenGate Unidirectional Replication In this article we will see MySQL to Oracle GoldenGate Unidirectional Replication. Prerequisites for Replication: 1.Create two VM’s on your machine 2.Install MySQL on Source Sever. 3.Install Oracle Software and Create database on target. 4.Make sure two Vm’s are… Read More
Physical Backups in MySQL (Article -20). In this article we can cover Physical backups in MySQL. Physical backups consist of raw copies of the directories and files that store database contents. This type of backup is suitable for large, important databases that need to be… Read More
MAKING RAW MyISAM BACKUP IN MySQL (Article -19). MyISAM was the default storage engine for the MySQL relational database management system versions prior to 5.5 released in December 2009. it is based on the older ISAM code. Filesystem Each MyISAM table is stored on disk in three files (if it is not partitioned).… Read More
