How to become a MySQL DBA

The success of the Internet's rapid development has benefited from the support of MySQL database. MySQL itself is developing faster, with significant performance improvements, and allows traditional businesses to use MySQL to provide services. It seems that the MySQL DBA's Gap is very large. So welcome to the MySQL DBA team.

A classmate referred to MySQL DBA or DBA to the difficulty of the introduction of a piece. I've been in MySQL DBA for almost 10几 years, and here I'm going to tell you how to become a MySQL DBA, take the Bay Road less quickly and become a MySQL DBA.

First of all, MySQL is mostly run on the Linux environment, so we need to learn Linux knowledge, the most basic need to understand:

• Linux installation and directory structure significance

• Common Linux commands, about 20 +

• Network Basics to learn more about gateways and routing-related concepts, DHCP

• Hold a certain Linux network service, if lamp structure, DNS, FTP, etc.

In fact, with the above conditions, you can start the MySQL DBA learning path, other knowledge, can be in the study in the supplement. MySQL DBA is special, not like other databases, need to be divided into development DBA, OPS DBA, basically MySQL DBA to get all the work down, because MySQL is too simple, very good to fix. So let's talk about the MySQL DBA's Learning Path:

• Understand the version meaning of MySQL

• Learn how MySQL is installed, and fundamentally understand how MySQL starts

• Learn SQL language, put the knowledge of high school mathematics into a good study, and then look at the SQL language

• Learn some of the specifications of SQL in MySQL use (these are better to have some experience to consult, or to see the General Assembly to share the learning of thinking)

• Learn the advanced features of MySQL: Triggers, events, stored procedure programming, partitioning, etc.

• Learn about MySQL replication, understanding the principles and implementation of replication and what is lacking in related high-availability mates

• Learning the realization of PXC structure, understanding the pit in operation and maintenance

• Learn about MySQL system architecture, how to do MySQL optimization, summarize configuration optimization

• Learn MySQL backup recovery, this piece may take a little more time to learn the system well

• Master several methods of pressure testing, convenient optimization can do a verification

• In-depth understanding of INNODB architecture, a comprehensive understanding of transaction and lock implementation, can parse out an update tb1 set col1=col1+1 where pk=10; What did this statement do in InnoDB?

It can be said that the above things are not difficult, basically as long as serious efforts, you can enter the MySQL DBA's door. Of course, if you want to get into a more advanced DBA work environment, you still need a bit more advanced knowledge:

• Understand the characteristics of MySQL, easy to choose in the actual environment

• Understanding of operating system IO scheduling, memory allocation, CPU usage, etc.

• Understand the advantages and disadvantages of replication and how to improve it

• Understanding system monitoring and system bottleneck point analysis

• Have a certain problem to troubleshoot ideas

• Comprehensive understanding of high-availability implementations and customizations for highly available architectures

• Have a certain platform management awareness and ability to realize

• Understanding the role of splitting and how to implement it

Long March drive at the foot, on the whole, on the road to technology, we must learn to keep learning, can continue to update, dare to pay more attention to the current resources, using existing resources to embark on a more state:

• Understand the features of your existing hardware

• Understand the implementation and difficulties of the business

• Learn about the use of common NoSQL

• Focus on new technologies

• Go to MySQL DBA architect level can line capacity planning

If you want the system to improve MySQL DBA technology, if you are a working person, you can use Saturday time to participate in my "MySQL DBA weekend increase overtime", if you do not have a job now, you can consider a 3-month blog to participate in my organization "MySQL DBA 0 Basic Job" Take the MySQL DBA position together. Please contact me: qq/weixin:82565387. 2016 together to take off.

In the development of technology, there is a more important path: to participate in the same industry technology exchanges, pay attention to the technical realization of the industry. Recommendation: MySQL China user group, Fireflyclub also welcome you to join.

Original Published: Http://wubx.net

This article is from the "Wu Bingxi-mysql-dba-life" blog, be sure to keep this source http://3wnet.blog.51cto.com/10980086/1738173

How to become a MySQL DBA