Quick tutorial on Mysql DBA in 20 days

Basic knowledge
1. mysql compilation and Installation
2. How to install and configure the mysql 3rd storage engine
3. Features of mainstream mysql storage engines (MyISAM/innodb/MEMORY)
4. String encoding knowledge
5. MySQL user account management
6. Data Backup/Data Import/Export
7. Basic data types supported by mysql
8. create, modify, and delete databases, tables, fields, and indexes
9. basic SQL Syntax: select/insert/update/delete. you can master the most basic syntax. What is inner join, for more information about left join, mysql is applicable to high-concurrency access and simple business logic. join, subquery, view, and trigger are not required.
10. SQL Aggregate Query: group by/having
11. How to Use explain to analyze and optimize queries
12. Common SQL optimization skills
A). select xx from yyy limited ...,
B). order by random
C). select count (*) from
13. There are about 20 show xxx commands, each of which is tried once.
14. show VARIABLES; there are about 240 items, which can be read one by one and can be printed out and pasted on the wall.
Advanced Operations
1. Mysql master-slave synchronization Configuration
2. Mysql dual master Configuration
3. Configure high-availability databases for Mysql dual master + cluster database + keepalived
Client
As a DBA, do not use various GUI tools. mysql comes with the command line client, which is your best weapon.
Optional
1. mysql partition configuration, because there are too many restrictions, the actual table sharding is performed by the program.
2. High-Performance mysql
A). drizzle
B). MariaDB
C ). handlersocket is hard to use because performance has never been a problem. Any project that uses various "odd tricks" must be a pitfall, the products used by the masses are honestly implemented using the simplest and simplest technology.

OK. After 20 days of study, you will be able to work as a mainstream Internet company Mysql DBA.

I have recruited a lot of DBAs, And I am familiar with mysql DBAs. Other DBAs are similar. You will learn how to perform these operations once, basically without IQ. The so-called massive computing of hundreds of millions of users is just an experience, and you will have it at the scene. DBA is only a "Watchdog" role: if something happens, you can call someone to find someone. In an accident, someone can be fined. If nothing happens, You can cool down.

The Internet makes the cost of acquiring knowledge lower and lower, and the database is becoming more and more like a common software. Have you ever seen a browser and office require special personnel to operate it?

Therefore, DBA is not a profession that can carry dreams. If young people want to develop in the technical field and want to "change the world", write code honestly as a programmer.