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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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