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
0
votes
0 answers

YugabyteDB xCluster replication issues with WAL

Create two new Cluster (NYC and FRA) — fresh (1 node per region) Create a new table in each NYC and FRA Create a bi-directional replication for the table (xCluster) All works Delete replication (1 and 2) both direction Alter table (add column) in…
wildneuro
  • 203
  • 2
  • 3
0
votes
1 answer

Joins with 8 tables in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] I have a dataset and a query with 8 joins on tables that have between 10 and 17,000 rows, the query returns 4,000 rows. My problem is it is very slow. There's no obvious way to rewrite the…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Errors persisting after recovering YugabyteDB cluster

[Question posted by a user on YugabyteDB Community Slack] We’re trying to do a postmortem on an issue we hit in our cluster. It looks like one of our 3 nodes went down and the other two were unable to process requests until it came back. Looking…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Increasing disk size in YugabyteDB cluster

[Question posted by a user on YugabyteDB Community Slack] We have created a universe with 5 data nodes(airgap installed) and 3 as the replication factor. Now we are planning to increase the disk size in all 5 nodes and increase the mount point space…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Correct way to bring up the yb-master and yb-tserver processes in a YugabyteDB cluster

[Question posted by a user on YugabyteDB Community Slack] We are using YugabyteDB 2.14.0.0 on 3 node setup, where on each node 1 yb-master and 1 yb-tserver is running. We first bring up the yb-master on each node using a command of the following…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Issue running yb-sample-apps benchmark in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] Can someone help me with below issue. java -jar yb-sample-apps.jar --workload SqlInserts --nodes 192.168.33.131:9042 1 [main] INFO com.yugabyte.sample.Main - Starting sample app... 57…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Splitting tablets in YugabyteDB over multiple directories using fs_data_dirs

[Question posted by a user on YugabyteDB Community Slack] I did some reading in the docs and found fs_data_dirs. Does yugabyte-db automatically split the tablets evenly in the data dirs?
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

YugabyteDB YSQL inter-node compression

[Question posted by a user on YugabyteDB Community Slack] Question about YB and compression. We want to use the ysql connector, does it support SSL compression like vanilla PostgreSQL? Postgres allows compression using OpenSSL zlib, some DB vendors…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Renaming a table & keeping connections to existing partitions in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] Does renaming the table, existing partitions attached to that table remain as it is after renaming?
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Can you shard a partitioned table in YugabyteDB?

[Question posted by a user on YugabyteDB Community Slack] Can a partitioned table in YugabyteDB YSQL be sharded underneath?
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

ctid is not supported yet in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] I am currently migrating all my data from PostgreSQL to YugabyteDB, and everything was going fine until I tried to migrate my views table but then I got this error: ERROR: System column…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Forcing a leader change in YugabyteDB cluster

[Question posted by a user on YugabyteDB Community Slack] Is there a way to force a leader change in YugabyteDB? I see there is a yb-admin command 'master_leader_stepdown' but the documentation mentions a possible downtime.
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

SSL errors when connecting skyvia to YugabyteDB YSQL

[Question posted by a user on YugabyteDB Community Slack] I'm trying to connect my yugabytedb database with skyvia (as a PostgreSQL connection), but I'm getting the following error: no pg_hba.conf entry for host "40.118.246.204", user "admin",…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Generated columns in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] I'm studying YB for a while and I faced a problem. I try to create Generated Columns but this feature is available in PostgreSQL 12 so I would like to know if YB has a plan to support this…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Unique indexes in YugabyteDB YCQL

[Question posted by a user on YugabyteDB Community Slack] Question about UNIQUE keyword. I can create an index with unique keyword inside, like: CREATE unique INDEX warehouse_idx ON orders (warehouse_id); But I do not see this opportunity in the…
dh YB
  • 965
  • 3
  • 10
1 2 3
…
22 23