Introduction to Operation and Maintenance DBA

Introduction to database concepts

Introduction to database types and principles of relational databases

Introduction to non-relational databases

Introduction to non-relational database types

Relational database product introduction 1

Relational database product introduction 2

Non-relational database product introduction

Database product rankings and development events

MySQL database product introduction

Summary of basic database content

Why choose MySQL database? Introduction to the advantages of MySQL

MySQL database classification and version upgrade knowledge explanation

The difference between MySQL database commercial version and community version

Explanation of release version knowledge of MySQL database

Introduction to the three product lines of MySQL database development

Introduction to MySQL database release version naming knowledge

How to choose MySQL product line products and corresponding versions in enterprise production scenarios

Introduction to 5 installation methods commonly used in MySQL database enterprise production

How to choose the MySQL database version and installation method

MySQL5.5 compilation method installation practice

Introduction to MySQL database multiple instances

Introduction to the advantages and problems of multiple instances of MySQL database

Portal enterprise application scenario with multiple instances of MySQL database

Introduction to various configuration solutions for MySQL database multiple instances

Practical explanation of multi-instance installation of MySQL database

MySQL database multi-instance initialization and service startup

MySQL database multi-instance startup problem troubleshooting methods and practical troubleshooting

Practical troubleshooting of multiple instances of MySQL database

Add a third instance of MySQL database to give practical explanation

Description of other faults in MySQL database multiple instances

In-depth knowledge and principles of MySQL startup and shutdown

In-depth explanation of MySQL login knowledge

Learn to use MySQL database help

Practical methods and precautions for modifying mysql password - troubleshooting

Practical practice on retrieving lost mysql password

Retrieve lost mysql password in multiple instances

SQL language introduction and classification detailed explanation

Create different character set databases and explain enterprise scenario applications

Explanation of database management applications such as display-connection-delete etc.

Practical methods of creating mysql users and authorization

Local and remote host authorization ideas and various methods in practice

Do it yourself to determine the authorization list of MySQL

Explanation of how to authorize users and permissions in production scenarios

MySQL table creation statements and table knowledge

View the table structure and table creation statements

Index knowledge and practical methods of index creation

Description of basic conditions for indexing to take effect

Primary key-unique-common index creation and deletion summary

DML statement insert knowledge explanation

Practical explanation of DQL select knowledge

Practical combat of DQL select multi-table connection query

Use explain to view the execution plan of a sql statement

Practice of modifying records in DML table

A small trial of preliminary incremental recovery of MySQL data

Answers to a complete set of interview questions on operation and maintenance of an enterprise

DML modification table and practical solutions to serious enterprise failure cases

Delete the data machine enterprise failure cases and prevention methods in the table

Detailed practical explanation of adding, deleting and modifying table fields

Practical explanation of changing table names and deleting tables

MySQL data garbled code and multiple solutions in practice 1

MySQL data garbled code and multiple solutions in practice 2

5 ways to prevent MySQL from garbled characters and an in-depth explanation of the root causes

Next section content and homework instructions

Thoughts before class - 230,000 students from the 17th batch joined BAT company

Thoughts before class - and explanation of test questions before class

Introduction to MySQL character sets and instructions for commonly used character sets in production

Differences between different MySQL character sets and enterprise production choices

The cause of MySQL garbled code begins to reveal the system impact

What exactly does executing set names on MySQL do?

What exactly does the MySQL command import with character set do?

MySQL data Chinese is not garbled, the ultimate practice

The ultimate summary of MySQL data that is not garbled in Chinese

Explanation of the solution for changing the character set of MySQL data on the production line

The significance and importance of backing up data

Mysqldump multiple command parameter backup practice

How mysqldump logical backup works

Explanation of the idea and various methods of backing up multiple libraries

MySQL single and multiple table backup practice and script batch backup explanation

Only backup MySQL table structure and only backup MySQL data

Detailed explanation of different engine backup command parameters in enterprise production scenarios

Explanation and practice on using source to restore mysql data

How to restore mysql to the sub-database after the sub-database backup

mysql process-status-explanation of important knowledge about modifying parameters online

Mysqlbinlog command introduction and practical explanation

Detailed explanation of mysqldump-master-data parameters Q&A

The role and importance of master-slave replication is introduced by the architecture

An introduction to a large collection of various synchronization solutions for files and DBs

Introduction to mysql master-slave replication and implementation of distributed database architecture

Application scenarios of master-slave synchronization and introduction to multiple solutions for switching slave databases without losing data

Introduction to reading and writing separation of mysql database and enterprise production implementation plan

Split business applications into different databases based on enterprise business

Mysql master-slave replication principle drawing explained in simple terms

mysql master-slave replication practice 01

mysql master-slave replication practice 02

Description of an ultra-simple implementation of master-slave replication

MySQL master-slave replication principle drawing oral exam explanation

Explanation of tips for winning corporate interviews

Practical explanation of multiple cases of MySQL master-slave replication failure

MySQL master-slave replication configuration steps and precautions

Main points of MySQL master-slave replication principle

The best deployment solution for MySQL master-slave replication in enterprise scenarios

Explanation of multiple solutions to obtain full backup and binlog location with one click

One-click batch configuration of MySQL master-slave replication method without stopping the main database

MySQL master-slave replication of 3 thread status information explained

Detailed explanation of various cases of MySQL master-slave replication, read-write separation and authorization

Ignore the actual synchronization of MySQL master-slave replication master database authorization table

Ignore MySQL master-slave replication master database authorization table synchronization practice 2

MySQL master-slave replication specifies synchronization parameters for different database tables

MySQL master-slave replication slave read-only case practice and summary of principles

Causes and practical solutions of MySQL master-slave replication failure in enterprise production scenarios

Reasons for opening BINLOG from the library and practical explanation of starting it 1

Reasons for opening BINLOG from the library and practical explanation of starting it 2

Enterprise scenario: one master, multiple slaves, downtime, slave database switching, master continuation and slave synchronization process detailed explanation 1

Enterprise scenario: one master, multiple slaves, downtime, slave database switching, master continuation and slave synchronization process detailed explanation 2

Enterprise scenario: One master and multiple slaves are down and the slave database is down.

Detailed explanation of dual-master and multi-master synchronization process and explanation of enterprise selection plan

Detailed explanation of the concepts, advantages and disadvantages of full and incremental backup

Analysis of how different enterprises choose backup solutions and scenarios that require backup recovery

Analysis of conditions for incremental recovery of enterprise scenario databases

Necessary conditions for MySQL data recovery and graphic analysis of recovery case scenarios

Actual simulation of enterprise data loss application case scenarios

MySQL database incremental recovery detailed practice

More discussions and summaries on incremental recovery of MySQL database

MySQL incremental recovery summary and core recovery ideas

After-school self-study ability homework

Internal student technical conference sharing schedule description

Mysqlbinlog command introduction and practical explanation

Detailed explanation of mysqldump-master-data parameters Q&A

Introduction and practice of MySQL service error log

Introduction and practice of common query logs of MySQL service

Introduction and practice of MySQL service slow query log

Detailed introduction to the three working modes of MySQL service binary log

Practical configuration methods of three working modes of MySQL service binary log

Introduction to MySQL service storage engine

MySQL service storage engine architecture

MySQL service MyISAM engine introduction and disk file format

Detailed introduction to MySQL service transactions and description of ACID features

MySQL service MyISAM engine features explained

MySQL service MyISAM engine is suitable for production application scenarios

MySQL service MyISAM engine tuning essentials

MySQL service InnoDB engine introduction and disk file format

MySQL service InnoDB engine features explained

Production application scenarios suitable for the MySQL service InnoDB engine

MySQL service InnoDB engine tuning and comparison of different engine functions

MySQL service engine type functions and corresponding parameter configuration instructions

Various solutions for batch modification of MySQL service engine

Interview questions and other explanations about MySQL service storage engine

Introduction and functions of heartbeat

Heartbeat’s working principle and service switching conditions

Heartbeat heartbeat connection introduction

An explanation of the concept of split-brain

Introduction to the various causes of split-brain

8 secrets to prevent split-brain 01

8 secrets to prevent split-brain 02

8 secrets to prevent split-brain 03

Description of fence equipment and arbitration mechanism

Introduction to heartbeat message types

IP takeover and failover principle of heartbeat

Explanation of IP configuration management technology for high availability software

Introduction to the default path configuration of heartbeat

heartbeat software version branch description

Introduction to heartbeat enterprise application scenarios

Description of business requirements for deploying heartbeat high availability

Simulation server preparation and IP configuration instructions

Configure host name and server hosts file resolution

Configure inter-server heartbeat connections

Explanation on installing heartbeat software and configuration files

Explanation of the main configuration file parameters of heartbeat

Actual configuration heartbeat configuration file

Start the heartbeat service and view the configured VIP

Split-brain failure occurs and troubleshooting ideas based on the previous principles

Analyzing the takeover process through heartbeat logs

Heartbeat implements web service high availability practical case 1

Heartbeat implements high availability of web services Practical Case 1 Principle

heartbeat implements high availability of web services case 2

Production scenario applications related to heartbeat calling resources

heartbeat high availability case expansion

Differences in application scenarios between heartbeat and keepalived

Maintenance points in heartbeat service production environment 1

Maintenance points of heartbeat service in production environment 2

heartbeat service production environment maintenance FAQ

Introduction to the working principle of drbd

Working principle diagram of drbd

drbd service introduction

drbd replication protocol and application mode

Introduction to enterprise application scenarios of drbd

Introduction to common operation and maintenance synchronization tools

drbd deployment and ip configuration planning

drbd deployment and ip configuration planning

Installation and configuration preparation of drbd software

Creating synchronized partitions using drbd

drbd environment partition description and partition commands

drbd related configuration list description

Actual installation of drbd software

Configure drbd to load into the kernel module

Drbd configuration file parameter explanation and actual configuration

drbd service initialization data fault machine troubleshooting process

Start drbd and configure master-slave synchronization data

Common faults and troubleshooting methods of drbd service

Mount test database synchronization and view standby node data

Important thoughts before class

MySQL high availability requirements and architecture explained

The location and architecture of MySQL high availability in large-scale cluster architecture

MySQL high availability practical simulation environment description

MySQL high availability production scenario configuration and network address planning

MySQL high availability implementation formal environment preparation and split-brain attention

Quickly install heartbeat under dual-machine Centos6.4 and configure startup

Quickly install the drbd service preparation under dual-machine Centos6.4 01

Quick installation of DRBD service under dual-machine Centos6.4 02

Detailed explanation of drbd service status information details

Start the service to test the actual synchronization of DRBD

Debug drbd service configuration with heartbeat

Debugging drbd service configuration with heartbeat 2

MySQL service installation practical installation process explanation

One-click installation of Mysql multiple instances practical explanation and demonstration

Manually test MySQL high availability switch

Practical implementation of MySQL dual-master high availability automatic switching

Explanation of configuration considerations for MySQL dual-master high availability my.cnf

Important principles and troubleshooting ideas for MySQL high availability switching

MySQL master-slave synchronization one-click installation script actual combat

MySQL multi-master multi-slave high availability cluster automatic switching implementation

Explanation of MySQL high availability precautions and common faults

Introduction to more ideas and solutions for MySQL cluster and high availability

Basic ideas for troubleshooting slow website opening

Website opens slowly MySQL slow query optimization enterprise case

Website opening slow mysql problem multiple solutions enterprise case

Core experience cases that Linux operation and maintenance personnel must master

Various optimized production plans and details of MySQL database 01

Various optimized production plans and details of MySQL database 02

Various optimized production plans and details of MySQL database 03

Various optimized production plans and details of MySQL database 04

Summary of various optimization production solutions for MySQL database 05

Project development process and database update process

DBA participates in project database design and trains developers to efficiently design MYSQL library statements

Project cycle development ideas

Solution case for high cpu usage of linux process

Various ideas and techniques for database account permission control

Detailed explanation of database client security control strategy

Core management ideas of database operation and maintenance

An explanation of the basic points of MySQL index optimization 01

MySQL index optimization production case explanation 02

MySQL data loss lesson case in production environment

Various optimized production plans and details of MySQL database 01

Multiple optimization production plans and details of MySQL database 02

Various optimized production plans and details of MySQL database 03

Various optimized production plans and details of MySQL database 04

Summary of various optimization production solutions for MySQL database 05

Introduction and practical explanation of the solution to realize reading and writing separation in PHP program

Amoeba software implements database reading and writing separation in practice

Amoeba software implements database reading and writing separation practice 2

Mysql client phpmyadmin installation and deployment practice

Mysql-proxy software implements database reading and writing separation in practice