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