Why Your MySQL Needs Redis

Here is the link.

Feb 27, 2018

Redis is the go to solution If your application stores data in MySQL or any other relational database. This video will cover the many benefits of inserting Redis in between your application and the database. We'll cover scalability, caching, session store, and much more. Subscribe to RedisLabs: http://bit.ly/RedisLabsSubscribe​​ Learn more about Redis Labs: Website: https://redislabs.com​​ Facebook: https://www.facebook.com/redislabs​​ Twitter: https://twitter.com/RedisLabs​​ Instagram: https://www.instagram.com/redislabsof... LinkedIn: https://www.linkedin.com/company/redi... About Redis Labs: Redis Labs helps organizations reimagine how quickly they can process, analyze, make predictions with, and take action on the data they generate. As the home of Redis, the most popular open source database, we provide a competitive edge to global businesses with Redis Enterprise, which delivers superior performance, unmatched reliability, and the best total cost of ownership. Redis Enterprise allows teams to build performance, scalability, security, and growth into their applications. Designed for the cloud-native world, Redis Enterprise uniquely unifies data across hybrid, multi-cloud, and global applications, to maximize your business potential.
Redis as a front end database. Use cases:

• caching
• session store
• Rate limiting
• Fast data access

Redis

1. Performance
2. Simplicity
3. Extensibility

Redis is uniquely suited to modern apps

A full range of capabilities that simplify and accelerate next generation applications

1. High-speed transactions
2. Caching
3. Analytics
4. Messaging
5. Machine learning
6. Search
7. Fast data ingest
8. Time series
9. Job & queue
10. Geo-spatial indexing
11. Graph

20:45/ 58:20

When to use

• Session based apps with frequent reads and writes
• Data is isolated between sessions

Examples:

e-Commerce, gaming, social application, etc.

Designing a Session Store in Redis

1. Identify the tables that store session data
2. Determine the Redis equivalent data structures
3. List the queries, develop Redis equivalents
4. Decide the procedure to load the session data and re-synchronize the data back from Redis to MySQL
5. Modify the data access layer or the app

3. Redis for Metering

Use Case: Rate-limiting

Limit the peak load on your legacy database by limiting the number of queries per second to the highest threshold

How Redis helps you?

• Built-in counters
• Time-to-live
• Single-threaded architecture assures serializability

4. Redis for Fast Data Ingest

Use Cases:

• Real-time analytics
• IoT
• Log collection, time-series

How Redis helps you?

• Pub/Sub
• List
• Sorted Set

Advantages of Redis Enterprise

High availability

• Cover your business for peak hour traffic
• Prevent cache stampede
• Deliver consistent high performance
• Zero downtime scaling

Security

•  Meet your organization's security and compliance requirements

Performance

• Maximize resource utilization: Run on all CPU cores

Active-Active

• Maintain consistent session state across all data centers
• CRDT based active-active delivers strong eventual consistency with local latency

Redis on Flash

•     No need to evict or delete session data; allow the data to overflow to Flash memory