As a MySQL DBA, you must have the following qualities:
First, physical fitness
The DBA must receive and process various alarms, whether at noon or at three o'clock in the morning, into deep sleep. Received the alarm need to immediately enter the emergency state, find the computer, connected network, quickly locate the cause of the failure, and solve it. Poor sleep students are not suitable for a DBA, because it is difficult to sleep after midnight treatment, long-term will seriously affect the quality of life.
In addition, in the repair of large-scale failure, it may take a long time, no good body difficult to adhere to.
Second, psychological quality
1 calm
Anything that involves a database does not matter, the DBA must have the "stroke of the pro without surprise, without reason and not angry" psychological quality, in the event of an emergency, not panic, orderly processing. Realize that, as things have happened, the DBA has to do what he can to recover from his greatest ability.
2 careful
Many of the MySQL DBA's operations are high-risk operations such as deleting a waste library table and switching the main library. A slight mistake can lead to a first-level failure. So you can't let go of any detail or minor problem.
3 rigorous
DBAs must have strong planning and rationality, must understand the priorities of a period of time and make plans, in doing any online operation must be strictly in accordance with the procedures, complete each step need to check or even cross-check, do not report any luck.
4 Open Learning
The MySQL version is constantly upgraded, with various branches and plugins emerging, and NoSQL databases surging. Ask us to have an open mind to learn and draw lessons from. Be diligent in learning, good at learning. The most important thing is not to be excluded from other database technologies.
Third, professional quality
1 must understand the computer architecture
2 must understand operating system and Linux kernel
3 must understand hardware especially storage
4 the shell and more than one of the other scripting languages must be used: python,perl,php
5 must understand c,c++ language, otherwise unable to understand the source code
6 must understand relational database theory
7 must be proficient in Linux system management
8 must be proficient in 1 to 2 kinds of database query language such as Tsql,plsql etc.
9 must understand the basic concepts and principles of NoSQL and learn about 1 to two nosql such as Redis,mongodb,tt,cassandra
The overall situation is as follows:
Recommended Bibliography:
Computer Architecture : In-depth understanding of the computer system (original book 2nd edition) data structure, algorithm: big Talk data structure
Introduction to Algorithms (Original book 2nd edition)
relational database theory:
Principles of database System tutorial
Getting Started with Database Design Solutions Classic
SQL Structured Query Language :
A definitive guide to Transact-SQL
SQL Server 2000 stored procedures with XML programming ...
SQL FAQ (2nd edition)
SQL Programming Style
Operating system: Modern operating System (original book 3rd edition)
Hardware: Big Talk Storage 2: Analysis of storage system architecture and underlying principle limits
Linux System Management:
Brother Bird's Linux private cuisine: Basic Study (3rd edition)
Brother Bird's Linux private cuisine: Server Erection (2nd edition)
Linux System Management Technical Manual (2nd edition)
Linux kernel Analysis: In-depth understanding of the Linux Kernel (3rd edition)
Shell:shell Scripting Learning Guide
Perl:perl Language Introduction (fifth edition)
php:php and MySQL Web development (Original book 4th edition)
Python:python Core Programming (Chinese second edition)
Oracle:
Build Oracle High-availability Environment: Enterprise-Class high-availability database architecture
Oracle 9i & 10g Programming Art: In-depth database ...
Mysql:
mysql– database development, optimization and management maintenance in layman's
MySQL performance tuning and architecture design
High-performance MySQL (second edition)
High availability MySQL: Building a robust data center
MSSQL:
SQL Server 2000 Advanced DBA Guide
SQL Server 2005 Implementation and maintenance
In layman's –sqlserver 2005 development, tube ...
SQL Server 2005 Performance Tuning
C, C + +:
Linux C Programming One-stop learning
C + + Primer Chinese Version (4th edition) (Special edition)
SOURCE Analysis:
MySQL Technology insider: InnoDB Storage Engine
MySQL Core Insider
Nosql:
MongoDB Authoritative Guide
Entrepreneurship and others:
Hackers and painters: the father of Silicon Valley's founding Paul Graham anthology
The peak of the tide
Reference: http://blog.csdn.net/lin_credible/article/details/8362605