Mysql master and slave replication
Mysql master and slave replication, available at $19.99, has an average rating of 3.85, with 18 lectures, based on 26 reviews, and has 205 subscribers.
You will learn about 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 This course is ideal for individuals who are All Mysql dba can take this course or All people that want to add some skils in he's profile can take it too It is particularly useful for All Mysql dba can take this course or All people that want to add some skils in he's profile can take it too.
Enroll now: Mysql master and slave replication
Summary
Title: Mysql master and slave replication
Price: $19.99
Average Rating: 3.85
Number of Lectures: 18
Number of Published Lectures: 18
Number of Curriculum Items: 18
Number of Published Curriculum Objects: 18
Original Price: $19.99
Quality Status: approved
Status: Live
What You Will 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
Who Should Attend
- All Mysql dba can take this course
- All people that want to add some skils in he's profile can take it too
Target Audiences
- All Mysql dba can take this course
- All people that want to add some skils in he's profile can take it too
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.
Course Curriculum
Chapter 1: Mysql installation
Lecture 1: Topics of first block
Lecture 2: Short presentation and Server preparation
Lecture 3: Installation of mysql server in Master and Slave sites
Lecture 4: End of block 1
Chapter 2: Replication settings
Lecture 1: Topics of block 2
Lecture 2: Set the init file for replication in Master
Lecture 3: Create replication user and directories structure
Lecture 4: Dump the reference db from Master and import in Slave site
Lecture 5: Set replication On, make some test
Lecture 6: Explain all the init parameters
Lecture 7: Some administration scripts
Lecture 8: End of block 2
Chapter 3: My Slave is a Master
Lecture 1: Topics of block 3
Lecture 2: Create a new database "mysql2" in the Slave site
Lecture 3: Declare mysql2 as slave of mysql1, check replication flow
Lecture 4: Remove "mysql2" from mysql1 Master and attach it to Madrid Master
Lecture 5: End of this course
Lecture 6: ANEXES – Some txt file with command line
Instructors
-
Luis Diaz
Database dba since 2005
Rating Distribution
- 1 stars: 4 votes
- 2 stars: 1 votes
- 3 stars: 6 votes
- 4 stars: 5 votes
- 5 stars: 10 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024