Lao Li share: DBA

Poptest is the only training institute for developing Test and development engineers in China, aiming at the ability of the trainees to be competent in automated testing, performance testing and testing tools development. If you are interested in the course, please consult qq:908821478, call 010-84505200.

When doing performance testing and tuning, you need to do the DBA work, what exactly does a DBA do, in fact, there are two types of DBAs: one is to develop a DBA, and the other is an OPS DBA, and here's what DBAs refer to as Operations DBAs. 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 service operation, including database sessions, database logs, data file fragmentation, table space monitoring, user access monitoring, etc., 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 database backup plan, recover database information when disaster occurs, maintain archive on appropriate media or backup 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 Audit: For different database management system users set different access rights 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: to deal with any anomalies in the database service in a timely manner, avoid the enlargement of the problem or even abort the service. 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 concrete implementation.

6) Database performance optimization: The most important point of the product service is the user experience, which is very important in the user experience is the product availability and response speed. 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 the new version, you can write separate or systematic functional scripts;

Lao Li share: DBA