As Oracle dataguard, let setup a Mysqk rReplication between the master and slave databases.

Welcome to this Mysql course.

If you learn how to setup an Oracle dataguard, then you'll be very pleased to enter in the replcation world of Mysql.

This process allow you to have a slave database replicated with the master one. As with Oracle, the master is the primary and the slave is the standby. The process is redo transport too... Funny no ?? So here, we'll simulate we have 2 mysql sites. In the first site we'll set the master database. We'll create an instance and we'll populate some tables. Then we'll start to setup the slave site, and the replication.

For this simulation, we'll use 2 virtual machines. Both virtual machines will have town' s names (Madrid and Barcelona). The course will cover all the steps as we'll start with a fresh install of red hat 6 (64bits) without any database.