Mysql master and slave replication

As Oracle dataguard, let setup a Mysqk rReplication between the master and slave databases.
4.0 (1 rating)
Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
84 students enrolled
Instructed by Luis Diaz Development / Databases
$19
$20
5% off
Take This Course
  • Lectures 18
  • Length 3 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2014 English

Course Description

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.

During this course, you'll see the folowing key words:

Mysq ; Databases ; Replication ; Master ; Slave ; Binlogs ; Relaylog ; Indexlog ; Startup Script ; Environment script.

The material used in this course will be videos, slides and a txt file with all the commands and sql sentences. This course is about 3 hours.

The course is structured following this plan:

1 Installtion of the last version of Mysql in both servers

2 Creation of the user and group mysql, and environment files

3 Set up the Master init file

4 Set up the Slave init file

5 Export Master database to the slave site

6 Import the database and start Replication

7 Make some test of the correct replication and let see some usefull information about Master and Slave during the Replication

This course is a very usefull demonstration of making a Replication between 2 databases. After the main course, I'll upload some addons about manage more than one slave and we'll see an example of how set a Slave that is a Master at the same time. With all this knowledge, you'll be able to set a complexe structure of Mysql databases with one master, severals slaves and on or more of this slave can be a Master too. The course is designed to be easely ingested by all the people who wants to set this kind of structure.

In a few hours you'll have the demonstration done, and you will be able to offer this higth availability tool in your compagny.

So if you are looking for a good way to have online backup or an online site to garantee higth availability, then you need this course.

What are the requirements?

  • You'll need 2 virtual machines with Red hat 64 bits installed yet.
  • You should be familiar with Mysql world but not as secialist, newbee is enougth

What am I going to get from this course?

  • Install Mysql server in red hat linux system
  • Set Master / Slave replication between 2 or more databases
  • Changes the replication flow to manage failures or upgrades

What is the target audience?

  • All Mysql dba can take this course
  • All people that want to add some skils in he's profile can take it too

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Mysql installation
Topics of first block
3 pages
Short presentation and Server preparation
Preview
14:05
Installation of mysql server in Master and Slave sites
15:36
End of block 1
3 pages
Section 2: Replication settings
Topics of block 2
3 pages
Set the init file for replication in Master
10:56
Create replication user and directories structure
08:09
Dump the reference db from Master and import in Slave site
06:14
Set replication On, make some test
18:00
Explain all the init parameters
13:10
Some administration scripts
13:32
End of block 2
3 pages
Section 3: My Slave is a Master
Topics of block 3
3 pages
Create a new database "mysql2" in the Slave site
17:36
Declare mysql2 as slave of mysql1, check replication flow
13:34
Remove "mysql2" from mysql1 Master and attach it to Madrid Master
10:10
End of this course
3 pages
ANEXES - Some txt file with command line
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Luis Diaz, Database dba since 2005

I was born in Spain and then travel to Paris where I start studying databases.

Then I go back to Spain and since 2005 I work exclusivly as Oracle dba. During several years I work in diferents environments and I touch a lot of Oracle technology. Here is part of this knowledge. Most recently, I work with Oracle 12c grid version, Oracle dataguard 11g and some other technologies as Rman o Oracle FlashBack.

Citare aqui unas de las operaciones que realize con exito:

- Mantenimiento de las instancias de Oracle

- Migración Grid control de 10G a 11G

- Migración de datos de un diskgroup a otro. (Cambiar discos de cabina)

- Copia de seguridad diseño de las políticas de recuperación de las bases de datos

- Instalación diseño e instalación de nuevo RAC entornos ASM ersión 11gR2

- Seguimiento con las herramientas de monitoring de OVO, Grid Control y Ganglia

- Creación de nuevas alarmas para OVO

- Restoración de bases de datos con RMAN duplicate

- Formación de un equipo de desarolladores con Oracle FlashBack. Simulamos perdidas de datos tras una release y recuperamos los datos perdidos gracias a FB

Ready to start learning?
Take This Course