DEV Community

loading...
Cover image for Scoreboard of Rose Bowl Games powdered by Redis & MySQL - Use Terraform To Provision All Resources

Scoreboard of Rose Bowl Games powdered by Redis & MySQL - Use Terraform To Provision All Resources

mrboogiej
Updated on ・1 min read

Here is a tutorial to simulate a scoreboard of past Rose Bowl Games, with MySQL as the persistent data store and Redis as the cache layer.
You can also apply this solution to your backend of mobile gaming, sports event, online education, etc.
Watch Now (15 mins)>

【Main Contents】
1) Deploy the cloud resource: Redis, MySQL, ECS, using Terraform script
2) Configure application environment - Java, step by step
3) Demonstrate the SQL Query either through cache(Redis) or database(MySQL)

You will learn followings.
💯 Using Redis as data cache to accelerate data accessing to database.
💯 The simplest solution for RDS MySQL database caching with Redis. This solution relies on the expiration time (TTL) of the key in Redis. Redis won't be updated proactively when MySQL is updated.

💡 The approach is simple to implement, but the inconsistency duration may be very long especially for the scenario that the read request is very frequent and the expiration time is relatively long, a lot of long-term dirty data will be generated.

【Source Code】
Please refer to the documentation on GitHub.

【About ApsaraDB for Redis】
ApsaraDB for Redis Series >

【Bonus】
Get up to 60 days FREE trial now >

Discussion (0)