MySQL DBA in my heart

as a DBA, the core goal is the ultimate goal: to ensure the stability, security, integrity and high performance of the database management system.

MySQL DBA There are two kinds: one is to develop the DBA, and the other is the Operation DBA, and the MySQL DBA is referred to as the operational DBA. In general, DBAs refer to Operations DBAs, who are responsible for the operation and maintenance of the database, including database installation, monitoring, backup, recovery, and other basic tasks, and senior or senior DBA responsibility is much larger than this, need to cover the product from requirements design, testing to delivery of the entire life cycle, In this process, not only is responsible for the database management system construction and operation, but also to participate in the early database design, medium-term database testing and later database capacity management and performance optimization.

For operations DBAs, the main responsibilities are as follows:

1 monitoring: Real-time monitoring of the status of database services, including database sessions, database logs, data file fragmentation, table space monitoring, user access monitoring, and so on, at any time to find the database service operation anomalies and resource consumption situation Output important daily database service run report to evaluate the overall health of database service, Discover database hidden trouble; monitoring is critical for DBAs, the third eye of the DBA, which facilitates monitoring to automate some of the usual failures, identify and address potential pitfalls, and monitor the skills necessary for operations. If you do not understand the monitoring, then you are not a competent operation and maintenance personnel;

2 ) Backup: Develop and implement a database backup plan that restores database information when a disaster occurs, maintains archiving on appropriate media, or backs up data. The backup policy of the database is changed according to the actual requirements, and the daily backup of the data is monitored.

3 security audits: Provide different access rights for different database management system users to protect the database from unauthorized access and destruction. For example, allowing a class of users to retrieve data only, while another class of users might have permission to update data and delete records.

4 Fault handling: Any exceptions to the database service are handled in a timely manner, avoiding the enlargement of the problem or even aborting the service as much as possible. Before this, DBAs need to deal with various types of service anomalies, such as computer room/network failure, program bugs and other issues to develop a processing plan, the problem can be automated or manual execution of the plan to achieve the purpose of stop loss.

5 Capacity management: including resource evaluation, capacity expansion, engine room migration, traffic scheduling and other planning and implementation after the database scale is expanded.

6 Database Performance Optimization: The most important aspect of a product's external service is the user experience, which is very important in the user experience and the availability and responsiveness of the product. And how to use the most reasonable resources to support products to provide a high-availability and high-speed user experience, which is the important responsibility of the DBA.

Personally, the basic skills that a good DBA needs include understanding data backup/recovery and disaster recovery, using the DBA's Common toolset, knowing how to quickly find answers, knowing how to monitor and optimize database performance, automating as much as possible, capacity monitoring and planning, indexing design, database design, Database security, continuous learning and research of new versions, individual or systematic functional scripts can be written separately; personality decides fate, DBA is so, personality decides height, some DBAs do for many years, still is doing the bottom of things, in the final analysis may be related to their own character, do not think enterprising, work not active , say how much to do, the concept of time is not strong, such personality in the personal career will not have outstanding achievements. Met some DBAs have published books, theory and other skills must be no problem, but things rough, consider the problem is not comprehensive, from time to time a little accident, sometimes do things feel passable on the line, the interview when the impression is very good, but work up can see the problem, every time in a company is not long. A good DBA, should have the hard qualities include work carefully, diligent thinking, good communication skills, team spirit, self-driving ability or the initiative of the work, tenacity and composure of mind, curiosity and self-confidence, etc. basic skills are the foundation, DBA Essential, just the foundation, If you talk about good words, then good character and other qualities determine how far you can go in your career.

This article is from "Wang Wei" blog, please be sure to keep this source http://wangwei007.blog.51cto.com/68019/1718311

MySQL DBA in my heart