MySQL DBA and Linux Enterprise Cluster combat engineer

MySQL DBA and Linux Enterprise Cluster combat engineer

2015, to a learning journey anytime, anywhere

Start my career MySQL learning Tour

Can't miss the journey I've won

Willful is to ask, ask

Who's your group chat buddy

I'm the master of Learning

Teacher Online answer and ask

Career Introduction--Database basics and installing MySQL

MySQL Course Introduction

Instructor Interview

Gain insight into what a database is

MySQL stands out from thousands of databases

Choose which version of MySQL to learn

Build an experimental environment for learning MySQL

Familiarize yourself with the MySQL environment in advance

Install MySQL under the official Yum source under Linux

Linux under the official source package installation of MySQL and source code installation parameters of the instructions

Linux under the official source package installation of MySQL and source code installation parameters of the instructions

Build a custom MySQL RPM package based on the official source RPM package under Linux

Intermediate Pilot--mysql Index

The concept of an index

Creation and deletion of indexes

Index Performance Test

Advanced Guide--mysql Replication

About MySQL Replication

The principle of MySQL replication

1-what kind of company need to use MySQL?

Gain insight into what a database is

MySQL stands out from thousands of databases

Self Test 2-build an experimental environment for learning MySQL

Choose which version of MySQL to learn

Build an experimental environment for learning MySQL

Familiarize yourself with the MySQL environment in advance

Install MySQL under the official Yum source under Linux

Linux under the official source package installation of MySQL and source code installation parameters of the instructions

Linux under the official source package installation of MySQL and source code installation parameters of the instructions

Build a custom MySQL RPM package based on the official source RPM package under Linux

Self-test 3-mysql how to ensure the consistency of the company's multi-user access and data

Understanding the architecture of MySQL

concurrency control for MySQL

Introduction to MySQL Lock

Self Test 4-How to choose the right data type storage to meet your company's different business needs

MySQL data type

How to store a type with decimals

MySQL date and Time type usage

MySQL String type

MySQL Other string types

How to choose the right data type to store different data

Self-Test 5-How to meet different business needs of the company

Operation of the database

Self Test 6-how to create a table for a company's business

What is a database three-paradigm

How to manage a MySQL table

How to add a constraint when creating a table

Uniqueness constraints and the use of default constraints

How to modify a data table

Self Test 7-How to manage company business data

MySQL Data manipulation

Self Test 8-how to speed up the retrieval of your company's business data

The concept of an index

Creation and deletion of indexes

Index Performance Test

Self Test 9-How to quickly locate the company business data you want to query

Multi-condition query of MySQL single-table query

A group query of MySQL single-table query

Querying using Aggregate functions

Self-Test 10-mysql multi-table query to implement different business queries.

MySQL Multi-table query

MySQL multi-table Query sub-query

Self Test 11-How to use views to protect data security and reduce the complexity of SQL statements

MySQL View introduction

Basic operation of MySQL view

Self Test 12-how to use triggers to reduce DBA workload

The role of MySQL triggers

Create a simple trigger

To create a multiline execution statement trigger

Creating a trigger with while and repeat statements

Application of 13-operator in MySQL

Use of the MySQL operator

14-Functions help you simplify complex SQL

Use of common MySQL functions

MySQL process functions and custom functions

15-teaches you how to use stored procedures

MySQL Stored procedures Overview

How to write the definition of stored procedures and variables

MySQL stored procedure Loop statement

16-Create a single user for each application in the company

MySQL's permissions mechanism

Create users and how to authorize them

MySQL Permissions and password management

17-Keep your database in your fingertips

MySQL error log and common query log

MySQL Slow query log

MySQL binary log

MySQL binary log Application demo case

18-Backup to ensure company data is foolproof

MySQL Data backup Recovery overview

Install and use the MySQL Backup tool for the Community edition

MySQL-based backup of LVM snapshots

Case demonstration based on LVM backup data

Introduction to Mylvmbackup Tools

Third-party backup tool xtrabackup for full backup and recovery

Third-party backup tool xtrabackup for incremental backup and recovery

Third-party backup tool Innobackupex backup case

Backup tool mysqlbackup in enterprise MySQL for full backup and recovery

Backup tool mysqlbackup in enterprise MySQL for incremental backup and recovery

Enterprise MySQL Backup tool mysqlbackup for single file backup and recovery

A case of making and recovering a single file backup

How to revert to the most effective data after data loss

Data recovery and repair technology of 19-mysql

MyISAM storage engine and repair of corrupted or missing. frm files

Repairing a data table with the MYISAMCHK command

Implementation of MySQL Data deletion recovery without backup

InnoDB Storage Engine Detailed

Repair of InnoDB tablespace file corruption

Data Recovery case

20-mysql Replication realization of database fault automatic failover

About MySQL Replication

The principle of MySQL replication

MySQL Replication Solution Introduction

The construction of MSS

MySQL Replication based on Gtids

Why use Gtids-based MySQL Replication

How to improve replication performance

Replication capacity and Error logs

Replication Monitoring and automatic failover

Replication for automatic failover

Replication introduction and configuration of the dual master

21-How to get more and more data traffic is no longer a burden

MySQL Read and write Separation technology overview

Amoeba for read-write separation

Authorizing amoeba to access MySQL

MySQL read-Write Separation Technology summary

22-High availability to achieve the normal and stable operation of the company's services

MySQL High Availability overview

MySQL High Availability overview

How to implement MySQL high availability technology

Installation of pacemaker and Corosync

Configuration of Pacemaker and Corosync

MySQL High-availability recovery Demo

MySQL High-availability failure Demo

Implementation of dual-machine ha based on keepalived

Configuring Keepalived-based, dual-machine ha

A case of double-machine ha fault detection based on keepalived

23-How to improve the fault tolerance and high performance of the company database

MySQL Cluster overview

Automatic deployment of MySQL cluster

Configuration of MySQL Cluster

How to manage nodes for a MySQL cluster

MySQL Cluster third-party remedy method

24-sandbox for fast deployment of MySQL

MySQL Shahe technology Introduction

Quickly deploy a single MySQL instance using MySQL Shahe

Rapid deployment of replication environments using MySQL Shahe

25-How to optimize your company's MySQL database

Overview of ways to improve MySQL performance

Optimization of hardware

The impact of network configuration and operating system on MySQL performance

How to properly deploy MySQL and the use of MySQL performance analysis tools

MySQL configuration file optimization

How to evaluate MySQL's use of memory

Configuration of the InnoDB

Configuration of the InnoDB

MySQL SQL Optimization Overview

How to confirm a low-efficiency query

Use of MySQL SQL Basic Analysis command

Example of index optimization

Single-column index optimization

Fair use of Union INDEX

Use of multi-column indexes

Optimizing SQL statements with query hints

Application of 26-mysql partition

What is a table partition

Different types of partitions and cases

Sub-partitioning applications

Management and maintenance of partitions

The role of 27-mysql in the design of website architecture

The core of MySQL architecture design

Design of database architecture for small web site

Design of database architecture for medium Web site

Medium Web Site Database schema considerations

Design of database architecture for large web sites

Design of database architecture for super-large web site

28-mysql+key Value Database schema design

Mysql+key Value Key Database

Introduction and application of memcached and Redis

Implementation of memcached based on the official MySQL plugin

memcached Syntax Explanation

Adding a table to the memcached cache case

Construction and use of 29-percona

Construction and use of Percona

30-mysql Enterprise Monitor

MySQL Enterprise Monitor Introduction

MySQL Enterprise Monitor Installation configuration

Use of MySQL Enterprise Monitor

Link: Http://pan.baidu.com/s/1gd8bTAF Password: twxr

MySQL DBA and Linux Enterprise Cluster combat engineer