REPLICATION TROUBLESHOOTING – CLASSIC VS GTID

In previous posts, I was talking about how to set up MySQL replication, Classic Replication (based on binary logs information) and Transaction-based Replication (based on GTID). In this article I’ll summarize how to troubleshoot … Continue Reading →


Multiple Master on Single Slave MySQL

Multi-Source Replication Tutorials This section provides tutorials on how to configure masters and slaves for multi-source replication, and how to start, stop and reset multi-source slaves.  Configuring Multi-Source Replication This … Continue Reading →


Upgrade Mysql to 5.7 on Linux

How to Install Latest MySQL 5.7.9 on RHEL/CentOS 7/6/5 and Fedora 23/22/21 MySQL is an open source free relational database management system (RDBMS) released under GNU (General Public License). It is … Continue Reading →


Mysql [Warning] Using a password on the command line interface can be insecure.

If your MySQL client/server version is a 5.6.x a way to avoid the WARNING message are using the mysql_config_editor tools:   mysql_config_editor set –login-path=local –host=localhost –user=username –password Then you can use in … Continue Reading →


Master Slave GTID issues

If you find duplicate query in slave please follow the below steps to skip the query from slave. Steps: Take the ID from show slave status\G Retrieved_Gtid_Set: 7d72f9b4-8577-11e2-a3d7-080027635ef5:1-5 (This is … Continue Reading →