Stack Overflow
Stack Overflow

Questions tagged [vitess]

Vitess is a database clustering system for horizontal scaling of MySQL

Reference:

57 questions
1
vote
1 answer

Would mysql with sharding (Vitess) be faster than any no SQL database?

I have been trying to understand why nosql db is considered to be faster than RDBMS. I understand that nosql dbs don't follow the ACID properties but instead follows BASE principle which is the reason why nosql is able to horizontally scale. What I…
Ajitesh Singh
  • 401
  • 2
  • 5
  • 14
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
1
vote
1 answer

How can I shard MySQL database with Vitess using both Docker images?

I found out about Vitess which let you shard MySQL database. I want to use the docker image of both MariaDB and Vitess but I'm not quite sure what to do next. I'm using CentOS 7. I installed the images docker pull mariadb docker pull…
Jayd
  • 183
  • 3
  • 15
1
vote
1 answer

Getting error while trying to merge shards using vitess

I have sharded a single table from a single shard(0) into two shards(-80 and 80-). After sharding I deleted the shard 0, its tablets and recreated the shard 0 again. I am trying to merge shards -80 and 80- to 0 but getting the following error while…
manojadams
  • 2,314
  • 3
  • 26
  • 30
1
vote
1 answer

Connect java application to YouTube Vitess database

I deployed my java web application in kubernetes using DEPLOYMENTS and was able to scale it and connect it to a database POD, but then I wanted to scale the database too but as you know is not possible in kubernetes and the MYSQL REPLICA not…
montatich
  • 199
  • 1
  • 2
  • 14
0
votes
0 answers

Unable to install vitess using vitess operator on red hat openshift server

I tried to install vitess on vanilla kubernetes and I am able to install it successfully. I tried the same using open shift red hat server but i have encountered the below error. What are the specific configurations required to install the same? I…
Murali Mohan Murthy Potham
  • 77
  • 1
  • 5
0
votes
0 answers

How to import data to vitess

I'm new in Vitess. I've exported my database from MySQL Workbench to file mydatabase.sql. I've already downloaded docker and vitess, but now I'm trying to import those file into vitess and i don't know how to do it? I was trying to import the…
vittesio
  • 1
  • 1
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
0
votes
0 answers

Inconsistent result when bitwise AND an inversed value on MySQL (PlanetScale/Vitess)

I have a SET column that has 10 values, and I'm querying against a specific row that has 2nd and 10th values set, therefore, it's 514 (1000000010). Now, I encounter an issue that, the result is different whether SET is involved. SELECT b'1000000010'…
Ren
  • 79
  • 7
0
votes
0 answers

(MySQLdb.NotSupportedError) (1235, 'charset/name utf8mb3 is not supported') using sqlalchemy and planetscale

I am trying to connect to my database on planetscale with sqlalchemy, but it gives me this error: Exception has occurred: NotSupportedError (MySQLdb.NotSupportedError) (1235, 'charset/name utf8mb3 is not supported') (Background on this error at:…
artyomkulimov
  • 1
  • 3
0
votes
1 answer

Vitess v8 PlanetScale MySQL db constraint error

Using Vitess v8 (PlanetScale DB) Table: CREATE TABLE `Channel` ( `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT, `guildId` INTEGER UNSIGNED NOT NULL, `name` VARCHAR(64) NOT NULL, `description` TEXT NULL, `createdAt` DATETIME(3)…
Average Capitalist
  • 33
  • 1
  • 4
0
votes
1 answer

How to select data depending on data from the same table with custom field in SELECT?

I have a query to fetch closest airports to the airport: SELECT *, ( 6371 * acos(cos(radians(55.966324)) * cos(radians(latitude)) * cos(radians(longitude) - radians(37.416573)) + sin(radians(55.966324)) * sin(radians(latitude))) ) AS…
JamesJGoodwin
  • 350
  • 1
  • 3
  • 17
0
votes
0 answers

Is it possible to use Prisma with Vitess

I heard recently about how Planetscale which uses Vitess can be used with Prisma. At the moment I am using Postgres but would like to try out Vitess if possible. Some of my searches found that Prisma is tested against Vitess…
Paul Smith
  • 3
  • 1
0
votes
1 answer

Vitess table equivalence configuration

We are trying to use table equivalence feature in vitess 9.0.0 as described here . We have sharded and unsharded keyspaces. Tables from the unsharded keyspace are copied as reference tables to the sharded one using Materialize workflow. The…
Alexander Potapenko
  • 1
  • 1
0
votes
0 answers

Creating and managing a large number of client-defined databases

I'm contemplating a multi-tenant SaaS application wherein each client would have its own allocated database with its own client-defined schema. None of the underlying clients would have a large scale of data by themselves (likely in range of 1M rows…
Andrew
  • 3,901
  • 15
  • 50
  • 64
1 2
3
4