Shulou(Shulou.com)06/01 Report--

MySQL Master-Slave replication Project implementation and maintenance 01 (MR) _ MySQL High availability replication and distributed Cluster Architecture 02

Video tutorial learning address

Http://edu.51cto.com/course/14237.html

Oracle/MySQL database learning special QQ group: 336282998, 189070296

After learning Brother Feng, you can be familiar with the following contents:

I. course content

The basic principles of 1.MySQL replication Technology

Common Master-Slave Topology of 2.MySQL replication Technology Foundation

Synchronous mode based on 3.MySQL replication technology (asynchronous / semi-synchronous / lossless synchronization / full synchronization)

Synchronization Mode based on 4.MySQL replication Technology (traditional / GDIT)

Detailed explanation of common configuration parameters on the basis of 5.MySQL replication technology

6.MySQL true production high availability replication environment 1-traditional asynchronous replication project

7.MySQL Real production High availability replication Environment 2-traditional Lossless synchronization Project

8.MySQL true production high availability replication environment 3-asynchronous replication projects based on GTID

9.MySQL true production high availability replication environment 4-lossless synchronization project based on GTID

10.MySQL true production high availability replication environment 5-add / delete / expand replication nodes

11.MySQL true production high availability replication environment 6-one master and multi-slave secure replication project

12.MySQL true production high availability replication environment 7-cascading master-slave replication projects

13.MySQL true production high availability replication environment 8-multi-master, one-slave, multi-source replication project

Master-slave switching of 14.MySQL master-slave replication project (normal handover / downtime switchover)

15.MySQL Master / Slave copy Project online enable / disable GTID

SSL Security configuration of 16.MySQL Master-Slave replication Project

Master-slave synchronization data check of 17.MySQL master-slave replication project

Daily maintenance and fault handling of 18.MySQL master-slave replication project

II. Special topic recommendation

MySQL High availability replication and distributed Cluster Architecture (thematic series)

Http://edu.51cto.com/topic/1622.html

This stage of the course, the only network, and is the current mainstream architecture of the Internet, involving multiple servers, nearly 100 databases, tens of millions of data levels of the project experiment.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.