While query caching is now gone from MySQL 8, its still not a show stopper. Add your own layer of query cache while handling queries.