Questions tagged [vitess]

Vitess is a database clustering system for horizontal scaling of MySQL

Reference:

57 questions
0
votes
1 answer

vitess implementation

Can someone please help me on how to implement a proper vitess cluster on production. I am going through the vitess DOC but I am unable to figure out how a proper cluster is setup with multiple machines.
user11549576
  • 119
  • 1
  • 14
0
votes
1 answer

Vitess remote connection access denied issue

I am new on Vitess and I am trying move my mysql database on Vitess. I followed local installation instructions of vitess. I can connect mysql on local pc but when I try to connect from different pc that is on same local network, It is giving access…
doğan
  • 339
  • 1
  • 4
  • 15
0
votes
0 answers

Vitess: pass parameter to consul

I would like to connect Vitess (for example, vtcld) to Consul (as Topo server) but I need to pass dc parameter. I thought it should be done in consul_auth_static_file but I guess it is only being used for authentication purpose. So, the questions…
Woody
  • 1
0
votes
1 answer

How to create multiple Vitess Indexes

Could anyone point out how to change VSchema in Vitess to accommodate multiple VIndexes. { "sharded": true, "tables": { "card": { "column_vindexes": [ { "column": [ …
Don
  • 97
  • 1
  • 1
  • 8
0
votes
1 answer

Insert large blob into vitess through node js

I'm using this method to insert a large blob into my mySQL database (Blob size ~40MB) After ~15 seconds it throws a exception or CPU utilisation goes to 100% and remains 100% upto ~25-50 seconds. The whole thing here works with blobs smaller then…
Vikas
  • 1
0
votes
0 answers

vitess installation failure at ./kvtctl.sh Remote error: rpc error: code = Unavailable desc = transport is closing

I am installing vitess in minikube. I am following the instructions for vitess installation in kubernetes, section: 6. Use vtctlclient to send commands to vtctld. I am getting the below…
Malar Kandasamy
  • 839
  • 2
  • 10
  • 17
0
votes
1 answer

Vitess guestbook example not working in minikube

I am following the instructions on how to setup vitess in kubernetes. I am using minikube 0.15 on my local machine (windows 10) running on virtualbox 5.1.12. I have managed to get all the way to step 12 before I start seeing strange things…
ryanmc
  • 764
  • 2
  • 9
  • 21
0
votes
1 answer

Rewriting Queries and data layers

I was going through the following question in quora : https://www.quora.com/How-was-YouTube-programmed-in-Python The first answer here mentioned about a software named "Vitess " . It mentioned that vitess rewrites queries and so provides…
itp dusra
  • 153
  • 1
  • 5
0
votes
1 answer

Vitess on Kubernetes

I'm trying to setup Vitess on a local Kubernetes by following this. After installed vtctld and set up the web UI. I saw following error on TOPOLOGY BROWSER /etcd Error Get…
George
  • 87
  • 9
-1
votes
1 answer

Implement vitess with magento 2

Can someone please help me on how to implement a vitess with Magneto 2 Ecommerce platform? I want to do sharding Magento 2 database in the community version.
-1
votes
2 answers

Avoid table scan and use index instead in query

I am designing a new database and have noticed my queries are not scaling as well as they should be. When my aggregations involve hundreds of records I am seeing significant increases in response times. I am wondering if my query is deeply flawed or…
rmw
  • 119
  • 2
  • 10
-3
votes
1 answer

How can I use vitess on production?

I have two kubernetes cluster and I want to make master-master replication for Mysql database. As I read vitess documentation, that is convenient, but I don't know how to do that? the data is more than 500G in mysql and maybe need sharding. how can…
Hamid Shariati
  • 546
  • 6
  • 18
1 2 3
4