Redis

Redis Is a remote memory database , It's not only powerful , It also has replication features and unique data models for problem solving .Redis Provides 5 Different types of data structures , All kinds of problems can be mapped to these data structures naturally :Redis Our data structure is dedicated to helping users solve problems , Not like other databases , Require users to distort the problem to fit the database . besides , By copying 、 Persistence ( persistence ) And client segmentation ( client side sharding ) Other characteristics , Users can easily put Redis Expand to include hundreds of GB data 、 Systems processing millions of requests per second .

Mysql

MySQL Is an open source relational database management system （RDBMS）, Use the most commonly used database management language -- Structured query language （SQL） Database management . It's also open source , So anyone can be in General Public License Download and modify it according to the needs of personalization . And because of the speed 、 Reliability and adaptability . Most people think that when there is no need for transactional processing ,MySQL Best choice for managing content .

• Why? Mysql Follow Redis Can become the mainstream of database ？

Mysql It's a relational database and Redis yes Nosql database

A relational database is a database based on a relational table , Eventually, data will be persisted to disk , and nosql The database is based on a special structure , And store the data in the memory database . In terms of performance ,nosql Database is better than relational database , In terms of security, relational database is better than nosql database , So in In actual development, in a project nosql Will be used with relational databases , Achieve double guarantee of performance and safety .

These two brothers are now favored by more and more enterprises , And as a qualified Developer , It is very necessary for us to learn the relevant knowledge in depth , Add to your career as a programmer . Now I'd like to introduce 3 Relevant documents , If my brother needs it , It can be taken away free of charge ！

Redis Practical documents

The first part 　 introduction

• The first 1 Chapter First time to know Redis
• The first 2 Chapter Use Redis structure Web application

The second part 　 The core concept

• The first 3 Chapter Redis command
• The first 4 Chapter Data security and performance assurance
• The first 5 Chapter Use Redis Build support
• The first 6 Chapter Use Redis Build application components
• The first 7 Chapter Search based applications
• The first 8 Chapter Build a simple social network

The third part 　 Advanced content

• The first 9 Chapter Reduce memory usage
• The first 10 Chapter Expand Redis
• The first 11 Chapter Redis Of Lua scripting

A summary of the contents

MySQL The way to the top

The chapters of this document are really interesting , Xiaobian is Xingyao level , What's your level ？

The first 1 Some stubborn bronze piece

• The first 1 Chapter MySQL Introduction and mainstream branch version
• The first 2 Chapter MySQL Database installation 、 Startup and shutdown
• The first 3 Chapter MySQL Architecture and storage engine
• The first 4 Chapter Database files
• The first 5 Chapter surface
• The first 6 Chapter Indexes
• The first 7 Chapter Business
• The first 8 Chapter lock

The first 2 Part of order silver

• The first 9 Chapter Backup recovery

The first 3 Part of the golden glory

• The first 10 Chapter Master slave replication overview
• The first 11 Chapter Copy principle and actual combat drill

The first 4 Some noble platinum piece

• The first 12 Chapter MHA
• The first 13 Chapter Keepalived+ Dual main architecture
• The first 14 Chapter PXC
• The first 15 Chapter ProxySQL

The first 5 Part of the eternal diamond

• The first 16 Chapter MySQL 5.7 New characteristics
• The first 17 Chapter MySQL Comprehensive optimization

The first 6 Part of the supreme star shining

• The first 18 Chapter Lepus And MySQL monitor
• The first 19 Chapter MySQL Version update .

The first 7 Part of the strongest King

• The first 20 Chapter MySQL Interview treasure

A summary of the contents

Mysql performance tuning

One The basic chapter

• The first 1 Chapter MySQL Basic introduction
• The first 2 Chapter MySQL Architecture Composition
• The first 3 Chapter MySQL Introduction to storage engine
• The first 4 Chapter MySQL security management
• The first 5 Chapter MySQL Backup and recovery

Two Performance optimization

• The first 6 Chapter two influences MySQLServer Performance related factors
• The first 7 Chapter MySQL Database locking mechanism
• The first 8 Chapter MySQL database Query The optimization of the
• The first 9 Chapter MySQL database Schema Design performance optimization
• The first 10 Chapter MySQLServer performance optimization
• The first 11 Chapter 2 common storage engine optimization

3、 ... and Architecture design

• The first 12 Chapter MySQL Basic principles of extensible design
• The first 13 Chapter one: extensibility design MySQLReplication
• The first 14 Chapter 2 data segmentation of extensible design
• The first 15 Chapter one: extensibility design Cache And Search The use of
• The first 16 Chapter MySQLCluster
• The first 17 This paper introduces the idea and scheme of high availability design
• The first 18 Chapter high availability design MySQL monitor

A summary of the contents