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
1 answer

Can’t create YCQL index with WHERE clause in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] Can somebody explain to me how to work with indexes metadata in YCQL? I found this article: https://docs.yugabyte.com/preview/api/ycql/ddl_create_index/. And I can't create example INDEX with…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Different versions of read-replica and primary-cluster in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] Is it possible to have the primary data cluster and read replica be at different versions? primary data @ 2.1 and replicate cluster @ 2.8
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Using read-replicas in YugabyteDB for DR

[Question posted by a user on YugabyteDB Community Slack] I’m trying to understand the tolerance failure in YugabyteDB. My scenario is as follows: Universe is setup with primary data cluster and 1 read replica cluster, max_stale_read_bound_time_ms =…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Using PostgreSQL Spark-connector in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] Is it possible to work with the Postgres tables using Spark-connector? Write and read to a Yugabyte Postgres?
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Max YCQL connections in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] What is the parameter that controls the maximum number of connections per tserver for ycql? I am looking at the equivalent of --ysql_max_connections which is having a default of 300. Is it…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Migrating from DB2, SQL Server to YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] This is regarding migration from a different source DB to YugabyteDB. I can see that 'YugabyteDB Voyager' supports Postgres, Aurora, MySQL and Oracle only as source database for Migration to…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Reading recently executed sql statements from WAL in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] How can I read the most recently executed sql statement? I think it's useful to analyze executed process. May I read it from wal?
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Connecting Debezium to YugabyteDB with snapshot mode

[Question posted by a user on YugabyteDB Community Slack] I have the YB Debezium running and I see that it has access to the table. here is the log: 2022-07-27 21:25:56,894 INFO AbstractConfig values: (org.apache.kafka.common.config.AbstractConfig)…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Recommended ratio of storage for yb-tserver yb-master in YugabyteDB cluster

[Question posted by a user on YugabyteDB Community Slack] What's the recommended ratio of storage of yb-master to yb-tserver?
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Error installing postgis for YugabyteDB in Ubuntu 22.04

[Question posted by a user on YugabyteDB Community Slack] I tried to install postgis plugin by following the directions in the docs [Yb Version 2.14.0.0 , Ubuntu 22.04] . What am I missing? yugabyte=# CREATE EXTENSION postgis; WARNING: …
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Best way to shard multi-tenant app in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] I want to someone remove my confusion, please correct me If I am wrong: I have 3 nodes (3 tables) Table structure: ID (Hash of Account/Site/TS) Account Site Timestamp I have pattern of…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Automatic refresh for materialized views in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] I was reading the recent article "YugabyteDB 2.15: Enable Developers to Build Quicker and Ship Faster" and saw this: Materialized views recompute in the background when the base tables…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Best config for balanced YugabyteDB cluster on 6TB dataset

[Question posted by a user on YugabyteDB Community Slack] I just setup a Yugabyte cluster. Before I migrate my database (6TB) over to yugabytedb cluster, I wanted to get my configs right. What is the recommended way of configuring automatic tablet…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Multi master replication in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] Wanted to analyze the Migration path from CockroachDB to YugaByteDB. Does Yugabyte support multiregion cluster out of the box with master-master replication? Let’s say we have Region 1: WEB +…
dh YB
  • 965
  • 3
  • 10
0
votes
1 answer

Checking cluster status in YugabyteDB

[Question posted by a user on YugabyteDB Community Slack] I have setup 3 nodes cluster in my LAB. Is there any command to check cluster status for all 3 servers except admin UI?
dh YB
  • 965
  • 3
  • 10
1 2 3
…
22 23