VSchema and Query Serving

Configuring VSchema for serving queries

• Overview
• Sharding Guidelines
• Unsharded Keyspace
• Sharded Keyspace
• Sequences
• Shared Vindexes and Foreign Keys
• Unique Lookup Vindexes
• Non-Unique Lookup Vindexes
• Lookup as Primary Vindex
• Backfill Lookup Vindexes
• More...

Running in Production

Instructions and guidelines for running Vitess in a production environment

• Collations and Character sets
• Planning
• Global TopoServer
• vtctld
• Creating a cell
• Keyspaces and Shards
• VTOrc
• VTTablet and MySQL
• Initialize Shard Primary
• Durability Policy
• More...

Migration

User guides covering migration to Vitess

• Migrating data into Vitess
• MoveTables
• Materialize
• Cutover Steps and Troubleshooting

SQL Statement Analysis

User guides covering analyzing SQL statements

• Analyzing a SQL statement using EXPLAIN FORMAT=vtexplain
• Analyzing a SQL statement using VTEXPLAIN
• Analyzing SQL statements in bulk using VTEXPLAIN

Advanced Configuration

User guides covering advanced configuration concepts

• User Management and Authentication
• VTGate Buffering Scenarios
• LDAP authentication
• Authorization
• Resharding
• Integration with Orchestrator
• Reparenting
• Region-based Sharding
• CreateLookupVindex
• Comment Directives
• More...

Operational

User guides covering operational aspects of Vitess

• Backup and Restore
• Upgrading Vitess

Making Schema Changes

• Unmanaged Schema Changes
• Managed, Online Schema Changes
• Online DDL strategies
• ddl_strategy flags
• Table lifecycle
• Applying, auditing, and controlling Online DDL
• Declarative migrations
• Postponed migrations
• Recoverable, failover agnostic migrations
• Revertible migrations
• More...