1, I installed mysql on windows and linux, taught myself the basic knowledge of linux, and learned the most basic knowledge of mysql, that is, how to write sql, stored procedures, table design and so on. It took about 3 months from 0 to familiarity. Recommend mysql to be easy to use.

2. Learn mysql's sql optimization, backup recovery, parameter optimization, architecture optimization, hardware optimization, high availability scheme, replication technology, etc. Systematic and deep. You may not be able to really get in touch with these things during this time. Just like I did at the beginning, there is definitely no company to recruit a white trick.

I choose to read books by myself and recommend high-performance mysql. All the chapters in it need to be read. I still can't understand my current level, but I need to know what is going on, paving the way for the follow-up work of finding mysql junior dba. This process takes about 3 months.

3. After completing the above two steps, I began to prepare a job related to mysql, instead of doing a job like select * from table_sb with excel tables every day.

Of course, a poor man like me won't go to naked resignation, and the circuit board of this painting is the same. I started to be a junior mysql dba in my spare time and have been studying. I received some interviews on various topics related to mysql interviews on the Internet (in fact, I didn't have any actual combat experience at that time). With the mysql knowledge I had taught myself before, I began to brag wildly, so I mixed in first.

You will never know how naive your previous understanding of db is until you do the practical work related to mysql.

Friendly reminder: most companies don't have full-time dba, so you must be confident when interviewing. Linux fact, you have learned so much. Although you have no actual combat experience, your theoretical knowledge is probably better than your interviewer. So, I really entered the circle of junior dba (because I was still at the level of cd ls at this time and had never done operation and maintenance before), and the process of finding a job while working lasted for another two months.

4. After I really got into the Internet and contacted the production environment, this was the time when I made the greatest progress.

The first step is to really apply what you have learned before. In the process of application, you need to look back at the previous books. At this time, you need to really understand, not specious and half-baked.

At this time, we recommend the third edition of high-performance mysql, and read through the whole book. At this time, we need to know everything. There is also the inside story of mysql technology: innodb storage engine and so on.

In short, we need to pay attention to some details of mysql, such as db fault handling, high availability, load balancing and so on.

In addition, the knowledge synchronization of linux needs in-depth study, at least I can write shell scripts and common linux knowledge. I spent 1 years here;

5.dba's work is generally very leisurely. After all, it is not a big company and its technical ability is limited. I understand that I have not been exposed to massive data and high concurrency, and I am ready to jump again.

As a result, the public cloud appeared, and now it operates and maintains more than 10000 db instances every day, and handles 5+ emergency db failures on average every day. I feel almost all the problems that mysql will encounter, and I can feel that the technical strength and experience are also accumulating and improving every day.

But I still feel a lot less. Next, it depends on your choice, whether to study more source code and underlying principles, or to study more database operations and applications, such as the differences between Jiang Chengyao, He Dengcheng and Ye in the industry.

Because of my historical reasons, I hardly know c++, and I don't use it at ordinary times, so I'm actually too tired to read code and other things, so I went to learn mongodb again and took on the operation and maintenance of the company mongodb, which is a breadth expansion. What if mysql fails one day?

6. In short, for db Xiaobai, the most important thing is that the learning process cannot be interrupted.

The method above PS is wild and suitable for children's shoes with poor foundation. If you are a dbA, such as switching from oracle to mysql, then it is recommended to directly read the official mysql documentation, which is an authoritative document that must be read after the DB reaches a certain level, and must be checked if something goes wrong.