MySQL Transport to VTGate 85 Two-Phase Commit 86 Isolation 86 Driver APIs 86 Configuring VTTablet 87 Configuring MySQL 87 Monitoring 87 Critical failures 87 Alertable failures 87 Repairs 185 Example Usage ..... 185 Options ..... 185 Limitations ..... 185 Options ..... 186 vttablet ..... 190 Example Usage ..... 191 Options ..... 192 VReplication ..... 201 DropSources description: User guides covering advanced configuration concepts ..... 225 Authorization ..... 226 VTTablet parameters for table ACLs ..... 226 Format of the table ACL config file ..... 226 Example .

Transport 69 MySQL Transport 70 Two-Phase Commit 70 Isolation 70 Driver APIs 71 Configuring VTTablet 71 Configuring MySQL 71 Monitoring 71 Critical failures 72 Alertable failures 72 Repairs Explaining a Query 166 VTTablet Modes 168 Managed MySQL 169 -restore_from_backup 169 Unmanaged or remote MySQL 169 Partially managed MySQL 169 Typical vttablet command line flags 170 Resources . 181 Configuring Components ..... 181 Managed MySQL ..... 181 Vitess Servers ..... 182 VTTablet ..... 183 VTGate ..... 189 Horizontal Sharding ..... 190 Preparation ..... 190 Create new

VStream Copy ..... 53 VStream Copy ..... 53 Motivation ..... 53 Architecture/Design ..... 54 VTTablet ..... 56 Componentizing TabletServer ..... 56 Introduction 56 Features 56 Multi-schema 58 Exporter 58 Config loader 59 TabletManager 59 VReplication 60 Fast vttablet state transitions 60 VTTablet with RBR mode 61 Summary 61 Pass-through DMLs 61 Autocommits 61 Sequences Real-time parameter change 62 Problem Statement 62 Proposal 62 Other options considered 62 VTTablet YAML configuration 62 Background 63 Proposed Approach 63 Detailed specification 63 Implementation

Flags 60 Caveat 61 VStream Copy 61 VStream Copy 61 Motivation 61 Architecture/Design 62 VTTablet 63 Componentizing TabletServer 63 Introduction 64 Features 64 Multi-schema 64 VTShovel 66 Exporter 66 Config loader 67 TabletManager 67 VReplication 68 Fast vttablet state transitions ..... 68 VTTablet with RBR mode ..... 69 Summary ..... 69 Pass-through DMLs ..... 69 Autocommits ..... 70 Problem Statement ..... 70 Proposal ..... 70 Other options considered ..... 70 VTTablet YAML configuration ..... 70 Background ..... 71 Proposed Approach ..... 71 Detailed specification

58 VStream Copy ..... 58 VStream Copy ..... 58 Motivation ..... 59 Architecture/Design 60 VTTablet 61 Componentizing TabletServer 61 introduction 61 Features 61 Multi-schema 61 VTShovel 63 Exporter 64 Config loader 64 TabletManager 64 VReplication 65 Fast vttablet state transitions 65 VTTablet with RBR mode 66 Summary 66 Pass-through DMLs 66 Autocommits 66 Sequences Real-time parameter change 67 Problem Statement 67 Proposal 67 Other options considered 68 VTTablet YAML configuration 68 Background 68 Proposed Approach 68 Detailed specification 69 Implementation

Call for feedback ..... 48 Online DDL Scheduler ..... 48 Overview ..... 48 OnlineDDL & VTTablet state manager ..... 48 General operations ..... 48 The scheduler ..... 48 Migration states Flags 82 Caveat 83 VStream Copy 83 VStream Copy 83 Motivation 84 Architecture/Design 85 VTTablet 86 Componentizing TabletServer 86 Introduction 86 Features 86 Multi-schema 86 VTShovel Config loader ..... 89 TabletManager ..... 89 VReplication ..... 90 Fast vttablet state transitions ..... 90 VTTablet with RBR mode ..... 91 Summary ..... 91 Pass-through DMLs ..... 91 Autocommits

Transport ..... 66 Two-Phase Commit ..... 66 Isolation ..... 66 Driver APIs ..... 67 Configuring VTTablet ..... 67 Configuring MySQL ..... 67 Monitoring ..... 67 Critical failures ..... 68 Alertable Options 175 Limitations 175 See also 175 vtgate 176 Example Usage 176 Options 176 vttablet 183 Example Usage 183 Options 184 Resources 199 Presentations and Videos 199 CNCF Webinar up read-only 204 Vitess sees the wrong tablet as master 204 User Guides 204 Concepts 204 VTTablet Configuration 205 Creating a backup 207 Restoring a backup 208 Managing backups 208 Bootstrapping

Transport 62 MySQL Transport 62 Two-Phase Commit 63 Isolation 63 Driver APIs 63 Configuring VTTablet 64 Configuring MySQL 64 Monitoring 64 Critical failures 64 Alertable failures 64 Repairs ..... 159 VTTablet Modes ..... 159 Managed MySQL ..... 159 -restore_from_backup ..... 160 Unmanaged or remote MySQL ..... 160 Partially managed MySQL ..... 160 Typical vttablet command line Vitess sees the wrong tablet as master ..... 168 User Guides ..... 168 Concepts ..... 168 VTTablet Configuration ..... 168 Creating a backup ..... 171 Restoring a backup ..... 172 Managing

vtgate big data App Vitess Vitess VITESS.IO shard n topology shard 1 vttablet mysqld master vttablet vttablet mysqld mysqld replicas big data replicas ## Marketplace Schema product pid 'vtgate: http://sougou-XPS:15001/: target: customer.-80.master, used tablet: test-200 (sougou-XPS): vttablet: rpc error: code = FailedPrecondition desc = disallowed due to rule: enforce blacklisted tables 'vtgate: http://sougou-XPS:15001/: target: customer.80-.master, used tablet: test-300 (sougou-XPS): vttablet: rpc error: code = FailedPrecondition desc = disallowed due to rule: enforce blacklisted tables

lag optimization • multi data center ## V itess Topo MySQL MySQL MySQL MySQL vttablet vttablet vttablet vttablet topology (metadata store)  vtgate vtctl application ## V itess concepts • keyspace/keyspaceId • vtctl • vttablet • vtgate • vtctld • vtworker • vtprimecache ## V itess concepts • keyspaceld vindex • unique less than 5 seconds read-only downtime ## V itess Resharding • shard0, shard1, origin master → vttablet • prepare two spare shard0, shard1 • vtgate point to origin master • multi-snapshot : data &