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
业精于勤，荒于嬉;行成于思，毁于随。
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 Introduction to the advantages and problems of multiple instances of MySQL database
02 minutes35 seconds
Section2 Portal enterprise application scenario with multiple instances of MySQL database
04 minutes00 seconds
Section3 Introduction to various configuration solutions for MySQL database multiple instances
04 minutes19 seconds
Section4 Practical explanation of multi-instance installation of MySQL database
13 minutes50 seconds
Section5 MySQL database multi-instance initialization and service startup
08 minutes56 seconds
Section6 MySQL database multi-instance startup problem troubleshooting methods and practical troubleshooting
08 minutes41 seconds
Section7 Practical troubleshooting of multiple instances of MySQL database
09 minutes38 seconds
Section8 Add a third instance of MySQL database to give practical explanation
10 minutes49 seconds
Section9 Description of other faults in MySQL database multiple instances
13 minutes47 seconds
Chapter2 Oldboy MySQL multi-instance installation and enterprise application scenarios
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 data garbled code and multiple solutions in practice 1
11 minutes34 seconds
Section2 MySQL data garbled code and multiple solutions in practice 2
02 minutes16 seconds
Section3 5 ways to prevent MySQL from garbled characters and an in-depth explanation of the root causes
14 minutes15 seconds
Section4 Next section content and homework instructions
07 minutes23 seconds
Section5 Thoughts before class - 230,000 students from the 17th batch joined BAT company
10 minutes20 seconds
Section6 Thoughts before class - and explanation of test questions before class
06 minutes17 seconds
Section7 Introduction to MySQL character sets and instructions for commonly used character sets in production
11 minutes03 seconds
Section8 Differences between different MySQL character sets and enterprise production choices
12 minutes40 seconds
Section9 The cause of MySQL garbled code begins to reveal the system impact
04 minutes24 seconds
Section10 What exactly does executing set names on MySQL do?
04 minutes16 seconds
Section11 What exactly does the MySQL command import with character set do?
05 minutes34 seconds
Section12 MySQL data Chinese is not garbled, the ultimate practice
11 minutes49 seconds
Section13 The ultimate summary of MySQL data that is not garbled in Chinese
11 minutes34 seconds
Section14 Explanation of the solution for changing the character set of MySQL data on the production line
12 minutes55 seconds
Chapter4 MySQL garbled code problem and character set practice
Section1 The significance and importance of backing up data
08 minutes26 seconds
Section2 Mysqldump multiple command parameter backup practice
24 minutes51 seconds
Section3 How mysqldump logical backup works
06 minutes05 seconds
Section4 Explanation of the idea and various methods of backing up multiple libraries
15 minutes30 seconds
Section5 MySQL single and multiple table backup practice and script batch backup explanation
07 minutes39 seconds
Section6 Only backup MySQL table structure and only backup MySQL data
14 minutes28 seconds
Section7 Detailed explanation of different engine backup command parameters in enterprise production scenarios
12 minutes27 seconds
Section8 Explanation and practice on using source to restore mysql data
05 minutes00 seconds
Section9 How to restore mysql to the sub-database after the sub-database backup
15 minutes22 seconds
Section10 mysql process-status-explanation of important knowledge about modifying parameters online
22 minutes48 seconds
Section11 Mysqlbinlog command introduction and practical explanation
31 minutes04 seconds
Section12 Detailed explanation of mysqldump-master-data parameters Q&A
07 minutes43 seconds
Chapter5 MySQL incremental backup and data recovery basic practice
Section1 The role and importance of master-slave replication is introduced by the architecture
06 minutes26 seconds
Section2 An introduction to a large collection of various synchronization solutions for files and DBs
07 minutes46 seconds
Section3 Introduction to mysql master-slave replication and implementation of distributed database architecture
14 minutes29 seconds
Section4 Application scenarios of master-slave synchronization and introduction to multiple solutions for switching slave databases without losing data
15 minutes38 seconds
Section5 Introduction to reading and writing separation of mysql database and enterprise production implementation plan
05 minutes31 seconds
Section6 Split business applications into different databases based on enterprise business
04 minutes57 seconds
Section7 Mysql master-slave replication principle drawing explained in simple terms
29 minutes31 seconds
Section8 mysql master-slave replication practice 01
11 minutes52 seconds
Section9 mysql master-slave replication practice 02
21 minutes45 seconds
Section10 Description of an ultra-simple implementation of master-slave replication
01 minutes22 seconds
Chapter6 MySQL master-slave replication principle and practical deployment
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 Detailed explanation of the concepts, advantages and disadvantages of full and incremental backup
13 minutes46 seconds
Section2 Analysis of how different enterprises choose backup solutions and scenarios that require backup recovery
09 minutes01 seconds
Section3 Analysis of conditions for incremental recovery of enterprise scenario databases
03 minutes16 seconds
Section4 Necessary conditions for MySQL data recovery and graphic analysis of recovery case scenarios
17 minutes13 seconds
Section5 Actual simulation of enterprise data loss application case scenarios
11 minutes07 seconds
Section6 MySQL database incremental recovery detailed practice
18 minutes03 seconds
Section7 More discussions and summaries on incremental recovery of MySQL database
10 minutes25 seconds
Section8 MySQL incremental recovery summary and core recovery ideas
16 minutes22 seconds
Section9 After-school self-study ability homework
11 minutes47 seconds
Section10 Internal student technical conference sharing schedule description
07 minutes18 seconds
Chapter8 MySQL backup and recovery practical cases and production plans
Section1 Mysqlbinlog command introduction and practical explanation
31 minutes02 seconds
Section2 Detailed explanation of mysqldump-master-data parameters Q&A
07 minutes34 seconds
Section3 Introduction and practice of MySQL service error log
08 minutes57 seconds
Section4 Introduction and practice of common query logs of MySQL service
09 minutes00 seconds
Section5 Introduction and practice of MySQL service slow query log
02 minutes22 seconds
Section6 Detailed introduction to the three working modes of MySQL service binary log
12 minutes09 seconds
Section7 Practical configuration methods of three working modes of MySQL service binary log
19 minutes26 seconds
Chapter9 Detailed introduction to MySQL service logs and incremental recovery commands
Section1 Introduction to MySQL service storage engine
06 minutes07 seconds
Section2 MySQL service storage engine architecture
06 minutes08 seconds
Section3 MySQL service MyISAM engine introduction and disk file format
04 minutes48 seconds
Section4 Detailed introduction to MySQL service transactions and description of ACID features
13 minutes03 seconds
Section5 MySQL service MyISAM engine features explained
04 minutes29 seconds
Section6 MySQL service MyISAM engine is suitable for production application scenarios
04 minutes46 seconds
Section7 MySQL service MyISAM engine tuning essentials
06 minutes03 seconds
Section8 MySQL service InnoDB engine introduction and disk file format
03 minutes54 seconds
Section9 MySQL service InnoDB engine features explained
02 minutes46 seconds
Section10 Production application scenarios suitable for the MySQL service InnoDB engine
08 minutes22 seconds
Section11 MySQL service InnoDB engine tuning and comparison of different engine functions
05 minutes13 seconds
Section12 MySQL service engine type functions and corresponding parameter configuration instructions
13 minutes33 seconds
Section13 Various solutions for batch modification of MySQL service engine
11 minutes53 seconds
Section14 Interview questions and other explanations about MySQL service storage engine
04 minutes15 seconds
Chapter10 MySQL commonly used engines and their advantages and disadvantages
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
Section1 Introduction to the working principle of drbd
07 minutes44 seconds
Section2 Working principle diagram of drbd
In calculation
Section3 drbd service introduction
In calculation
Section4 drbd replication protocol and application mode
In calculation
Section5 Introduction to enterprise application scenarios of drbd
In calculation
Section6 Introduction to common operation and maintenance synchronization tools
In calculation
Section7 drbd deployment and ip configuration planning
In calculation
Section8 drbd deployment and ip configuration planning
In calculation
Section9 Installation and configuration preparation of drbd software
In calculation
Section10 Creating synchronized partitions using drbd
In calculation
Section11 drbd environment partition description and partition commands
In calculation
Section12 drbd related configuration list description
In calculation
Section13 Actual installation of drbd software
In calculation
Section14 Configure drbd to load into the kernel module
In calculation
Section15 Drbd configuration file parameter explanation and actual configuration
10 minutes17 seconds
Section16 drbd service initialization data fault machine troubleshooting process
29 minutes22 seconds
Section17 Start drbd and configure master-slave synchronization data
In calculation
Section18 Common faults and troubleshooting methods of drbd service
In calculation
Section19 Mount test database synchronization and view standby node data
23 minutes24 seconds
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
Section1 Basic ideas for troubleshooting slow website opening
In calculation
Section2 Website opens slowly MySQL slow query optimization enterprise case
In calculation
Section3 Website opening slow mysql problem multiple solutions enterprise case
In calculation
Section4 Core experience cases that Linux operation and maintenance personnel must master
03 minutes55 seconds
Section5 Various optimized production plans and details of MySQL database 01
14 minutes35 seconds
Section6 Various optimized production plans and details of MySQL database 02
In calculation
Section7 Various optimized production plans and details of MySQL database 03
In calculation
Section8 Various optimized production plans and details of MySQL database 04
In calculation
Section9 Summary of various optimization production solutions for MySQL database 05
In calculation
Chapter14 MySQL database optimization ideas and optimization practices
Section1 Project development process and database update process
07 minutes11 seconds
Section2 DBA participates in project database design and trains developers to efficiently design MYSQL library statements
In calculation
Section3 Project cycle development ideas
In calculation
Section4 Solution case for high cpu usage of linux process
08 minutes13 seconds
Section5 Various ideas and techniques for database account permission control
In calculation
Section6 Detailed explanation of database client security control strategy
In calculation
Section7 Core management ideas of database operation and maintenance
In calculation
Chapter15 MySQL business change process and security management ideas
Section1 An explanation of the basic points of MySQL index optimization 01
58 minutes35 seconds
Section2 MySQL index optimization production case explanation 02
25 minutes24 seconds
Section3 MySQL data loss lesson case in production environment
20 minutes46 seconds
Chapter16 MySQL database index optimization and data loss cases
Section1 Various optimized production plans and details of MySQL database 01
14 minutes33 seconds
Section2 Multiple optimization production plans and details of MySQL database 02
In calculation
Section3 Various optimized production plans and details of MySQL database 03
In calculation
Section4 Various optimized production plans and details of MySQL database 04
In calculation
Section5 Summary of various optimization production solutions for MySQL database 05
01 minutes23 seconds
Chapter17 Intensive lecture on core optimization of MySQL database production scenarios
Section1 Introduction and practical explanation of the solution to realize reading and writing separation in PHP program
23 minutes26 seconds
Section2 Amoeba software implements database reading and writing separation in practice
37 minutes31 seconds
Section3 Amoeba software implements database reading and writing separation practice 2
14 minutes55 seconds
Section4 Mysql client phpmyadmin installation and deployment practice
22 minutes19 seconds
Section5 Mysql-proxy software implements database reading and writing separation in practice
35 minutes09 seconds
Chapter18 MySQL read-write separation development and software implementation
Data Name
Old boy mysql video tutorial courseware source code
Download
迷茫 Lecturer Other Courses
Popular courses
JAVA Beginner's Video Tutorial
753 class hour
2982743
Little Turtle's zero-based introduction to learning Python video tutorial
60 class hour
546852
Quick introduction to web front-end development
8 class hour
220812
Master PS video tutorials from scratch
268 class hour
1003522
Latest courses
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
[Web front-end] Node.js quick start
16 class hour
16700
Complete collection of foreign web development full-stack courses
12 class hour
13510
Go language practical GraphQL
10 class hour
11154
550W fan master learns JavaScript from scratch step by step
1 class hour
1265
