MySQL: Difference between revisions

104 bytes added ,  22 May 2017
Line 4: Line 4:
* ''Last tested on Ubuntu 14.04.05 LTS (trusty) as the master, and Ubuntu 16.04.02 LTS (xenial) as the slave.''
* ''Last tested on Ubuntu 14.04.05 LTS (trusty) as the master, and Ubuntu 16.04.02 LTS (xenial) as the slave.''


In this procedure, the master is assumed to have tables with InnoDB with data.  Some parameters and commands are specifically for InnoDB engines. My master happens to be MySQL and the slave happens to be running MariaDB.  This shouldn't cause any issues as MariaDB is a drop-in replacement for MySQL.
In this procedure, the master is assumed to have tables with InnoDB with data.  Some parameters and commands are specifically for InnoDB engines.
 
My master happens to be MySQL and the slave happens to be running MariaDB.  This shouldn't cause any issues as MariaDB is a drop-in replacement for MySQL as long as you DO NOT use GTID.  However, if both are same types the use of GTID is highly recommended.


The slave is a newly installed Ubuntu server installation.
The slave is a newly installed Ubuntu server installation.