"Mysql Learning Roadmap"

1th Week 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 Week 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 Week 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 Week 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 week 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 Sunday 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 Week 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 Week 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 Week 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 week 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 Week distributed cluster
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.

12th Week cluster high Availability (HA) and disaster recovery Walkthroughs
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 Week automatic 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 Week 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 Week 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 15 weeks, June 18, 2014.

Course object:
want to know the DBA's real life
want to know how to open a BMW as a DBA
to learn about DBA interests
want to know how DBAs architect design
Want to know how DBAs scale operations
want to know how DBAs can quickly locate problems
think ...
If you want, you can join