This project is a tool to compare two MySQL or MariaDB databases structure showing these details in form of text in a terminal, or writing them into a log file as you prefer. This tool is available by ...
In this article we want to achieve a goal of replicating the structure only from Master to Slave not the data, this is useful in case we do not want to expose production or critical data to the slave ...
For rails projects, there is no additional step; activerecord-mysql-structure will hook into your application automagically. For non-rails projects, you can use the structure.sql sanitizing utility ...
In part 2 of his #MySQL Binary Log Internals series, Marcelo breaks down the first bytes of a MySQL binary log file: the 4-byte magic number and the 19-byte common event header. He walks through a ...