Mysql master and slave replication

Name: Mysql master and slave replication
Rating: 3.7 (26 reviews)

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

Created byLuis Diaz

Last updated 12/2014

English

What you'll learn

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

Course content

3 sections • 18 lectures • 2h 46m total length

Topics of first block3:00
Short presentation and Server preparation14:05
Learn to set up mysql master and slave replication across two Red Hat Linux VMs, export a reference database, and maintain data consistency between Madrid and Barcelona.
Installation of mysql server in Master and Slave sites15:36
Install and configure MySQL server on master and slave sites, manage dependencies, create databases and users, set passwords, and start or stop the service for replication readiness.
End of block 13:00

Topics of block 23:00
Set the init file for replication in Master10:56
Create replication user and directories structure8:09
Learn to set up MySQL master-slave replication by creating a replication user, preparing directories, granting replication privileges, and configuring the slave for coordinated data synchronization.
Dump the reference db from Master and import in Slave site6:14
Dump the reference database from the master and import it into the slave site, then verify replicated data and configure the slave by setting up hosts and passwords.
Set replication On, make some test18:00
Enable MySQL master and slave replication and run tests by importing data on the master. Verify the slave’s status and positions match after inserting fifty thousand rows.
Explain all the init parameters13:10
Demystify mysql replication basics, detailing master–slave setup, binary logs and events, log formats, positions, and how slaves read from the master to stay synchronized.
Some administration scripts13:32
Develop and use bash administration scripts to manage MySQL master and slave replication, including start, stop, status checks, and dynamic site configuration for two databases.
End of block 23:00

Topics of block 33:00
Create a new database "mysql2" in the Slave site17:36
Create a new mysql2 database on the slave using a separate data directory and binary set. Configure it to connect as a slave to the master for replication.
Declare mysql2 as slave of mysql1, check replication flow13:34
Declare mysql2 as a slave of mysql1 and verify replication through a Barcelona slave, testing with inserts on the master and confirming updates on the slave.
Remove "mysql2" from mysql1 Master and attach it to Madrid Master10:10
Detach mysql2 from mysql1 master and attach to Madrid master to reconfigure the master-slave replication, stop the slave, synchronize to the last position, and update passwords.
End of this course3:00
ANEXES - Some txt file with command line7:04

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

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.

Who this course is for:

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

Mysql master and slave replication

What you'll learn

Explore related topics

Course content

Mysql installation4 lectures • 36min

Replication settings8 lectures • 1hr 16min

My Slave is a Master6 lectures • 54min

Requirements

Description

Who this course is for: