basic Knowledge
1.mysql compilation installation
2.mysql 3rd party Storage Engine Installation configuration method
3.mysql main storage engine (myisam/innodb/memory) features
4. String encoding knowledge
5.MySQL user account Management
6. Data Backup/Data import Export
7.mysql supported basic data Types
8. library/table/field/index creation/modification/deletion
9. Basic SQL Syntax: select/ Insert/update/delete, master the most basic grammar can be, what inner join,left join understanding on the line MySQL's scenarios are mostly high concurrency access/business logic simple, join/subqueries/views/triggers are basically not
10.sql Clustered query: Group by/having
11. How to optimize queries with explain
12. Common SQL Optimization Techniques
a). Select xx from YYY limited ...,
B). Order B Y random
C). Select COUNT (*) from
13. A variety of show xxx instructions, about 20, each try to use a
14.show VARIABLES; there are about 240 items that can be printed out and pasted on the wall.
Advanced Operations
1.Mysql master-Slave synchronization configuration
2.Mysql Dual master configuration
3.Mysql dual master+ Concou +keepalived Configure high-availability database
client
as a DBA, be sure not to use a variety of GUI tools, MySQL with command line client is your best weapon
optional
1.mysql partition configuration, Because there are too many restrictions, the actual table is programmed to do
2. High performance MySQL
. Drizzle
B). MARIADB
C). Handlersocket, blowing, the actual work is also difficult to use, because performance has never been a problem, the use of a variety of "Kit Kat" project, is necessarily a sinkhole, the people are happy to hear the products are honest use of the most simple and naïve technology implementation
OK, after 20 days of learning, you can be qualified for the mainstream Internet company MySQL DBA work
I've recruited a lot of Dba,mysql. DBA's work knowledge is so much, other DBAs are similar, see the operation again you learn, basically do not have IQ. The so-called billions of users of massive computing, which is just an experience, you are in the scene you will have. The DBA is just a watchdog role: something can call someone, an accident someone can be fined, nothing on the side to cool off.
The internet makes the cost of acquiring knowledge more and more low, the database is more and more like a common software, you have seen the browser, Office needs special operation?
So, the DBA is not a can carry the dream occupation, young people want to have the development in the technical field, want to "change the world", honest write code when programmer go