Questions tagged [yugabytedb]

Use for programming questions related to the YugabyteDB distributed SQL database.

YugabyteDB is an open source, high-performance, distributed SQL database for powering global, massively-scalable applications. At its core is a distributed document store whose sharding, replication and ACID transactions architecture is inspired by Google Spanner. It provides two APIs on top of this core - YSQL for fully relational workloads and YCQL for semi-relational workloads.

335 questions
2
votes
1 answer

How to Return a Specific Tablet with a YCQL Query

Using YCQL, what would I need to add to a query for the query to return the specific tablet that the results are on? [Disclaimer]: This question was first asked on the YugabyteDB Community Slack channel.
MarkoR
  • 115
  • 8
2
votes
1 answer

Is there any in-memory engine in Yugabyte

Do we have any in-memory kind of engine just like Couchbase provides an in-memory layer and all the data sits over in-memory and if the node reboots your data is gone. we don't want to use yedis for caching layer if it provides any.
sai
  • 165
  • 1
  • 10
2
votes
1 answer

How to print change data logs at stdout in yugabyte?

I am using yugabyte db 1.3.0.0 and following https://docs.yugabyte.com/latest/deploy/cdc/use-cdc/ to learn yugabyte db cdc. Procedure Followed: a) generate users dynamically and insert into table, yugastore.users continuously through script b)…
AVA
  • 2,474
  • 2
  • 26
  • 41
2
votes
1 answer

Yugabyte failover time

Can someone answer? what is the failover time if a node goes down, I did see it take 2 to 3 seconds but do we have control to make it faster than this? if yes how much. Typically, we cannot take this hit on the application queue it is that…
sai
  • 165
  • 1
  • 10
2
votes
1 answer

Can we modify the number of tablets/shards per table after we create a universe?

As described in this example each tserver started with 12 tablet as we set number of shards to 4. And when we added a new node the number of tablet per tserver became 9. it seems the total number of tablet, which is 36, will not increase. My…
Ali Zeinali
  • 551
  • 4
  • 16
2
votes
1 answer

Peformance difference between YSQL vs YCQL

Based on the document "Benchmarking Distributed SQL Databases" What sees that throughput is higher in YCQL when compared with YSQL. If we are using the same table structure and tool to insert would be the same and I am not using any SQL like…
sai
  • 165
  • 1
  • 10
2
votes
2 answers

Are YSQL and YCQL compatible with each other?

As i know yugabyte store data in something called DocDB and it provide YSQL API and YCQL API over that. So if i'm not wrong, Are YSQL and YCQL compatible with each other? For example: Can i create a table with YSQL and query on it with YCQL? And if…
Ali Zeinali
  • 551
  • 4
  • 16
2
votes
1 answer

What is the maximum number of active nodes possible in yugabyte db?

I am experimenting a theory on Yugabyte db and they have such a good performance metrics. I want to know whether the Yugabyte Database can handle more than a million active nodes around the world and still have performance. Yugabyte website
Gautham J
  • 133
  • 2
  • 15
2
votes
1 answer

How can I import a jsonb column from a csv file using the COPY command?

I am trying to import the following csv file into YugaByte DB YSQL. Note that the second entry in each row is a JSON object. "15-06-2018","{\"file_name\": \"myfile1\", \"remote_ip\": \"X.X.X.X\"}" "15-06-2018","{\"file_name\": \"myfile2\",…
2
votes
1 answer

Accessibility of data using different APIs

Can I access the same data using different APIs? Example: Can I insert the data using YCQL and read it using YEDIS?
Ricardo Adam
  • 115
  • 5
2
votes
1 answer

How is YugaByte DB's replication model?

How similar or different is YugaByte DB's replication model compared to PostgreSQL master-slave replication?
2
votes
1 answer

Statement enabling in Yugabyte YSQL

I want to see all the YSQL statements that are being executed. Something like log_statement=all in postgres. How do I enable statement logging in Yugabyte YSQL?
Ricardo Adam
  • 115
  • 5
2
votes
1 answer

How is memory managed in YugaByte DB?

How is memory is managed in YugaByte DB? I understand that there are two sets of processes yb-tserver & yb-master, but couldn't find too many other details. Specific questions: How much RAM do each of these processes use by default? Is there a way…
Srinath
  • 51
  • 2
2
votes
1 answer

How to install YugaByte on Docker for Windows

The instructions at https://docs.yugabyte.com/latest/quick-start/docker/install/ state that Docker for Windows is supported, however the yb-docker-ctl utility in the step that follows seems to be a *nix app and does not run on Windows 10 Pro. How…
Smyrnian
  • 701
  • 9
  • 15
1
vote
1 answer

Delta Lake table update column-wise in parallel

I hope everyone is doing well. I have a long question therefore please bear with me. Context: So I have CDC payloads coming from the Debezium connector for Yugabyte in the following form: r""" { "payload": { "before": null, "after": { "id": { …
1
2
3
22 23