Questions tagged [kubernetes-vitess]

11 questions
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
0 answers

How to connect vitess in multi region kubernetes environment

I have two clusters on GKE. Each cluster has a 6 node setup. I just deployed a helm chart of vitess on both clusters. A vitess operator is also deployed. etcd deplyoed with clusterWide: true My question is how to connect these two seperate vitess…
user12776721
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( …
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:…
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

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

Failed to open topo server on vitess with etcd

I'm running a simple example with Helm. Take a look below at values.yaml file: cat << EOF | helm install helm/vitess -n vitess -f - topology: cells: - name: 'zone1' keyspaces: - name: 'vitess' shards: -…
Bruno Wego
  • 2,099
  • 3
  • 21
  • 38
0
votes
0 answers

Is Vitess supports sequence(auto-increment) only in unsharded keyspaces?

As documentation says, it should be first creating backing table, so it confused what it should be
GurbaniX
  • 187
  • 2
  • 12