Article
Topic
Learning
Download
Q&A
Programming Dictionary
Game
Recent Updates
LOGIN
简体中文(ZH-CN)
English(EN)
繁体中文(ZH-TW)
日本語(JA)
한국어(KO)
Melayu(MS)
Français(FR)
Deutsch(DE)
Next Section: Explanation of MySQL high availability precautions and common faults
(1988 plays)
Next Section
Watch Again
ဆ
Chapter
Note
Ask
Courseware
Feedback
Old boy mysql video tutorial
Chapter1 Getting Started with MySQL Basics
1-1 Introduction to Operation and Maintenance DBA
1-2 Introduction to database concepts
1-3 Introduction to database types and principles of relational databases
1-4 Introduction to non-relational databases
1-5 Introduction to non-relational database types
1-6 Relational database product introduction 1
1-7 Relational database product introduction 2
1-8 Non-relational database product introduction
1-9 Database product rankings and development events
1-10 MySQL database product introduction
1-11 Summary of basic database content
1-12 Why choose MySQL database? Introduction to the advantages of MySQL
1-13 MySQL database classification and version upgrade knowledge explanation
1-14 The difference between MySQL database commercial version and community version
1-15 Explanation of release version knowledge of MySQL database
1-16 Introduction to the three product lines of MySQL database development
1-17 Introduction to MySQL database release version naming knowledge
1-18 How to choose MySQL product line products and corresponding versions in enterprise production scenarios
1-19 Introduction to 5 installation methods commonly used in MySQL database enterprise production
1-20 How to choose the MySQL database version and installation method
1-21 MySQL5.5 compilation method installation practice
1-22 Introduction to MySQL database multiple instances
Chapter2 Oldboy MySQL multi-instance installation and enterprise application scenarios
2-1 Introduction to the advantages and problems of multiple instances of MySQL database
2-2 Portal enterprise application scenario with multiple instances of MySQL database
2-3 Introduction to various configuration solutions for MySQL database multiple instances
2-4 Practical explanation of multi-instance installation of MySQL database
2-5 MySQL database multi-instance initialization and service startup
2-6 MySQL database multi-instance startup problem troubleshooting methods and practical troubleshooting
2-7 Practical troubleshooting of multiple instances of MySQL database
2-8 Add a third instance of MySQL database to give practical explanation
2-9 Description of other faults in MySQL database multiple instances
Chapter3 MySQL application management and advanced practical operations
3-1 In-depth knowledge and principles of MySQL startup and shutdown
3-2 In-depth explanation of MySQL login knowledge
3-3 Learn to use MySQL database help
3-4 Practical methods and precautions for modifying mysql password - troubleshooting
3-5 Practical practice on retrieving lost mysql password
3-6 Retrieve lost mysql password in multiple instances
3-7 SQL language introduction and classification detailed explanation
3-8 Create different character set databases and explain enterprise scenario applications
3-9 Explanation of database management applications such as display-connection-delete etc.
3-10 Practical methods of creating mysql users and authorization
3-11 Local and remote host authorization ideas and various methods in practice
3-12 Do it yourself to determine the authorization list of MySQL
3-13 Explanation of how to authorize users and permissions in production scenarios
3-14 MySQL table creation statements and table knowledge
3-15 View the table structure and table creation statements
3-16 Index knowledge and practical methods of index creation
3-17 Description of basic conditions for indexing to take effect
3-18 Primary key-unique-common index creation and deletion summary
3-19 DML statement insert knowledge explanation
3-20 Practical explanation of DQL select knowledge
3-21 Practical combat of DQL select multi-table connection query
3-22 Use explain to view the execution plan of a sql statement
3-23 Practice of modifying records in DML table
3-24 A small trial of preliminary incremental recovery of MySQL data
3-25 Answers to a complete set of interview questions on operation and maintenance of an enterprise
3-26 DML modification table and practical solutions to serious enterprise failure cases
3-27 Delete the data machine enterprise failure cases and prevention methods in the table
3-28 Detailed practical explanation of adding, deleting and modifying table fields
3-29 Practical explanation of changing table names and deleting tables
Chapter4 MySQL garbled code problem and character set practice
4-1 MySQL data garbled code and multiple solutions in practice 1
4-2 MySQL data garbled code and multiple solutions in practice 2
4-3 5 ways to prevent MySQL from garbled characters and an in-depth explanation of the root causes
4-4 Next section content and homework instructions
4-5 Thoughts before class - 230,000 students from the 17th batch joined BAT company
4-6 Thoughts before class - and explanation of test questions before class
4-7 Introduction to MySQL character sets and instructions for commonly used character sets in production
4-8 Differences between different MySQL character sets and enterprise production choices
4-9 The cause of MySQL garbled code begins to reveal the system impact
4-10 What exactly does executing set names on MySQL do?
4-11 What exactly does the MySQL command import with character set do?
4-12 MySQL data Chinese is not garbled, the ultimate practice
4-13 The ultimate summary of MySQL data that is not garbled in Chinese
4-14 Explanation of the solution for changing the character set of MySQL data on the production line
Chapter5 MySQL incremental backup and data recovery basic practice
5-1 The significance and importance of backing up data
5-2 Mysqldump multiple command parameter backup practice
5-3 How mysqldump logical backup works
5-4 Explanation of the idea and various methods of backing up multiple libraries
5-5 MySQL single and multiple table backup practice and script batch backup explanation
5-6 Only backup MySQL table structure and only backup MySQL data
5-7 Detailed explanation of different engine backup command parameters in enterprise production scenarios
5-8 Explanation and practice on using source to restore mysql data
5-9 How to restore mysql to the sub-database after the sub-database backup
5-10 mysql process-status-explanation of important knowledge about modifying parameters online
5-11 Mysqlbinlog command introduction and practical explanation
5-12 Detailed explanation of mysqldump-master-data parameters Q&A
Chapter6 MySQL master-slave replication principle and practical deployment
6-1 The role and importance of master-slave replication is introduced by the architecture
6-2 An introduction to a large collection of various synchronization solutions for files and DBs
6-3 Introduction to mysql master-slave replication and implementation of distributed database architecture
6-4 Application scenarios of master-slave synchronization and introduction to multiple solutions for switching slave databases without losing data
6-5 Introduction to reading and writing separation of mysql database and enterprise production implementation plan
6-6 Split business applications into different databases based on enterprise business
6-7 Mysql master-slave replication principle drawing explained in simple terms
6-8 mysql master-slave replication practice 01
6-9 mysql master-slave replication practice 02
6-10 Description of an ultra-simple implementation of master-slave replication
Chapter7 MySQL master-slave replication enterprise-level in-depth advanced application practice
7-1 MySQL master-slave replication principle drawing oral exam explanation
7-2 Explanation of tips for winning corporate interviews
7-3 Practical explanation of multiple cases of MySQL master-slave replication failure
7-4 MySQL master-slave replication configuration steps and precautions
7-5 Main points of MySQL master-slave replication principle
7-6 The best deployment solution for MySQL master-slave replication in enterprise scenarios
7-7 Explanation of multiple solutions to obtain full backup and binlog location with one click
7-8 One-click batch configuration of MySQL master-slave replication method without stopping the main database
7-9 MySQL master-slave replication of 3 thread status information explained
7-10 Detailed explanation of various cases of MySQL master-slave replication, read-write separation and authorization
7-11 Ignore the actual synchronization of MySQL master-slave replication master database authorization table
7-12 Ignore MySQL master-slave replication master database authorization table synchronization practice 2
7-13 MySQL master-slave replication specifies synchronization parameters for different database tables
7-14 MySQL master-slave replication slave read-only case practice and summary of principles
7-15 Causes and practical solutions of MySQL master-slave replication failure in enterprise production scenarios
7-16 Reasons for opening BINLOG from the library and practical explanation of starting it 1
7-17 Reasons for opening BINLOG from the library and practical explanation of starting it 2
7-18 Enterprise scenario: one master, multiple slaves, downtime, slave database switching, master continuation and slave synchronization process detailed explanation 1
7-19 Enterprise scenario: one master, multiple slaves, downtime, slave database switching, master continuation and slave synchronization process detailed explanation 2
7-20 Enterprise scenario: One master and multiple slaves are down and the slave database is down.
7-21 Detailed explanation of dual-master and multi-master synchronization process and explanation of enterprise selection plan
Chapter8 MySQL backup and recovery practical cases and production plans
8-1 Detailed explanation of the concepts, advantages and disadvantages of full and incremental backup
8-2 Analysis of how different enterprises choose backup solutions and scenarios that require backup recovery
8-3 Analysis of conditions for incremental recovery of enterprise scenario databases
8-4 Necessary conditions for MySQL data recovery and graphic analysis of recovery case scenarios
8-5 Actual simulation of enterprise data loss application case scenarios
8-6 MySQL database incremental recovery detailed practice
8-7 More discussions and summaries on incremental recovery of MySQL database
8-8 MySQL incremental recovery summary and core recovery ideas
8-9 After-school self-study ability homework
8-10 Internal student technical conference sharing schedule description
Chapter9 Detailed introduction to MySQL service logs and incremental recovery commands
9-1 Mysqlbinlog command introduction and practical explanation
9-2 Detailed explanation of mysqldump-master-data parameters Q&A
9-3 Introduction and practice of MySQL service error log
9-4 Introduction and practice of common query logs of MySQL service
9-5 Introduction and practice of MySQL service slow query log
9-6 Detailed introduction to the three working modes of MySQL service binary log
9-7 Practical configuration methods of three working modes of MySQL service binary log
Chapter10 MySQL commonly used engines and their advantages and disadvantages
10-1 Introduction to MySQL service storage engine
10-2 MySQL service storage engine architecture
10-3 MySQL service MyISAM engine introduction and disk file format
10-4 Detailed introduction to MySQL service transactions and description of ACID features
10-5 MySQL service MyISAM engine features explained
10-6 MySQL service MyISAM engine is suitable for production application scenarios
10-7 MySQL service MyISAM engine tuning essentials
10-8 MySQL service InnoDB engine introduction and disk file format
10-9 MySQL service InnoDB engine features explained
10-10 Production application scenarios suitable for the MySQL service InnoDB engine
10-11 MySQL service InnoDB engine tuning and comparison of different engine functions
10-12 MySQL service engine type functions and corresponding parameter configuration instructions
10-13 Various solutions for batch modification of MySQL service engine
10-14 Interview questions and other explanations about MySQL service storage engine
Chapter11 Practical use of heartbeat tools available for mysql
11-1 Introduction and functions of heartbeat
11-2 Heartbeat’s working principle and service switching conditions
11-3 Heartbeat heartbeat connection introduction
11-4 An explanation of the concept of split-brain
11-5 Introduction to the various causes of split-brain
11-6 8 secrets to prevent split-brain 01
11-7 8 secrets to prevent split-brain 02
11-8 8 secrets to prevent split-brain 03
11-9 Description of fence equipment and arbitration mechanism
11-10 Introduction to heartbeat message types
11-11 IP takeover and failover principle of heartbeat
11-12 Explanation of IP configuration management technology for high availability software
11-13 Introduction to the default path configuration of heartbeat
11-14 heartbeat software version branch description
11-15 Introduction to heartbeat enterprise application scenarios
11-16 Description of business requirements for deploying heartbeat high availability
11-17 Simulation server preparation and IP configuration instructions
11-18 Configure host name and server hosts file resolution
11-19 Configure inter-server heartbeat connections
11-20 Explanation on installing heartbeat software and configuration files
11-21 Explanation of the main configuration file parameters of heartbeat
11-22 Actual configuration heartbeat configuration file
11-23 Start the heartbeat service and view the configured VIP
11-24 Split-brain failure occurs and troubleshooting ideas based on the previous principles
11-25 Analyzing the takeover process through heartbeat logs
11-26 Heartbeat implements web service high availability practical case 1
11-27 Heartbeat implements high availability of web services Practical Case 1 Principle
11-28 heartbeat implements high availability of web services case 2
11-29 Production scenario applications related to heartbeat calling resources
11-30 heartbeat high availability case expansion
11-31 Differences in application scenarios between heartbeat and keepalived
11-32 Maintenance points in heartbeat service production environment 1
11-33 Maintenance points of heartbeat service in production environment 2
11-34 heartbeat service production environment maintenance FAQ
Chapter12 Practical combat of MySQL high availability tool drbd
12-1 Introduction to the working principle of drbd
12-2 Working principle diagram of drbd
12-3 drbd service introduction
12-4 drbd replication protocol and application mode
12-5 Introduction to enterprise application scenarios of drbd
12-6 Introduction to common operation and maintenance synchronization tools
12-7 drbd deployment and ip configuration planning
12-8 drbd deployment and ip configuration planning
12-9 Installation and configuration preparation of drbd software
12-10 Creating synchronized partitions using drbd
12-11 drbd environment partition description and partition commands
12-12 drbd related configuration list description
12-13 Actual installation of drbd software
12-14 Configure drbd to load into the kernel module
12-15 Drbd configuration file parameter explanation and actual configuration
12-16 drbd service initialization data fault machine troubleshooting process
12-17 Start drbd and configure master-slave synchronization data
12-18 Common faults and troubleshooting methods of drbd service
12-19 Mount test database synchronization and view standby node data
Chapter13 MySQL high availability comprehensive implementation practice
13-1 Important thoughts before class
13-2 MySQL high availability requirements and architecture explained
13-3 The location and architecture of MySQL high availability in large-scale cluster architecture
13-4 MySQL high availability practical simulation environment description
13-5 MySQL high availability production scenario configuration and network address planning
13-6 MySQL high availability implementation formal environment preparation and split-brain attention
13-7 Quickly install heartbeat under dual-machine Centos6.4 and configure startup
13-8 Quickly install the drbd service preparation under dual-machine Centos6.4 01
13-9 Quick installation of DRBD service under dual-machine Centos6.4 02
13-10 Detailed explanation of drbd service status information details
13-11 Start the service to test the actual synchronization of DRBD
13-12 Debug drbd service configuration with heartbeat
13-13 Debugging drbd service configuration with heartbeat 2
13-14 MySQL service installation practical installation process explanation
13-15 One-click installation of Mysql multiple instances practical explanation and demonstration
13-16 Manually test MySQL high availability switch
13-17 Practical implementation of MySQL dual-master high availability automatic switching
13-18 Explanation of configuration considerations for MySQL dual-master high availability my.cnf
13-19 Important principles and troubleshooting ideas for MySQL high availability switching
13-20 MySQL master-slave synchronization one-click installation script actual combat
13-21 MySQL multi-master multi-slave high availability cluster automatic switching implementation
13-22 Explanation of MySQL high availability precautions and common faults
13-23 Introduction to more ideas and solutions for MySQL cluster and high availability
Chapter14 MySQL database optimization ideas and optimization practices
14-1 Basic ideas for troubleshooting slow website opening
14-2 Website opens slowly MySQL slow query optimization enterprise case
14-3 Website opening slow mysql problem multiple solutions enterprise case
14-4 Core experience cases that Linux operation and maintenance personnel must master
14-5 Various optimized production plans and details of MySQL database 01
14-6 Various optimized production plans and details of MySQL database 02
14-7 Various optimized production plans and details of MySQL database 03
14-8 Various optimized production plans and details of MySQL database 04
14-9 Summary of various optimization production solutions for MySQL database 05
Chapter15 MySQL business change process and security management ideas
15-1 Project development process and database update process
15-2 DBA participates in project database design and trains developers to efficiently design MYSQL library statements
15-3 Project cycle development ideas
15-4 Solution case for high cpu usage of linux process
15-5 Various ideas and techniques for database account permission control
15-6 Detailed explanation of database client security control strategy
15-7 Core management ideas of database operation and maintenance
Chapter16 MySQL database index optimization and data loss cases
16-1 An explanation of the basic points of MySQL index optimization 01
16-2 MySQL index optimization production case explanation 02
16-3 MySQL data loss lesson case in production environment
Chapter17 Intensive lecture on core optimization of MySQL database production scenarios
17-1 Various optimized production plans and details of MySQL database 01
17-2 Multiple optimization production plans and details of MySQL database 02
17-3 Various optimized production plans and details of MySQL database 03
17-4 Various optimized production plans and details of MySQL database 04
17-5 Summary of various optimization production solutions for MySQL database 05
Chapter18 MySQL read-write separation development and software implementation
18-1 Introduction and practical explanation of the solution to realize reading and writing separation in PHP program
18-2 Amoeba software implements database reading and writing separation in practice
18-3 Amoeba software implements database reading and writing separation practice 2
18-4 Mysql client phpmyadmin installation and deployment practice
18-5 Mysql-proxy software implements database reading and writing separation in practice
Previous section
Next Section
Tutorial List
get help
Course Recommendations
Courseware download
Intermediate
Front-end Vue3 actual combat [handwritten vue project]
2857 people are watching
Elementary
APIPOST tutorial [Popularization of technical concepts related to network communication]
1795 people are watching
Intermediate
Issue 22_Comprehensive actual combat
5521 people are watching
Elementary
Issue 22_PHP Programming
5172 people are watching
Elementary
Issue 22_Front-end development
8713 people are watching
Intermediate
Big data (MySQL) video tutorial full version
4525 people are watching
Elementary
Go language tutorial-full of practical information and no nonsense
2794 people are watching
Elementary
GO Language Core Programming Course
2814 people are watching
Intermediate
JS advanced and BootStrap learning
2563 people are watching
Intermediate
SQL optimization and troubleshooting (MySQL version)
3374 people are watching
Intermediate
Redis+MySQL database interview tutorial
2963 people are watching
Elementary
Deliver food or learn programming?
5708 people are watching
Old boy mysql video tutorial courseware source code
Belongs to chapter:Old boy mysql video tutorial
Download
Students who have watched this course are also learning
491211 plays
Let's briefly talk about starting a business in PHP
Quick introduction to web front-end development
Large-scale practical Tianlongbabu development of Mini version MVC framework imitating the encyclopedia website of embarrassing things
Getting Started with PHP Practical Development: PHP Quick Creation [Small Business Forum]
Login verification and classic message board
Computer network knowledge collection
Quick Start Node.JS Full Version
The front-end course that understands you best: HTML5/CSS3/ES6/NPM/Vue/...[Original]
Write your own PHP MVC framework (40 chapters in depth/big details/must read for newbies to advance)
notes
X
About us
Disclaimer
Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!