skills.rest
gmcabrita
gmcabritaCOMMUNITY
Explore all skills by this author →
Website𝕏@gmcabritaGitHub

vitess

Guide Vitess query optimization and connection troubleshooting for sharded MySQL deployments.

6|1|Updated Nov 23, 2023
Search Tags:#performance-tuning#online-ddl#database-sharding#sql-compatibility#vitess#vtgate#vschema
One-click install
npx skills add https://github.com/gmcabrita/dotfiles --skill vitess
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: vitess
Source: https://github.com/gmcabrita/dotfiles/tree/main/.agents/skills/vitess
Command: npx skills add https://github.com/gmcabrita/dotfiles --skill vitess

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Vitess is a MySQL-compatible, cloud-native database system that helps scale large MySQL deployments using Vitess architecture (VTGate, VTTablet, VSchema, VReplication). It provides guidance to optimize queries, plan and route across shards, manage schemas and keyspaces, and troubleshoot connections in PlanetScale contexts.

Core Features & Use Cases

  • Horizontal sharding and VTGate routing to scale large datasets.
  • Query rewriting, caching, and cross-shard orchestration with VSchema.
  • Connection management, HA, online DDL, and migration workflows.
  • Use Cases: migrating to Vitess, scaling MySQL workloads, performing online schema changes, and managing multi-shard transactions.

Quick Start

Read the architecture overview and set up a Vitess test cluster to begin validating shard routing and online schema changes.

Frequently Asked Questions about vitess

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I optimize queries and manage VSchema routing in sharded MySQL deployments?▼

To optimize queries in sharded MySQL deployments, apply Vitess best practices for VSchema design, query rewriting, and cross-shard orchestration to ensure efficient routing decisions and high availability.

What is the best way to perform online DDL schema changes across a distributed MySQL database?▼

Performing online DDL schema changes across a distributed MySQL database requires utilizing Vitess online DDL workflows and migration management to apply schema updates without downtime across multi-shard environments.

How do I troubleshoot VTGate connection issues in a PlanetScale Vitess database?▼

Troubleshooting VTGate connection issues in a PlanetScale Vitess database involves applying connection management and high availability guidelines to identify routing bottlenecks and resolve cross-shard transaction failures.

Does Vitess support cross-shard transactions and standard SQL compatibility for large MySQL workloads?▼

Vitess supports cross-shard transaction patterns and maintains MySQL SQL compatibility, allowing large MySQL workloads to scale horizontally through sharded keyspaces while preserving standard query functionality.

When should I use database sharding with VTTablet instead of standard MySQL for scaling?▼

Database sharding with VTTablet should be used instead of standard MySQL when horizontal scaling is required for large datasets, necessitating VReplication and VTGate routing to manage distributed query execution.

Related Skills

Explore More Software Engineering Skills→
kanade0404kanade0404

vitess

Optimize Vitess database routing, sharding, and migration validation for MySQL-compatible clusters.

Community
Advanced
agnaldo4jagnaldo4j
1

db-migrations

Manage PostgreSQL schema lifecycles with versioned Flyway migrations and HikariCP pooling.

Community
Advanced
interflownexinterflownex
2

cloud-sql-mysql-admin

Provision and manage Google Cloud SQL for MySQL instances, databases, and users.

Community
Intermediate
rnavarychrnavarych
14

role-database:newsql-distributed

Compare 12 NewSQL and distributed SQL databases for consistency and sharding.

Community
Advanced