Worship! The internal data of MySQL notes written by Ali’s technical director is shared within a limited time

Time:2021-8-21

preface

The job hunting season is coming. There are thousands of skills, and hard strength is the key. It is said that the epidemic environment this year is bad, so we should make good preparations. MySQL is a necessary skill for advanced Java programmers. Many friends often lose their halbers and sink sand here during the interview. Proficient in MySQL knowledge and strong operability in practice, especially in the Internet industry, we should not only write code and realize functions, but also operate normally under high concurrency.

Therefore, Xiaobian will share this MySQL Notes document with you today. This document will explain to you from the three parts of foundation, performance optimization, architecture design and architecture design. At the same time, I hope it will have some effect on your big brothers and friends, and I hope you will like it! Finally, friends who need this pure hand to play MySQL notes need to pay attention to the “Java” and pay attention to the official account.

Let’s take a look at this MySQL Directory:

Because this note is made purely by hand, there is no cover to share with you. It’s a pity that such an excellent document has no cover;

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

primary coverage

This MySQL notes is mainly divided into three parts: foundation, performance optimization and architecture design; So next, Xiaobian will carefully expand each article to explain the knowledge points of this book in detail! Just pay attention to + point and then pay attention to the official account [Java didi] can get free.

1、 Basic chapter

As one of the most popular open source database software, MySQL database software is well known. However, in order to take care of readers who are not familiar with MySQL, we will make a brief introduction to MySQL in this chapter. The main contents include the composition of each functional module of MySQL, the cooperative working principle of each module, query processing flow, etc.

Chapter 1: basic introduction to MySQL

  1. Introduction to mysqlserver
  2. Simple comparison between MySQL and other databases
  3. Main applicable scenarios of mysq
  4. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Chapter 2: MySQL architecture composition

  1. MySQL physical file composition
  2. MySQL server system architecture
  3. Introduction to MySQL built-in tools
  4. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Chapter 3: introduction to MySQL storage engine

  1. MySQL storage engine overview
  2. Introduction to MyISAM storage engine
  3. Introduction to InnoDB storage engine
  4. Ndecluster storage engine introduction
  5. Introduction to other storage engines
  6. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Chapter 4: MySQL security management

  1. Database system security related factors
  2. Introduction to MySQL permission system
  3. MySQL access authorization policy
  4. Safety precautions
  5. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Chapter 5: MySQL backup and recovery

  1. Database backup usage scenario
  2. Logical backup and recovery test
  3. Physical backup and recovery
  4. Design idea of backup strategy
  5. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

2、 Performance optimization

Chapter 6: related factors affecting MySQL server performance

  1. Impact of business requirements on Performance
  2. Impact of system architecture and Implementation on Performance
  3. Effect of queryi statement on system performance
  4. Impact of schema design on system performance
  5. Impact of hardware environment on system performance
  6. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Chapter 7: MySQL database locking mechanism

  1. Introduction to MySQL locking mechanism
  2. Analysis of various locking mechanisms
  3. Make rational use of lock mechanism to optimize MySQL
  4. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Chapter 8: MySQL database query optimization

  1. Understand query optimizer of MySQL
  2. Basic ideas and principles of queryi Language Division optimization
  3. Make full use of explain and profiling
  4. Rational design and use of index
  5. Implementation principle and optimization idea of joir
  6. Order by: groupby and distihct optimization
  7. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Chapter 9: Performance Optimization of MySQL database schema design

  1. Efficient model design
  2. Appropriate data type
  3. Canonical object naming
  4. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Chapter 10: MySQL server performance optimization

  1. MySQL installation optimization
  2. MySQL log settings optimization
  3. Querycache optimization
  4. Other commonly used optimizations for MySQL server
  5. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Chapter 11: common storage engine optimization

  1. MyISAM storage engine optimization
  2. InnoDB storage engine optimization
  3. InnoDB cache related optimization
  4. Transaction optimization
  5. Data storage optimization
  6. InnoDB other optimizations
  7. InnoDB performance monitoring

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

3、 Architecture design

Chapter 12: basic principles of MySQL extensible design

  1. What is scalability
  2. Transaction correlation minimization principle
  3. Principle of consistency of teaching evidence
  4. High availability and data security principles
  5. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Chapter 13: MySQL replication for extensibility design

  1. Significance of replication to scalability design
  2. Implementation principle of replication mechanism
  3. Replication implementation level
  4. Common replication architectures
  5. Replication on build and Implementation
  6. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Chapter 14: data segmentation of scalable design

  1. What is data segmentation
  2. Vertical segmentation of data
  3. Horizontal segmentation of data
  4. Use of vertical and horizontal joint segmentation
  5. Data segmentation and integration scheme
  6. Possible problems in data segmentation and integration
  7. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Chapter 15: the use of cache and search in scalability design

  1. Extensible design extends beyond the database
  2. Leverage third-party cache solutions
  3. Self implementation of cache service
  4. Efficient full-text retrieval using search
  5. Using distributed parallel computing to realize high-performance operation of large amount of data
  6. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Chapter 16: mysqlcluster

  1. Introduction to mysqlcluster
  2. MySQL Cluster Environment Setup
  3. MySQL Cluster configuration details (config. INI)
  4. Basic management and maintenance of MySQL Cluster
  5. Basic optimization ideas
  6. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Chapter 17: ideas and schemes of high availability design

  1. Leverage replication for a highly available architecture
  2. Use mysqlcluster to achieve overall high availability
  3. Using dred to ensure high security and reliability of data
  4. Other highly available designs
  5. Advantages and disadvantages of various high availability schemes
  6. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Chapter 18: MySQL monitoring of high availability design

  1. Monitoring system design
  2. Performance status monitoring
  3. Summary

Worship! The internal data of MySQL notes written by Ali's technical director is shared within a limited time

Acquisition method

Just pay attention to + point praise and pay attention to the official account [Java didi] can get free ~ ~ this pure hand hits the MySQL note!!!

After reading three things ❤️

If you think this article is very helpful to you, I’d like to invite you to help me with three small things:

  1. Praise, forwarding, and your “praise and comments” are the driving force for my creation.
  2. Pay attention to the official account of “Java didi” and share original knowledge without any time.
  3. At the same time, we can look forward to the follow-up articles