Feedback requested on proposed Redis usage/implementation

[Rich P]

We've got ~60GB of SQL data in ~2,000 databases and currently all reads/writes are done directly to SQL.

As part of a new GraphQL implementation we're proposing copying all of the SQL data to Redis with an initial import, subsequent writes would be synced to Redis. We can then make read requests to Redis which we hope will be faster than querying SQL.

We've built out an indexing solution and this is working on a relatively small scale test (about a dozen small databases syncing) but I was hoping to get some feedback on potential pitfalls and whether this looks like a workable solution.

[Jan-Erik Rediger]

Are you actually hitting a bottleneck keeping the data in your SQL
database?

> --
> You received this message because you are subscribed to the Google Groups "Redis DB" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to redis-db+u...@googlegroups.com.
> To post to this group, send email to redi...@googlegroups.com.
> Visit this group at https://groups.google.com/group/redis-db.
> For more options, visit https://groups.google.com/d/optout.

[Rich P]

Not a bottleneck as such but we're running some pretty large queries and expect/hope that Redis will deliver some significant speed improvements.