Differences between redis and MySQL

One 、.redis and mysql Summary of the differences

（1） On type

        In terms of type ,mysql Is a relational database ,redis Is the cache database

（2） In effect

       mysql For persistent storage of data to the hard disk , Powerful , But it's slower

       redis It is used to store frequently used data into the cache , Fast reading speed

（3） On demand

       mysql and redis Because of the different needs , It is usually used in combination with .

Two 、 Detailed instructions

1.mysql and redis Database type of

mysql Is a relational database , It is mainly used to store persistent data , Store data on a hard disk , Slow read speed .

redis yes NOSQL, This is a non relational database , It is also a cache database , Store data in cache , Cache read speed is fast , Can greatly improve the operation efficiency , But the storage time is limited

2.mysql Operation mechanism of

mysql Relational databases as persistent storage , The relative weakness is that every time you request access to the database , They all exist I/O operation , If the database is accessed repeatedly and frequently . First of all ： You spend a lot of time chaining databases , As a result, the operating efficiency is too slow ; second ： Repeated database access can also lead to overloading of the database , Then the concept of caching is derived .

3. cache

A cache is a buffer for data exchange （cache）, When the browser executes the request , First of all, search in the cache , If there is , Just get ; Otherwise, access the database .

The advantage of caching is fast reading speed

4.redis database

redis Database is a cache database , Used to store frequently used data , This reduces the number of times you access the database , Improve operational efficiency .