Questions tagged [yugabyte-db]

YugaByte DB offers integration of Transactional NoSQL, Planet-Scale SQL, and Distributed Key-Value Store in a single system.

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.

109 questions
4
votes
2 answers

How to setup YugabyteDB as eventually consistent distributed key-value database?

I'm launching a startup company providing Web SaaS (https://tuilder.com/). Big plans and potential. I'm interested in global replication with YugaByte. At the moment I have built an abstraction over BadgerDB, a Key-Value database written in GoLang.…
Emmanuel
  • 4,364
  • 5
  • 38
  • 63
3
votes
1 answer

How does encryption at rest work in Yugabyte DB?

Can we enable encryption after already having data in yb? Will it only encrypt new data? What's the estimated perf impact of encrypting? Do we need to bootstrap the tservers each time they start up with the keys? If they can get the existing keys…
James Hartig
  • 997
  • 1
  • 9
  • 20
3
votes
1 answer

Interface Connection Limit Configuration

I am running into what appears to be a connection limit for the YEDIS interface to yugabyte (or maybe an internal rpc connection limit). This limit is around 800 simultaneous connections. The following throws an error after a while: java -jar…
Jack Davidson
  • 3,242
  • 2
  • 26
  • 28
3
votes
1 answer

How does YugaBytes performance compare between Redis client and Postgres client for simple Key-Value schema?

Given that YugaByte offers client drivers for Redis and Postgres, I was wondering about performance differences between the two if used in similar fashion. For example, assume a Postgres table with 2 columns, 1 VARCHAR as the primary key and 1 TEXT…
3
votes
1 answer

Does YugaByte support geospatial queries?

Does YugaByte support geospatial queries? Given REDIS and Postgres API support I thought it might be possible, but I am not seeing any reference to this in the documentation.
Kevin Baker
  • 1,167
  • 3
  • 12
  • 22
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
  • 95
  • 7
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
  • 1,912
  • 2
  • 17
  • 27
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
  • 421
  • 3
  • 15
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
  • 421
  • 3
  • 15
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
  • 102
  • 1
  • 13
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 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
  • 672
  • 7
  • 15
1
vote
1 answer

Manual flushing doesn't delete all WAL files in YugabyteDB?

I am trying to flush the WAL to SST files using yb-ts-cli --server_address=<> flush_all_tablets. After the flushing is complete, I still see exactly 3G of WAL in two tables. Any ideas knows why that might be the case?
dorian YB
  • 582
  • 1
  • 7
1
2 3 4 5 6 7 8