I am a living example, the University of Instrumentation major, 12 after graduating the first job is a circuit board test. Because the project is exposed to the database of things, purely when the advanced point of the Excel table with.
At that time a bit of interest, did not attend training, 0 basic self-learning MySQL and Linux, is currently a domestic public cloud MySQL &&mongodb dba.
For non-computer-born me, the university will only be Hello Word and the marquee, during the process is indeed very tortuous, sharing under my self-study process:
1, I installed MySQL on Windows and Linux, self-study Linux basic knowledge, learning MySQL's most basic knowledge, namely
How to write sql, stored procedures, table designAnd so on, from 0 to familiar about spent 3 months, recommended
"MySQL Getting Started is simple"。
2, systematic and more in-depth study
mysql SQL optimization, backup and restore, parameter optimization, architecture optimization, hardware-level optimization, high-availability solutions, replication technologyWait, this period of time you may not be able to actually contact these, as I did, certainly no company recruit a small white.
I choose to read my own book, recommend
"High performance MySQL", all the chapters inside need to look at the current level must not understand, but need to know what is going on, for the follow-up MySQL Junior DBA work to play a cushion, the process will probably take 3 months.
3, the paper on the final light, complete the above two steps, I began to prepare
find a job related to MySQLInstead of working with the Excel table every day for select * from TABLE_SB.
Of course, I am such a wretched person will not be naked, the painting of the circuit board as well, in the spare time to start to cast the primary MySQL DBA work, and uninterrupted learning, online various search for MySQL interview related topics (in fact, I did not have any actual combat experience), received some interviews, With the previously self-taught MySQL knowledge, began to play a random blow, first mixed in and say.
You don't do MySQL-related work, and you never know how naïve your knowledge of the DB is.
Friendship Tip Point, the general company does not have a full-time DBA, so the interview must be confident, in fact, you learn so much, although no actual combat experience, theoretical knowledge is a big probability than the person who interviewed you, so all kinds of blowing, I will really enter the primary DBA circle (due to Linux is still in the CD LS level, so there was no operation at all, this side of the working side of the process of looking for work lasted 2 months.
4, the real access to the Internet, contact with the production environment, this is the time I progress the most.
The first step is to
to really apply what you've learned before., and the process of application, and then look back to the previous books, this time need to really understand, rather than specious, smattering.
At this time again recommended
The third edition of High-performance MySQL, read it all over again, you need to read it all, plus
"MySQL Technology insider: InnoDB Storage Engine"Wait a minute.
In short, this time will require
start focusing on MySQL in some detail, for example.
DB fault handling, high availability, load balancingAnd so on the concrete realization.
Other than that
knowledge synchronization of Linux also needs to go deep into learning, at least write shell scripts, common Linux knowledge and so on, I spent more than 1 years;
5, the DBA's work is generally very patronagejob, after all, is not the big company, the technical ability is limited, the study also learned almost, cannot contact
massive data, high concurrencyAnd so on the occasion of more exercise, so I was ready to jump.
So came the public cloud, now daily operation of multiple DB instances, the average daily processing 5+ an emergency DB fault, almost MySQL will encounter problems, feel all met, can feel the technical strength and experience in the accumulation of every day, in progress.
But the feeling is still missing a lot,
The next step depends on your choice ., is to study the source code, the underlying principle of things more points, or database operation and application of a little more, such as the industry Kang, Ho Dengcheng and Ye Jinlong differences.
Because of my historical reasons, for C + + and so almost do not understand, and usually do not use, so look at the code and other things actually too tired, so I went to learn MongoDB, and then the company MongoDB operation of the live, is in the breadth of an expansion, in the event of the day MySQL is not
6, in short, for the DB small white, the most important point is that
the process of learning cannot be broken。
PS above method comparison wild path, suitable for no basic children's shoes, if it is a DBA, such as from Oracle to MySQL, then it is recommended to look directly at the official MySQL document, and the official document is a certain level of DB must see, when the problem must be checked the authoritative document. The article originates from the knowledge, only for the study Reference (reprint) https://www.zhihu.com/question/34840297/answer/67536521
0 How does the foundation learn the MySQL database?
