search
  • Sign In
  • Sign Up
Password reset successful

Follow the proiects vou are interested in andi aet the latestnews about them taster

Home
Course List
Old boy mysql video tutorial

Old boy mysql video tutorial

In the mysql tutorial "Old Boy MySQL Video Tutorial" course, MySQL senior professional DBA and the basics of mysql will be explained, allowing learners to fully understand mysql!

745734 person learning
253 class hour
2022-04-21 update time
01 days08 Hours51 minutes12 seconds Total course duration
迷茫
Gold lecturer
46 Course
37863 student
5.3 score

业精于勤,荒于嬉;行成于思,毁于随。

You will learn

"Old Boy MySQL Video Tutorial" will help you master all aspects of the skills that operation and maintenance personnel of large, medium and small companies need to independently be responsible for DBA work. The newly recorded video is clear, super detailed and meticulous. It is currently the only most practical and closest to the enterprise in China. Courses for work scenarios include high-availability architecture, performance optimization, read-write separation, etc.

Old boy mysql video tutorial

Section1 Introduction to Operation and Maintenance DBA
06 minutes10 seconds
Section2 Introduction to database concepts
05 minutes12 seconds
Section3 Introduction to database types and principles of relational databases
03 minutes16 seconds
Section4 Introduction to non-relational databases
07 minutes25 seconds
Section5 Introduction to non-relational database types
05 minutes35 seconds
Section6 Relational database product introduction 1
05 minutes45 seconds
Section7 Relational database product introduction 2
09 minutes21 seconds
Section8 Non-relational database product introduction
04 minutes29 seconds
Section9 Database product rankings and development events
02 minutes16 seconds
Section10 MySQL database product introduction
04 minutes05 seconds
Section11 Summary of basic database content
03 minutes20 seconds
Section12 Why choose MySQL database? Introduction to the advantages of MySQL
10 minutes06 seconds
Section13 MySQL database classification and version upgrade knowledge explanation
05 minutes22 seconds
Section14 The difference between MySQL database commercial version and community version
04 minutes16 seconds
Section15 Explanation of release version knowledge of MySQL database
03 minutes52 seconds
Section16 Introduction to the three product lines of MySQL database development
07 minutes50 seconds
Section17 Introduction to MySQL database release version naming knowledge
01 minutes45 seconds
Section18 How to choose MySQL product line products and corresponding versions in enterprise production scenarios
09 minutes13 seconds
Section19 Introduction to 5 installation methods commonly used in MySQL database enterprise production
04 minutes45 seconds
Section20 How to choose the MySQL database version and installation method
06 minutes33 seconds
Section21 MySQL5.5 compilation method installation practice
49 minutes36 seconds
Section22 Introduction to MySQL database multiple instances
08 minutes00 seconds
Chapter1 Getting Started with MySQL Basics
Section1 In-depth knowledge and principles of MySQL startup and shutdown
15 minutes34 seconds
Section2 In-depth explanation of MySQL login knowledge
10 minutes27 seconds
Section3 Learn to use MySQL database help
14 minutes45 seconds
Section4 Practical methods and precautions for modifying mysql password - troubleshooting
15 minutes35 seconds
Section5 Practical practice on retrieving lost mysql password
21 minutes29 seconds
Section6 Retrieve lost mysql password in multiple instances
03 minutes02 seconds
Section7 SQL language introduction and classification detailed explanation
14 minutes42 seconds
Section8 Create different character set databases and explain enterprise scenario applications
18 minutes04 seconds
Section9 Explanation of database management applications such as display-connection-delete etc.
10 minutes01 seconds
Section10 Practical methods of creating mysql users and authorization
11 minutes54 seconds
Section11 Local and remote host authorization ideas and various methods in practice
07 minutes04 seconds
Section12 Do it yourself to determine the authorization list of MySQL
14 minutes51 seconds
Section13 Explanation of how to authorize users and permissions in production scenarios
05 minutes10 seconds
Section14 MySQL table creation statements and table knowledge
17 minutes14 seconds
Section15 View the table structure and table creation statements
04 minutes10 seconds
Section16 Index knowledge and practical methods of index creation
28 minutes30 seconds
Section17 Description of basic conditions for indexing to take effect
08 minutes17 seconds
Section18 Primary key-unique-common index creation and deletion summary
08 minutes58 seconds
Section19 DML statement insert knowledge explanation
14 minutes41 seconds
Section20 Practical explanation of DQL select knowledge
09 minutes26 seconds
Section21 Practical combat of DQL select multi-table connection query
13 minutes22 seconds
Section22 Use explain to view the execution plan of a sql statement
08 minutes22 seconds
Section23 Practice of modifying records in DML table
09 minutes20 seconds
Section24 A small trial of preliminary incremental recovery of MySQL data
11 minutes42 seconds
Section25 Answers to a complete set of interview questions on operation and maintenance of an enterprise
20 minutes28 seconds
Section26 DML modification table and practical solutions to serious enterprise failure cases
03 minutes00 seconds
Section27 Delete the data machine enterprise failure cases and prevention methods in the table
06 minutes30 seconds
Section28 Detailed practical explanation of adding, deleting and modifying table fields
07 minutes57 seconds
Section29 Practical explanation of changing table names and deleting tables
03 minutes35 seconds
Chapter3 MySQL application management and advanced practical operations
Section1 MySQL master-slave replication principle drawing oral exam explanation
19 minutes33 seconds
Section2 Explanation of tips for winning corporate interviews
19 minutes24 seconds
Section3 Practical explanation of multiple cases of MySQL master-slave replication failure
20 minutes36 seconds
Section4 MySQL master-slave replication configuration steps and precautions
03 minutes58 seconds
Section5 Main points of MySQL master-slave replication principle
06 minutes02 seconds
Section6 The best deployment solution for MySQL master-slave replication in enterprise scenarios
04 minutes31 seconds
Section7 Explanation of multiple solutions to obtain full backup and binlog location with one click
06 minutes40 seconds
Section8 One-click batch configuration of MySQL master-slave replication method without stopping the main database
02 minutes41 seconds
Section9 MySQL master-slave replication of 3 thread status information explained
10 minutes30 seconds
Section10 Detailed explanation of various cases of MySQL master-slave replication, read-write separation and authorization
28 minutes50 seconds
Section11 Ignore the actual synchronization of MySQL master-slave replication master database authorization table
07 minutes33 seconds
Section12 Ignore MySQL master-slave replication master database authorization table synchronization practice 2
00 minutes08 seconds
Section13 MySQL master-slave replication specifies synchronization parameters for different database tables
03 minutes15 seconds
Section14 MySQL master-slave replication slave read-only case practice and summary of principles
07 minutes13 seconds
Section15 Causes and practical solutions of MySQL master-slave replication failure in enterprise production scenarios
10 minutes10 seconds
Section16 Reasons for opening BINLOG from the library and practical explanation of starting it 1
04 minutes22 seconds
Section17 Reasons for opening BINLOG from the library and practical explanation of starting it 2
01 minutes24 seconds
Section18 Enterprise scenario: one master, multiple slaves, downtime, slave database switching, master continuation and slave synchronization process detailed explanation 1
08 minutes12 seconds
Section19 Enterprise scenario: one master, multiple slaves, downtime, slave database switching, master continuation and slave synchronization process detailed explanation 2
05 minutes34 seconds
Section20 Enterprise scenario: One master and multiple slaves are down and the slave database is down.
02 minutes23 seconds
Section21 Detailed explanation of dual-master and multi-master synchronization process and explanation of enterprise selection plan
24 minutes39 seconds
Chapter7 MySQL master-slave replication enterprise-level in-depth advanced application practice
Section1 Introduction and functions of heartbeat
05 minutes53 seconds
Section2 Heartbeat’s working principle and service switching conditions
10 minutes35 seconds
Section3 Heartbeat heartbeat connection introduction
07 minutes51 seconds
Section4 An explanation of the concept of split-brain
In calculation
Section5 Introduction to the various causes of split-brain
In calculation
Section6 8 secrets to prevent split-brain 01
09 minutes31 seconds
Section7 8 secrets to prevent split-brain 02
In calculation
Section8 8 secrets to prevent split-brain 03
In calculation
Section9 Description of fence equipment and arbitration mechanism
In calculation
Section10 Introduction to heartbeat message types
In calculation
Section11 IP takeover and failover principle of heartbeat
In calculation
Section12 Explanation of IP configuration management technology for high availability software
In calculation
Section13 Introduction to the default path configuration of heartbeat
In calculation
Section14 heartbeat software version branch description
In calculation
Section15 Introduction to heartbeat enterprise application scenarios
In calculation
Section16 Description of business requirements for deploying heartbeat high availability
In calculation
Section17 Simulation server preparation and IP configuration instructions
In calculation
Section18 Configure host name and server hosts file resolution
In calculation
Section19 Configure inter-server heartbeat connections
In calculation
Section20 Explanation on installing heartbeat software and configuration files
In calculation
Section21 Explanation of the main configuration file parameters of heartbeat
In calculation
Section22 Actual configuration heartbeat configuration file
In calculation
Section23 Start the heartbeat service and view the configured VIP
03 minutes38 seconds
Section24 Split-brain failure occurs and troubleshooting ideas based on the previous principles
In calculation
Section25 Analyzing the takeover process through heartbeat logs
In calculation
Section26 Heartbeat implements web service high availability practical case 1
In calculation
Section27 Heartbeat implements high availability of web services Practical Case 1 Principle
In calculation
Section28 heartbeat implements high availability of web services case 2
In calculation
Section29 Production scenario applications related to heartbeat calling resources
In calculation
Section30 heartbeat high availability case expansion
In calculation
Section31 Differences in application scenarios between heartbeat and keepalived
In calculation
Section32 Maintenance points in heartbeat service production environment 1
In calculation
Section33 Maintenance points of heartbeat service in production environment 2
In calculation
Section34 heartbeat service production environment maintenance FAQ
In calculation
Chapter11 Practical use of heartbeat tools available for mysql
Chapter12 Practical combat of MySQL high availability tool drbd
Section1 Important thoughts before class
31 minutes51 seconds
Section2 MySQL high availability requirements and architecture explained
05 minutes27 seconds
Section3 The location and architecture of MySQL high availability in large-scale cluster architecture
05 minutes18 seconds
Section4 MySQL high availability practical simulation environment description
In calculation
Section5 MySQL high availability production scenario configuration and network address planning
In calculation
Section6 MySQL high availability implementation formal environment preparation and split-brain attention
In calculation
Section7 Quickly install heartbeat under dual-machine Centos6.4 and configure startup
In calculation
Section8 Quickly install the drbd service preparation under dual-machine Centos6.4 01
In calculation
Section9 Quick installation of DRBD service under dual-machine Centos6.4 02
In calculation
Section10 Detailed explanation of drbd service status information details
In calculation
Section11 Start the service to test the actual synchronization of DRBD
In calculation
Section12 Debug drbd service configuration with heartbeat
In calculation
Section13 Debugging drbd service configuration with heartbeat 2
01 minutes24 seconds
Section14 MySQL service installation practical installation process explanation
06 minutes22 seconds
Section15 One-click installation of Mysql multiple instances practical explanation and demonstration
06 minutes34 seconds
Section16 Manually test MySQL high availability switch
05 minutes53 seconds
Section17 Practical implementation of MySQL dual-master high availability automatic switching
05 minutes42 seconds
Section18 Explanation of configuration considerations for MySQL dual-master high availability my.cnf
In calculation
Section19 Important principles and troubleshooting ideas for MySQL high availability switching
In calculation
Section20 MySQL master-slave synchronization one-click installation script actual combat
In calculation
Section21 MySQL multi-master multi-slave high availability cluster automatic switching implementation
03 minutes38 seconds
Section22 Explanation of MySQL high availability precautions and common faults
In calculation
Section23 Introduction to more ideas and solutions for MySQL cluster and high availability
01 minutes10 seconds
Chapter13 MySQL high availability comprehensive implementation practice

Data Name

Old boy mysql video tutorial courseware source code
Download