Vitess
Welcome
Login
Home
Solutions
How can we help you today?
Enter your search term here...
Search
Login
to submit a new ticket
Check ticket status
Knowledge base
Vitess FAQs
Getting Started: Overview
8
What is Vitess?
What are the main components of Vitess?
What is Vitess and MySQL's relationship?
How much resources (memory, CPU, disk) does Vitess use?
What is the release cycle for Vitess and the PlanetScale Vitess Operator?
View all 8
Getting Started: Compatibility
5
What versions of MySQL or MariaDB work with Vitess?
What does Vitess "is MySQL compatible" mean?
How is Vitess different from MySQL?
How is Vitess different from RDS for MySQL?
How is Vitess different from AWS Aurora for MySQL?
Getting Started: Components
8
What is vtgate and how does it work?
What is vttablet? How does it work with MySQL?
What is a keyspace?
What is vtctld?
What is vtctlclient?
View all 8
Getting Started: Topology
6
What is the topology service? How does it work?
What Topology servers can I use with Vitess?
How do I choose which topology server to use?
How do I implement Zookeeper zk2?
How do I implement etcd (etcd2)?
View all 6
Getting Started: Vschema
5
What is a VSchema?
When do I need to use a VSchema?
What is a Vindex and how does it work?
What is a primary Vindex and how does it work?
How do I create a VSchema?
Getting Started: VReplication
2
What is VReplication? How does it work?
How can I use VReplication?
Getting Started: Metrics
2
How can I monitor or get metrics from Vitess?
How do you integrate Prometheus and Vitess?
Migrating: Overview
3
Analyze queries for issues given a Vschema
How do I migrate my data to Vitess?
What is VTExplain?
Migrating: Advanced Migrations
5
How can Gh-ost be used with both sharded & unsharded keyspaces?
What is Gh-ost and how does it work?
What is Vstream and how does it work?
How do I migrate to Vitess from a hosted MySQL?
Can online migrations be done while using LegacySplit?
Migrating: Query Rewriting
4
How can tables be migrated from using auto-increment to sequences?
What special functions can Vitess handle?
How can the next ID from a Vitess Sequence be adjusted?
Is there a list of supported & unsupported queries?
Operating Vitess: Overview
4
Am I really limited to 250 GB as my tablet size? Why?
How does Vitess work with AWS, Azure, GCP?
Does Vitess only work on Kubernetes?
What are my options to run Vitess?
Operating Vitess: Configuration
6
Must the application know about the sharding scheme in Vitess?
Can I change the default database name?
How do I connect to vtgate using MySQL protocol?
Can the master/replica be pinned to one region?
Can data replication from a primary region cell be controled?
View all 6
Operating Vitess: Queries
5
Can I address a specific shard if I want to?
Can I choose between master & replica for query routing?
Can I set a session variable query timeout?
Can I increase the resource pool timeout for streaming requests?
How can I perform a full table scan without the row limit per query?
Operating Vitess: Backup and Restore
4
How do backups work in vitess?
What is XtraBackup and how does Vitess use it?
What are my options to restore in vitess?
What is the default behavior of connection pooling after a failover?
Operating Vitess: Kubernetes
3
How do I switch database technologies in Kubernetes?
How does Vitess work with Kubernetes?
How can I resize my Kubernetes storage when using Vitess?
Advanced Configurations: Components
2
How does Vitess modify parameters on tablets?
Examples of how to use Vitess components
Advanced Configurations: Vschema
3
How can you update or change your vschema?
How do you select your primary key for Vitess?
Without a Vschema how can table and schema routing work?
Advanced Configurations: VTTablet
6
Are there recommended thresholds for health statuses?
What does it mean if a vttablet is unhappy?
What are the deployment types for VTTablets?
Can vttablets start without sql_mode set to STRICT_TRANS_TABLES?
How can I change the DBA login to vttablet?
View all 6
Advanced Configurations: VTGate
2
How do you use gRPC with vtgate?
How does vtgate know which shard to route a query to?
Advanced Configurations: VReplication
3
What is semi-sync replication?
Why would I use semi-sync replication?
What is the typical replication lag in VReplication?
Advanced Configurations: Authentication and Permissions
2
How do I set up MySQL authentication in Vitess?
How do I configure user-level permissions in Vitess?
Advanced Configurations: Metrics
2
What Grafana dashboards are available?
How can I implement user-level query logging?
Advanced Configurations: Vindex
5
How do I make a CreateLookupVindex?
What is a LookupVindex and how does it work?
What is a secondary Vindex? How does it work?
Does the Primary Vindex need to match its Primary Key?
How do I create a unique index for a column in Vitess?
Sharding: Overview
5
What is resharding? How does it work?
How are shards named?
How do reparents work in Vitess?
Why do auto-increment columns not work in sharded Vitess?
What does “/0” or “-”mean?
Sharding: VReplication
1
How can Movetables be used with duplicate table names?
Sharding: Advanced
1
How can I know which shard contains a row for a table?
Proprietary: PS-Rollout and PS-Drain
3
What is ps-rollout?
How does ps-rollout work?
What is ps-drain?
PlanetScale Operator
PlanetScaleDB Operator
2
What is PlanetScaleDB Operator?
How can I access to the PlanetScaleDB Operator?
PlanetScale Operator for Vitess
1
What is the PlanetScale Operator for Vitess?
Troubleshooting
General Vitess
2
Capturing a tcpdump network trace for vtgate
Collecting information for troubleshooting
Common Errors
5
What can I do if I see a CPU increase after upgrading Vitess?
What are the steps to take after an unplanned failover?
Error: mysqld not found in any of /usr/bin/{sbin,bin,libexec}
Why is an SQL update with a primary key slow?
Error: Could not open required defaults file: /path/to/my.cnf
PlanetScaleDB Operator
1
Collecting information for support
Help Desk Software
by Freshdesk