How to verify, if database is Cassandra DB or Yugabyte DB?

In our setup, below connection to database says Cassandra-3.9

[root@8d520 yugabyte]# ycqlsh 10.xx.xx.2 -u user -p passwd --ssl
Connected to local cluster at 10.xx.xx.x:9042.
[ycqlsh 5.0.1 | Cassandra 3.9-SNAPSHOT | CQL spec 3.4.2 | Native protocol v4]
Use HELP for help.

system_schema  system_auth  system

I have been told that the database is yugabyteDB.
Yugaware GUI interface shows table as YCQL type

  1. Why database type shown as Cassandra-3.9, in the above command? How to verify, if database is yugabyteDB or CassandraDB?

  2. What is the difference between YSQL type table and YCQL type table?

Hi @sham_yuga,

The database is YugabyteDB. It supports two APIs - YCQL (apache Cassandra compatible) and YSQL (PostgreSQL compatible). The above means that you created a cluster, and in it created 3 YCQL tables (apache Cassandra compatible).

This FAQ on API compatibility may be useful for you.


  1. Can I say DocsDB? instead of yugabyteDB…

  2. When you say, YSQL is PostgreSQL compatible, YSQL re-uses the upper half of PostgreSQL with a horizontally scalable lower half called DocDB. Being horizontally scalable, how YSQL(or load balancer) finds the shard owner to execute the query?

The client isn’t yet smart enough like in YCQL to directly route queries to the correct server: Cluster aware driver for YSQL · Issue #7880 · yugabyte/yugabyte-db · GitHub

Does load balancer route queries to correct server(shard owner)?

If no, how queries are routed to correct shard owner?

What do you mean by “load balancer”?
If an external one, then any yb-tserver will execute any query and do routing internally.