MySQL Training brief

MySQL Training brief
I. Introduction and objectives of the course
Through this training, you can systematically grasp the important knowledge of MySQL, through the experts and experience/case sharing, quickly improve the actual combat level. At the end of each topic, there will be a corresponding experiment to practice.
Second, lecturer: currently for a group of business operations and maintenance/DBA architect and responsible for several other company technical consultants, for dozens of companies have done database training;
Computer Department of Jilin University after graduating to join a foreign enterprise, an internet finance, etc., engaged in Oracle, MongoDB, MySQL, Hadoop, Redis and other consulting, support and training work, for a large number of financial, mobile, Internet, insurance and other customers to provide support and services, good at database management, Problem diagnosis and performance tuning, as well as Web diagnostics, big Data management, and more. Since its inception, the training and support of more than 30 customers, training more than 300 people.
2014, get Oracle OCM
2016, join the MongoDB Core community, actively follow up in the National Sharing Conference
In 2012, the book "Oracle Database Management First Edition" was published in the company's internal release.

1, service support multi-telecommunications industry, etc.
2, a bank ORACLE/MONOGODB database management training
3, a security MongoDB, Redis, MySQL database management training
4, an Entertainment/e-commerce MongoDB, MySQL, Redis[cluster], Greenplum database training
5, an Entertainment/e-commerce hadoop/hbase technical Support
6, a Telecommunications research institute Oracle, MONODB, MySQL database training
7, a fitness MongoDB, Redis database training
8, a mobile phone manufacturer MongoDB Technical support
9, a real estate MongoDB, Redis technical support
10, an Internet financial MongoDB, MySQL technical support
11, a software company MySQL, MongoDB, Redis training and technical support
12, ...
Iii. Lessons: 2 days, 6 hours per day
Iv. teaching methods and methods: a combination of lectures and case discussions
V. Description of the course:
1, MySQL optimization management diagnosis: The first day
Content one: MySQL overview
1. mysql architecture and high-availability architecture Introduction
Content two: MySQL basic requirements and maintenance tools
1. Database specification
2. Standard parameter file and its description
3, PT tools to tell and combine cases
Content Three: Database development

1. Index overview
   1. Precautions and Case description
   Content four: Data backup recovery + migration +binlog Resolution
   1. Logical Backup Recovery
   2. Physical Backup Recovery
   3. Restore the thread logical backup
   4. Parse Binlog for incremental recovery, or resolve to standard SQL statement for recovery

2, MySQL optimization management diagnosis: The next day
Content One: Overview of core parameters
1. The importance of core parameters to the database
2, according to test case analysis of the problem
Content two: Query optimization
1. Data table optimization
2. Index optimization
3. How to find Slow query
4, Query analysis optimization case
Content three: Peacetime maintenance use

1. Querying database size
2. Query for deadlock
3. Analyze DML operations during peak business hours with Binlog
4. How to clear Binlog
5. MySQL bulk kill locked Progress method
6. Cyclic deletion of large tables and aftercare [reducing business impact]
7. ......
   Content four: Patrol script

Content Five: Comprehensive case study
1, host disk I/O, CPU, memory, network and other resource usage ratio is high how to diagnose
2, Big table Delete index, business query primary key more than 10 seconds, we reflect on the optimization of the place
3. How to verify data consistency after backup recovery
4, in the case of disk I/O, high CPU, there is no slow query, how to diagnose the analysis
5, the sub-database of the table for the client and middleware how to choose
6. Data migration What do we need to prepare?
7, monitor the use of MySQL version, and what engine, how to partition important monitoring table
8, ...

3. Question: 1 hours per day
Through training, we interact with questions and how to avoid online problems.
4, follow-up content [this comparative hot spot]
According to the needs of the company, to carry out targeted training.
If the company needs to, can be targeted from the operation and maintenance personnel training to become a business operation and maintenance DBA,
Analyzing problems from the web of diagnosing problems [JVM and other measures] involves how the DB can analyze and diagnose with business development, to locate problems, to come up with constructive suggestions and even solutions.

Tailor-made training tailored to your company's needs and individual needs.

MySQL Training brief