MySQL database operations and maintenance course

MySQL database operations and maintenance course

http://www.dataguru.cn/article-4834-1.html?union_site=comm100

Course Outline

The first lesson: Machine Selection, System planning Lesson two: Installing a deployment Lesson Three: Stress testing Lesson Four: Performance optimization Lesson Five: Character Sets and permissions security Lesson Six: Log System Seventh Lesson: Backup and Recovery 1 Eighth Lesson: Backup and Recovery 2 Lesson Nineth: Common Tools Tenth lesson: MySQL Cluster 11th Lesson: Distributed Clusters Lesson 12th: Clustering High-availability (HA) and disaster-tolerant walkthroughs 13th Lesson: Automating operation and Maintenance Lesson 14th: Monitoring and auditing systems Lesson 15th: Growth Planning and summary

MySQL database as the world's most popular open source database, simple, easy to use, open source and other characteristics, received the admiration of the internet industry. With the go-to-IoE movement in full swing, MySQL database has been deep into the traditional industry, greatly changing the industry pattern. At the same time, MySQL database size multiplied, how to quickly locate the problem, solve the problem? How to scale and automate operation and maintenance? How to optimize and improve the performance of MySQL database? How do I architect a MySQL cluster and a distributed MySQL cluster across IDC? How to implement HA for MySQL database? will be shared with you in this course.

Course Outline:

The 1th lesson machine selection, System planning

Machine Selection

Business assessment-translates into machine resource requirements based on business assessment.

SSD vs hdd--familiar with SSD and HDD architecture design, understand the development trend of SSD.

Cost Assessment – Select the right model through cost assessment.

System planning

File system planning-according to the characteristics of MySQL, planning file system, IO scheduling.

Database configuration-Configures the MySQL database based on Io write characteristics.

2nd Lesson Installation Deployment

Source code compilation-source code compiled installation operation processing method.

Feature customization-custom MySQL server current limit, SQL current limit, parallel copy, ThreadPool function.

Scale-up deployment-understand the unified management approach to packaging, configuration templates, data catalogs, and more.

Version upgrade-How is a cross-version upgrade safe and reliable?

Resource pool Management-resource management, instance allocation, resource utilization, and so on.

3rd Lesson Stress Test

Tpc-c Model--Understand TPC-C model design.

Testing tools-familiar with common database testing tools.

Benchmark test--read-only test, TPCC test, read/write ratio test method are introduced.

Custom testing--Introduce custom SQL models, custom test tools, and traffic-accelerated playback methods.

Evaluation criteria--the basic parameter criteria for evaluating test results are presented.

4th Lesson Performance Optimization

Parameter optimization--details the performance parameters and optimization methods that are relevant to the MySQL database.

Performance Optimization – Details system-level optimization and MySQL feature optimization. (NUMA, malloc, etc.)

5th lesson Character Set and permissions security

Character

Frequently asked questions-describes the common problems with character set garbled and how to solve them.

Considerations-Describes the considerations for character set settings and how to circumvent them.

Privilege Security

Rights Management--describes how to securely manage users and data for a database.

Mandatory access control--introduce the mandatory access control and enhance the security management of rights.

Network security--through network isolation, VLAN partitioning and other ways to enhance the security of the database.

6th Lesson Log System

This article introduces MySQL various log analysis processing methods, common log processing tools, diagnosing MySQL database health status, running status, performance problems and so on. Mainly include:

Error log--quickly locates the health of a database by analyzing common error messages.

binlog--describes how to optimize the Mysqlbinlog tool to locate operational records, as well as advanced usage of Binlog.

Slow log--describes the SQL exception issue for locating MySQL database via slow log.

General log--describes the performance status of the MySQL database, which is located through General log.

Intelligent diagnosis--to introduce the collection of log information, intelligent diagnosis and so on.

7th lesson Backup and Recovery 1

Logical backup-Describes logical backup methods without local storage, as well as parallel logical backups, logical split tables.

Physical backup-describes Xtrabackup physical backup method, parallel physical backup, mirrored backup.

Backup strategy-Describes how to develop a backup strategy, scale data backup.

8th Lesson Backup and Recovery 2

Historical data migration--An introduction to how historical data is migrated, and how mysqlfilter is used from development tools.

Data Recovery--describes the various scenarios of data recovery, combat drills.

9th Lesson Common Tools

How to use "Swiss Army Knife" to solve the battle quickly and efficiently? Common tools include: Mysqladmin, Pt-toolkit, Dstat/mpstat/iostat/vmstat, perf top, ORZDBA, etc., by introducing these tools, customizing tools or scripts to quickly locate problems and solve problems.

10th lesson MySQL Cluster

MySQL Cluster architecture--A brief introduction to the common MySQL cluster architecture approach.

sharding--a simple introduction to the common sub-database table method.

Cluster Management--describes how to run, deploy, and manage clusters.

11th Lesson Distributed clusters

Data Flow Tool--Describes the data flow product capabilities.

Distributed cluster architecture--A simple introduction to MySQL database distributed cluster architecture design method.

Distributed cluster Management--Introduction of distributed cluster management, operation and maintenance processing and other content.

Cloud services--a cloud service that describes how to implement a MySQL database.

Lesson 12th Cluster High Availability (HA) and disaster recovery drills

HA Tools-describes the tools currently used, as well as custom tool design and functionality.

MySQL cluster ha--simply describes the HA for MySQL DB cluster.

Distributed MySQL cluster ha--A simple introduction to the ha of a distributed MySQL DB cluster.

Disaster tolerance Walkthrough--Introduction to MySQL database instance disaster tolerance, computer room disaster tolerance, usually more sweat, less bloodshed in wartime.

13th lesson Automation operation and Maintenance

Resource Allocation--describes the process of automating resource request processing.

Instance migration--describes how to implement automated instance migration.

Cluster expansion--Describes how to automate instance scaling.

14th Course monitoring and auditing system

Monitoring System

Monitoring alarm--to introduce the various anomalies of monitoring MySQL database, alarm.

Performance monitoring--introduces the performance data collected from MySQL database for performance tracking.

Water level assessment-water level assessment based on performance data and resource conditions.

Audit system

Audit Method--introduces the auditing methods commonly used in MySQL database.

Behavioral audits-Describes how to audit operational records and operational behavior.

User audits-describes how to audit user behavior.

15th Lesson Growth Planning and summary

Career planning – Introducing DBA trends and career planning.

Summary-Summarize what you have learned and summarize it according to the feedback question.

Time of instruction:
The course duration is 17 weeks, January 19, 2015.

Subject:

Want to know the DBA's real life

Want to know how to drive a BMW to be a DBA
Want to learn about DBA hobbies, interests
Want to know how DBA architecture is designed
Want to know how DBAs scale operations
Want to know how DBAs can quickly locate problems
Think......
You can join them if you want.

Course Prerequisites:
Learn about Linux systems and apply basic commands skillfully.
Be familiar with at least one scripting language.
Have a certain ability to read English.

Learn to harvest expectations:
Master MySQL database basic operation and maintenance, design architecture, problem positioning, intelligent diagnosis and other basic skills, competent for the work of the senior MySQL DBA.

Teaching Instructor:

Wang, P.C.: a series of databases related to MySQL operations, MySQL HA, business support, automated operation and maintenance platform development. Focus on MySQL source research, performance testing, system architecture design and so on. Has a strong interest in Cgroup virtualization and Linux kernel. Blog: Http://hengwang.blog.chinaunix.netgithub:https://github.com/hengwang/e-mail:[email protected] Weibo: Wang, P.C.-henry

Innovative Course fee form:"reverse charge" about equal to free study, only charge 100 yuan fixed fee + 300 yuan temporary deposit tuition fee, learning a complete reward for the full return to the students!

This course was intended to be completely free, a great God once said, "success is the right direction plus moderate pressure." In view of the lecturers themselves to pay a great deal of labor, in order to prevent some friends in the study on the halfway, wasting the lecturer's pay, for this we plan to imitate some fitness classes, using the "Reverse charge" method.
at the time of registration, each applicant will be charged $400, of which $100 is a fixed fee. , the other 300 is the temporary deposit of tuition fees, that is, if the trainees can complete all the course requirements, including the completion of all the written and interactive work, the full refund of 300 yuan, excellent students can also receive gift awards. If the student fails to complete all of the study planning tasks, they will be charged. Hope this way can be translated into a strong learning desire and driving force!

Course Teaching Methods:
1, Learning mode: Teachers publish teaching materials, textbooks, slides and videos, students through the network download learning. At the same time through the Forum interactive teachers to guide students and exchange between students.
2, Learning homework: The teacher weekly layout of written and interactive work, students need to finish the work on time according to quality.
3, teacher Counseling: According to the work of the problems found in the correction, targeted to give guidance to help you master knowledge.
4, Completion test: Through the test, complete the study.

If you have any questions about this course, please click on the FAQand your question will be answered basically.

National Unified Consulting Hotline 4008-010-006

The course is now accepted for enrolment and registration
Online Registration click: MySQL database operations

Inquiry email:[email protected],[email protected]
Course Introductory Discussion Group: 200584928 (There is a video of training in the group for everyone to watch for free)

Consulting qq:2222010006 (working hours online)

Payment Method:

Courses take the form of online payment, students can recharge their wallets to pay the course tuition directly.

Detailed Description: http://f.dataguru.cn/thread-184839-1-1.html

Payment Process: Quick registration-fill in personal information-confirm the information is correct-recharge wallet-pay tuition-Join the course and QQ group-start the challenge

latest technology hotspots, The latest industry news, the latest training courses information, in the smelting into gold official, low-cost transmission of high-end knowledge! Technical Achievement Dream! Welcome attention!
Open, use sweep sweep function, immediate attention to the into Gold official account, not to be missed wonderful, look forward to your experience !!

MySQL database operations and maintenance course