Stack Overflow
Stack Overflow

Questions tagged [vitess]

Vitess is a database clustering system for horizontal scaling of MySQL

Reference:

57 questions
1
vote
0 answers

Vitess vtctl cannot connect to zookeeper topo server

I am trying to setup a vitess cluster on my local. I chose zookeeper as my topology server and I have used docker-compose to set it up. version: '3.9' services: zoo1: container_name: zks1 image: zookeeper restart: always hostname:…
Satyaki Das
  • 21
  • 2
1
vote
1 answer

vitess kubernetes ERROR 1105 (HY000): table xxx not found

kubernetes version: v1.16.3 linux version: 7.3.1611 Starting Vitess cluster on kubernetes, then login to VTGate and create table ./mysql -h 127.0.0.1 -P 15306 -uuser mysql> CREATE TABLE sbtest1( id INTEGER NOT NULL AUTO_INCREMENT, k INTEGER DEFAULT…
masikkk
  • 41
  • 5
1
vote
0 answers

Error starting vreplication engine: error in connecting to mysql db with connection Vitess on kubernetes

kubernetes version: v1.16.3 linux version: 7.3.1611 Starting Vitess cluster on kubernetes using default operator.yaml and 101_initial_cluster.yaml, one of example-vttablet-zone1-xxx pod is restarting forever. using kubectl logs -f…
masikkk
  • 41
  • 5
1
vote
1 answer

How to connect to Vitess database with JDBC connector

I'm trying to connect to Vitess database. To my best knowledge I have to use dedicated JDBC connector (https://mvnrepository.com/artifact/io.vitess/vitess-jdbc) for the Vitess. I have tried to connect like this: #1…
user12396614
  • 43
  • 3
1
vote
1 answer

Consistent reads from multiple readers

Consider a scenario, a web request makes N database requests. If I know that all or majority of the requests can be sent to db-readers. With Vitess's architecture, when there are multiple readers setup, wouldn't those N db requests get distributed…
Bibek Shrestha
  • 32,848
  • 7
  • 31
  • 34
1
vote
1 answer

How I can set sql_mode in vitess v6.0.20-20200508

I am using latest vitess v6.0.20-20200508 and MySQL version 5.7. Without updating the MySQL version I want remove "ONLY_FULL_GROUP_BY" from sql_mode. Can anyone please help me? I tried with SET global sql_mode=(SELECT…
Ranjan Sorte
  • 21
  • 1
1
vote
1 answer

unsupported: LAST_INSERT_ID is only allowed for unsharded keyspaces

I am using MySQL on vitess and My java application is running on docker version 19.03. When I add any record in the database table using hibernate, it is showing error unsupported: LAST_INSERT_ID is only allowed for unsharded keyspaces. Not sure…
Ranjan Sorte
  • 21
  • 1
1
vote
1 answer

is it possible to shard Vistess with the secondary sharding Key

We are using Vitess database to scale and achieve Horizontal Sharding in mysql. is it possible to do the secondary shard in Vitess. For eg: Table 1 - Agency ( AgencyID INT, CreatedOn DATETIME …
Chethan SR
  • 77
  • 1
  • 9
1
vote
1 answer

issue with Connecting Vitess from mysql Work Bench

we are able to connect Vitess from dot net core application but where as we are getting attached error while connecting vitess from MySQL Work bench. is anything we are missing. Thanks
Chethan SR
  • 77
  • 1
  • 9
1
vote
0 answers

How to loadbalance multiple application servers against multiple Vtgates

We are doing a POC to prove that Vitess can scale massively and meet our requirements. We are using around 40 application servers, 15 VTGates and 30 shards (each shard contains master, replica and rdonly). However we were able to scale up to a point…
Don
  • 97
  • 1
  • 1
  • 8
1
vote
1 answer

Vitess Sharding issue

I am new to the Vitess and we have deployed Vitess in Kubernetes using Helm Charts and exposed VTGate through node Port and able to connect MYSQL Work bench using the exposed VTGate Ip Address. When we inserted the records using MySql Work Bench,…
Chethan SR
  • 77
  • 1
  • 9
1
vote
0 answers

Anomaly in VTGate QPS

I am running multiple application servers and AWS Network load-balancers against 12 VTGates. I see following anomaly in VTGates. Sometimes QPS suddenly drops to 0. Not too sure what is happening exactly. Hope someone can point out if I am doing…
Don
  • 97
  • 1
  • 1
  • 8
1
vote
1 answer

Vitess MySQL authentication is not working

While installing Vitess through helm in site-values.YAML we enabled authentication mysqlProtocol: enabled: false authType: secret # authType can be: none or secret. For secret, perform the following changes: username:…
Nithya
  • 582
  • 8
  • 19
1
vote
1 answer

How to increase shards using Vitess

I have 4 shards in 4 different physical server. -40 40-80 80-c0 c0- Now I want to add two more shards. How can I change key range and split the data.
Don
  • 97
  • 1
  • 1
  • 8
1
vote
1 answer

Can we shard specific tables without creating new keyspace in vitess?

For Example: I want to create 40 tables in one keyspace. In 40 tables I want to shard 3 tables. Is is it possible to shard specific tables without creating new keyspace. I have seen How to shard only specific tables using vitess But for this we…
uma
  • 11
  • 1
  • 1
1
2
3 4