Category Archives: replication

MySQL Fabric – Part 1 – Installing

MySQL Fabric is a tool included on MySQL Utilities that helps you to manage your MySQL instances. It works by basically adding a new layer between your application and MySQL instances, which can provide an easy way to use sharding … Continue reading




Liked? Help and Share!
Posted in install, MySQL, performance, replication | 3 Comments

MySQL Sandbox

Hi there, today we will learn about an amazing tool that every single MySQL dba must know, I’m talking about MySQL Sandbox. MySQL Sandbox is developed by Giuseppe Maxia (The Data Charmer), it’s a tool that make the installation of MySQL servers … Continue reading




Liked? Help and Share!
Posted in install, MySQL, replication | 3 Comments

Multi-Source Replication with MySQL 5.7 – example

Complementing this previous post, today we are going to configure 1 slave receiving updates from 2 master with Multi-source replication. As mention before, this feature is only available on labs.mysql.com. To configure it, is very simple, we are going to … Continue reading




Liked? Help and Share!
Posted in replication | 11 Comments

MySQL Multi Source Replication

Last week, durring MySQL Connect, MySQL 5.7.2 DMR was launched, one of the new functionality is the multi source replication. At the moment, MySQL can have only one master per slave (you can archive multi source replication via some hacks, … Continue reading




Liked? Help and Share!
Posted in MySQL, replication | 2 Comments

Why Does MySQL Replication Delays?

These days I’ve answer some questions about replication lag, and I realized that most of people does not correctly understand how this process works internally on MySQL, and why does delays happen: MySQL replication: most important config parameters for performance … Continue reading




Liked? Help and Share!
Posted in binlog, performance, replication | Leave a comment

How Does MySQL Replication Works?

See the bellow image, it represents how asynchronous replication works on MySQL Bearing in mind the number on the image, let’s see how the process works: Item 1 in the image represents the clients executing queries on master, note that … Continue reading




Liked? Help and Share!
Posted in binlog, replication | Leave a comment

Got a packet bigger than ‘slave_max_allowed_packet’ bytes and binlog_format = STATEMENT | MIXED

Got a packet bigger than ‘slave_max_allowed_packet’ bytes and binlog_format=STATEMENT|MIXED Since version 5.1.64 MySQL introduces a new variable named slave_max_allowed_packet, which was introduced to allow large updates using row-based replication do not cause replication to fail when exceeded max_allowed_packet. The problem … Continue reading




Liked? Help and Share!
Posted in binlog, bug, replication | Leave a comment

MySQL 5.6 Replication with GTID – Global Transaction ID

Hi guys, Early February Oracle released the new version of MySQL named 5.6, one of the enhancements is the GTID (Global Transaction ID) GTID is an unique identifier which will be added at each transaction, and will be very useful … Continue reading




Liked? Help and Share!
Posted in backup, binlog, install, replication | 2 Comments

MySQL Replication with SSL

Hi folks, let’s continue talk about replication, you can see the basics in this other post First of all, lets create the ssl certificates, go to the master server: Create CA certificate: openssl genrsa 2048 > ca-key.pem openssl req -new … Continue reading




Liked? Help and Share!
Posted in MySQL, password, replication, Security | 2 Comments

MySQL replication – Master – Slave

To explain the replication, we will use the article Installing MySQL 5.5 Part 2 – Multiple instances with mysqld_multi because we will need 2 MySQL’s running on our server Let’s activate the binary logs on our server, creating a file … Continue reading




Liked? Help and Share!
Posted in binlog, MySQL, replication | 11 Comments