How to SELECT a database? If redis using unix socket

[cryply]

Summary

How to access database 1,2,3....? Can we have combined view over all DBs?

[mikhail-vl]

@cryply, that is a great question. Logical databases in Redis have a lot of limitations and are supposed to be removed from Redis as Salvatore said a long time ago. What kind of data do you want to view over all DBs?

When connecting in the Standalone mode you can specify the logical database (https://redisgrafana.github.io/redis-datasource/configuration/). Unfortunately, there is no way to specify the database id in the Cluster or Socket and you can't use SELECT because of simultaneous connections opened for the database for performance.

[mikhail-vl]

@cryply, I am thinking to add SELECT database functionality and execute the SELECT command when opening a new connection. Let me know if you will be interested to test it using Sockets.

[cryply]

100%

but best to get overall performance

On Sun, Dec 5, 2021, 17:16 Mikhail Volkov @.***> wrote:

@cryply https://github.com/cryply, I am thinking to add SELECT database functionality and execute the SELECT command when opening a new connection. Let me know if you will be interested to test it using Sockets.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/RedisGrafana/grafana-redis-datasource/issues/241#issuecomment-986247988, or unsubscribe https://github.com/notifications/unsubscribe-auth/AIYXY7UTOVDWOMGDM6KNNBDUPN63PANCNFSM5JEB4WRQ . Triage notifications on the go with GitHub Mobile for iOS https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675 or Android https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub.

[BSVogler]

Logical databases in Redis have a lot of limitations and are supposed to be removed from Redis as Salvatore said a long time ago

Do you have any more information on that? I am aware of the limitations but for some use-cases like when migrating this is a very handy feature. Without multiple databases, you would need to deploy a whole new server. Typically DBaaS costs are also per server, so this would add additional costs.

[kranthikirang]

https://pkg.go.dev/github.com/mediocregopher/radix/v3#Dial will solve this problem along with https://pkg.go.dev/github.com/mediocregopher/radix/v3#DialSelectDB

However, we need to have an option in Frontend to take care this. I can send a PR if you are interested.