redis-rb VS mysql2

You're right the general client doesn't have the stack support yet. https://github.com/redis/redis-rb.

Sidekiq integration - requires the Redis gem 3.3.5 or higher. For this integration, the AppSignal gem 2.9.5 or higher is recommended.

It mentions hiredis. A quick look at the redis-rb source code yields that this is coming from Hiredis connection: https://github.com/redis/redis-rb/blob/6542934f01b9c390ee450bd372209a04bc3a239b/lib/redis/connection/hiredis.rb#L18

You're likely already using this library to connect, but check out these docs: https://github.com/redis/redis-rb#cluster-support

I use redis-rb to connect to my Redis cluster (multi shard/node architecture) from my Rails app. In the documentation, I can see that it is enough to provide the cluster endpoint while initialising the client and the client will discover the node endpoints along with their respective keys slot using the cluster-nodes command:

The redis-rb gem is not thread-friendly by default. If you use redis-rb without a connection pool you will end up with race conditions on Redis accesses.

Thanks for your suggestion. AFAIR, i tried installing the gem 'activerecord-trilogy-adapter' but without the git path . Currently, I have successfully installed mysql2 on Windows by following the steps outlined in the following GitHub issue: https://github.com/brianmario/mysql2/issues/1151.

In the above command, you’ve installed the TypeORM and mysql2 modules: they will enable you to connect your application to a MySQL database and perform operations on it.

We will be using mysql2 gem for our purpose. Let's first create a service to connect with external mysql server.