|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/mysql-master-and-slave-replication/
课程评论：没有评论
课程名称：MySQL主从复制 课程概述： 欢迎参加本MySQL课程。如果您了解如何设置Oracle Data Guard，那么您将非常高兴地进入MySQL的复制世界。这个过程允许您将一个从数据库与主数据库进行复制。就像Oracle一样，主服务器是主要服务器，从服务器是备用服务器。这个过程也涉及重做传输。听起来不错吧？在本课程中，我们将模拟两个MySQL站点。在第一个站点，我们将设置主数据库，创建实例并填充一些表格。然后，我们将开始设置从站和复制。为了这个模拟，我们将使用两个虚拟机器，分别命名为“马德里”和“巴塞罗那”。课程内容将涵盖从头安装的Red Hat 6（64位）系统中的所有步骤，而没有任何数据库。在此课程中，您将看到以下关键字：MySQL；数据库；复制；主；从；二进制日志；中继日志；索引日志；启动脚本；环境脚本。该课程的资料将使用视频、幻灯片和包含所有命令及SQL语句的文本文件。课程时长约为3小时。 课程结构如下： 1. 在两个服务器上安装最新版本的MySQL 2. 创建MySQL用户和组，以及环境文件 3. 设置主服务器初始文件 4. 设置从服务器初始文件 5. 将主数据库导出到从站 6. 导入数据库并启动复制 7. 测试复制的正确性，并查看有关复制过程中主从服务器的一些有用信息 本课程是一个非常有用的示范，展示了如何在两个数据库之间进行复制。课程结束后，我将上传一些附加内容，讲解如何管理多个从服务器，并展示如何设置一个既是从服务器又是主服务器的实例。通过这些知识，您将能够建立一个复杂的MySQL数据库结构，其中包含一个主服务器及多个从服务器，而这些从服务器中的一个或多个也可以作为主服务器。该课程旨在让希望设置这种结构的所有人轻松理解。在短短几小时内，您将完成演示，并能够为您的公司提供这一高可用性工具。如果您正在寻找良好的在线备份或确保高可用性的网站，那么您需要参加此课程。
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.
