Vitess

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?