Stack Overflow
Stack Overflow

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
5
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,933
  • 5
  • 46
  • 71
4
votes
1 answer

Difference between Yugabyte's YCQL & YSQL

Can I get some help in understanding the real difference between YSQL vs YCQL? Based on the documentation I understand that the current implementation of underlying storage for YUGABYTE is DOCS DB and uses RAFT for replication. Based on this can I…
sai
  • 165
  • 1
  • 10
4
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
  • 4,613
  • 2
  • 27
  • 31
3
votes
2 answers

Why INSERT query is 3-4 times slower than SELECT?

Application talks to YugabyteDB instance with YCQL driver(Gocql). We have below two queries (for example): SELECT col2, col3, col4, col5 FROM table1 WHERE primarykeycol = 11ab8b12 - a934 - 4f2e - 8a0d - e7eba3faa47f; INSERT…
overexchange
  • 15,768
  • 30
  • 152
  • 347
3
votes
1 answer

Multi dc replication using two Yugabyte instances

I'm running the sample project from How to setup akka persistence project : https://developer.lightbend.com/start/?group=akka&project=akka-samples-persistence-dc-java application.conf: cluster { seed-nodes = [ …
blue-sky
  • 51,962
  • 152
  • 427
  • 752
3
votes
1 answer

Data key rotation in Yugabyte DB

From the encryption at rest design document in Github, only the Universe Keys are rotated while the data keys remain unchanged for the lifetime of the data file. However, the Yugabyte docs mention that "Old data will remain unencrypted, or…
molavedev
  • 168
  • 1
  • 6
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
  • 1,009
  • 1
  • 9
  • 20
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…
Tobias Mühl
  • 1,788
  • 1
  • 18
  • 30
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,187
  • 3
  • 12
  • 22
2
votes
1 answer

Index Not use in basic query

Having the table block: CREATE TABLE IF NOT EXISTS "block" ( "hash" char(66) CONSTRAINT block_pk PRIMARY KEY, "size" text, "miner" text , "nonce" text, "number" text, "number_int" integer not null, "gasused" text , …
Brahian
  • 46
  • 1
  • 5
2
votes
0 answers

yugabytebd springboot integration

I am trying to integrate yugabytedb with springboot application, but when trying to run the application I am getting the attached exception [Description: An attempt was made to call a method that does not exist. The attempt was made from the…
Shubhankar Ghosh
  • 21
  • 2
2
votes
0 answers

Create data lineage on yugabyte db thru apache atlas

No much resources are available online. But i wanted to create a data lineage system on data sourcing from yugabyte db thru Apache Atlas . Any pointers are appreciated . For e.g. Below is the process that i have [TABLE A] --python function--> [TABLE…
Tapas Kumar Pradhan
  • 73
  • 6
2
votes
1 answer

Why is my pg_hint_plan Leading hint not used?

I defined the join order with Leading(b a) but PostgreSQL, or compatible database like YugabyteDB, still join from a to b: yugabyte=# explain (costs off, timing off) /*+ Leading( b a ) */ select * from table_a a join table_b b…
FranckPachot
  • 414
  • 4
  • 10
2
votes
2 answers

Which distributed SQL databases put data from different tables with the same tenant in the same node?

I’m designing a SQL data schema with many tables that have a compound primary key of (customer_id, id). The application will frequently need to run JOIN queries to assemble data. However, it should never run cross customer joins. (Strictly…
Calebmer
  • 2,972
  • 6
  • 29
  • 36
2
votes
1 answer

Getting FATAL: conversion between WIN1252 and UTF8 is not supported when connecting to YSQL from Windows

[Question posted by a user on YugabyteDB Community Slack] I am trying out the Yugabyte Cloud free tier. I tried connecting to the Yugabyte database from pgadmin. I received the following error on the pgadmin console: C:\Program Files\pgAdmin…
dh YB
  • 965
  • 3
  • 10
1
2 3
…
22 23