How To Set Up Redis as a Cache for MySQL with PHP on Ubuntu 20.04

Here is the article. 

Redis is an open-source and in-memory data structure store that can be used for caching, real-time analytics, searching, and machine learning. Integrate Redis with PHP and MySQL will improve your application performance because Redis stores data in RAM.

You can use it with databases like MySQL or MariaDB. Redis provides a mechanism to cache your queries. For example, when a user requests your application page the first time, a MySQL query is performed on the server, and Redis caches this query to RAM. When another user requests the same page, you don’t need to query the database again.

Step 1 - Step 4 skipped

Step 5: Create a PHP Application to Fetch Data from MySQL

Next, you will need to create a PHP application and host it with an Apache webserver. This application will connect to the MySQL database and query the student table which we have created earlier.

First, create a PHP application in the Apache web root directory:

nano /var/www/html/student.php

Add the following codes:

Step 6: Test Redis Caching

Step 6: Test Redis Caching

Next, you will need to test whether the Redis caching is working or not. Open your web browser and access your application using the URL

http://your-server-ip/student.php. When you access the application first time, it should fetch from the MySQL database. When you access the application again, it should open faster because you will get data from the Redis cache.

Of course, you don’t have to install setup Redis with MySQL if you use one of our Managed Redis Hosting, in which case you can simply ask our expert Linux admins to install and configure this for you. They are available 24×7 and will take care of your request immediately.