Stack Overflow
Stack Overflow

Questions tagged [vitess]

Vitess is a database clustering system for horizontal scaling of MySQL

Reference:

57 questions
10
votes
0 answers

Scaling MySQL (sharding): Tesora, ScaleArc, youtube/vitess or scalebase?

Scaling MySQL (sharding): Tesora, ScaleArc, vitess, jetpants , MySQL Fabric, SpiderDB or shardquery? What are the differences between them and who stands out? Which one am I forgetting? Anybody with good experience on these? Thanks in advance!
Nicolas
  • 455
  • 3
  • 10
5
votes
1 answer

How to manage conflicting DataProc Guava, Protobuf, and GRPC dependencies

I am working on a scala Spark job which needs to use java library (youtube/vitess) which is dependent upon newer versions of GRPC (1.01), Guava (19.0), and Protobuf (3.0.0) than currently provided on the DataProc 1.1 image. When running the project…
Smith
  • 91
  • 1
  • 3
4
votes
2 answers

How to specify sql dialect when creating spark dataframe from JDBC?

I'm having an issue reading data via custom JDBC with Spark. How would I go about about overriding the sql dialect inferred via jdbc url? The database in question is vitess (https://github.com/youtube/vitess) which runs a mysql variant, so I want to…
Smith
  • 91
  • 1
  • 3
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

java.sql.SQLException: target: commerce.0.primary: vttablet: rpc error: code = InvalidArgument desc = Unknown system variable 'query_cache_size'

I am facing this issue while connecting to Vitess's MySQL cluster. Following are the configuration & versions which I am using. Vitess - 12.0.0 MySQL - 8.0.27 mysql-connector-java - 8.0.27 Springboot -…
NPS
  • 93
  • 2
  • 7
2
votes
1 answer

Why are Kubernetes operators not deployed using Helm?

I noticed that all the documentations on deploying operators in kubernetes always use a simple kubectl create -f /point/to/some/big/blob/deploying/the/operator.yaml as the "newer" alternative to a plain helm chart. That made me wonder why operator…
Anticom
  • 975
  • 13
  • 29
2
votes
1 answer

TRIGGERS in VITESS -> Distributed MySQL

I'm trying to create TRIGGERS in vitess.io Database. (Distributed MySQL) I got the following errors : CREATE TRIGGER insert_guid BEFORE INSERT ON trx FOR EACH ROW SET NEW.sign = UUID(); MySQL a retourné : vtgate: http:/xxxxxx:15000/: syntax error at…
aorfevre
  • 5,034
  • 3
  • 21
  • 51
2
votes
0 answers

Connect dot net core application to vitess data base

We deployed dot net core application in kubernetes and we started to use vitess database to scale mysql. How can we connect dot net core application with vitess?
Chethan SR
  • 77
  • 1
  • 9
2
votes
1 answer

Vitess: Initialize keyspace schema using SQL file

I am using helm and the file 101_initial_cluster.yaml from the Vitess example to setup my initial cluster. The example has a schema initialization using SQL string as shown below: schema: initial: |- create table product( …
Jakoguta
  • 23
  • 2
2
votes
1 answer

Why do pods remain in 'pending' status?

I am very confused about why my pods are staying in pending status. Vitess seems have problem scheduling the vttablet pod on nodes. I built a 2-worker-node Kubernetes cluster (nodes A & B), and started vttablets on the cluster, but only two…
user1208081
  • 1,057
  • 4
  • 15
  • 29
2
votes
1 answer

How to shard only specific tables using vitess

I have created an unsharded keyspace with three tables. Now I would like to shard my keyspace for first two tables but don't want to shard the third table. How can this be done? Vitess documentation does not contain any info or example regarding…
manojadams
  • 2,314
  • 3
  • 26
  • 30
2
votes
1 answer

vtctlclient: command not found

I am trying to run Vitess on Minikube and I'm going through the 'Getting Started' steps found here: http://vitess.io/getting-started/#set-up-google-compute-engine-container-engine-and-cloud-tools I have installed everything I need to including…
antel0pe
  • 126
  • 1
  • 4
1
vote
0 answers

Foreign key constraints not allowed using Drizzle ORM

I write the following schema in the Drizzle recommended syntax in order to initialise my project's database in PlanetScale (MySql). After completing the migration process and trying to npx drizzle-kit push:mysql, I got the following error: No config…
Braz
  • 73
  • 6
1
vote
1 answer

Prisma, prevent duplicated likes button?

I don't want duplicate rows to be added to the database from users who have already clicked the like. What should I do? I've seen it said to use upsert, but isn't upsert create if it doesn't exist and update if it exists? If you update, there will…
dontknowhy
  • 2,480
  • 2
  • 23
  • 67
1
vote
1 answer

Sharding with replication

Sharding with replication]1 I have a multi tenant database with 3 tables(store,products,purchases) in 5 server nodes .Suppose I've 3 stores in my store table and I am going to shard it with storeId . I need all data for all shards(1,2,3) available…
Behdad
  • 184
  • 3
  • 12
1
2 3 4