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

General
1

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.
user@ycqlsh> DESCRIBE KEYSPACES;

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?

Screen Shot 2022-02-18 at 7.45.54 AM
Screen Shot 2022-02-18 at 7.45.54 AM758×250 10.8 KB

2

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.

3

@karthik

  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?

4

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

5

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

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

6

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