Is there a proxy solution for Yugabyte Cassandra?

I see there is some talk about proxy solution for YEDIS:

There is also proxy solution for Postgres:

We are looking for proxy solution for Yugabyte YCQL (Cassandra). Does YB support proxy against YCQL?

Hi @Steve_Liang

YCQL drivers are cluster aware and have no need for a proxy. They know which nodes are up/down and can route queries directly. YCQL also supports multi-plexed connections to run concurrent queries over 1 connection.

What language will you be coding in ?

We have developers using Java, Node.JS, and Python. My primary concern is the number of connections the master node handles. May be asking about proxy for YB cluster is the wrong question.

These will work fine.

The clients don’t connect to the yb-master processes but yb-tservers.
Do you have a use case where you instantly start 1000 client processes ?

Dorian, we run an increasing number of K8S apps and at times one app can scale to hundreds of pods. I seen on occasions where we scale 100 pods to 200 pods in one go. In production operation, we found that YB team asked us to reduce the number of connection to YB cluster which composes of 6 m5.4xlarge nodes. I am guessing it comes down to efficient use of YB client driver and beyond that, create another YB cluster.

Yes, the problem is that when making a new connection to yb-tserver, yb-tserver then queries yb-master, which can get overwhelmed.

We are in the process of caching queries to yb-master to significantly lower overhead. See https://github.com/yugabyte/yugabyte-db/issues/4640 and https://github.com/yugabyte/yugabyte-db/issues/5872.

Sounds good. Looks like a fundamental change in YB.