First introduce to you the database engineer, database Engineer, is engaged in the management and maintenance of database management system (DBMS) related to the staff of the general, he is a branch of Operations engineer, mainly responsible for the business database from the design, Test to the full lifecycle management of the deployment delivery. The core goal of database engineers is to ensure the stability, security, integrity and high performance of the database management system.
here today to share a dry course, MySQL 0 basic Introductory video tutorial, hope to help everyone!
Course Catalog:
One, MySQL course introduction and MySQL Basic concepts (1)
Second, MySQL basic concept of storage engine (2)
Third, MySQL base installation using
Four, SQL statement of the DDL statement
Five, SQL statement DML statement and DCL
Six, SQL statement class practice precise authorization Priority
Vii. review MySQL Basics
Eight, crack mariadb 5.5 root password
Nine, MySQL backup of the classification and backup of two major elements
10, InnoDB Storage engine version level
11, binary log for real-time incremental backup (1)
12, binary log for real-time incremental backup (2)
13, LVM snapshot backup Database
14, Percona xtrabackup backup
XV, Percona xtrabackup installation and use of
16, lamp construction microblogging application
17, the principle of MySQL Replication
18, build mariadb master-Slave Architecture (M-S)
19, MySQL5.7 Basic Installation
20, MySQL5.7 master multi-Slave (m-s-s-s)
21, MYSQL5.7 multipole master-slave +multisource
22, Project MySQL5.7 achieve multipole master-slave +multisource (1 )
23, Project MySQL5.7 implementation multipole master-slave +multisource (2)
24, database middleware Db-proxy
25, Mysql-proxy installation configuration to achieve load balancing read and write separation
26, MySQL Ha High Availability
27, configuration and use
Video: Http://pan.baidu.com/s/1dFzl6rJ
Password: z7ft
MySQL 0 basic Getting Started video tutorial, dry Tutorial!