overprovisioned resources Merge shards and/or keyspaces Increase geo-diversity Add new cells and replicas Cool a hot tablet For read access, add replicas or split shards. For write access, split shards. Additional Tools if empty, no tracing will be done db-credentials-file string db credentials file; send SIGHUP to reload this file db-credentials-server string db credentials server type (use ‘file’ for the file implementation) ng string JSON representation of the users/passwords config. mysql_auth_static_reload_interval duration Ticker to reload credentials mysql_clientcert_auth_method string client-side authentication method

overprovisioned resources Merge shards and/or keyspaces Increase geo-diversity Add new cells and replicas Cool a hot tablet For read access, add replicas or split shards. For write access, split shards. Additional Tools if empty, no tracing will be done db-credentials-file string db credentials file; send SIGHUP to reload this file db-credentials-server string db credentials server type (use ‘file’ for the file implementation) ng string JSON representation of the users/passwords config. mysql_auth_static_reload_interval duration Ticker to reload credentials mysql_clientcert_auth_method string client-side authentication method

2. Say, a DDL is applied 3. The watcher vstream sees the DDL and 1. asks the schema engine to reload the schema, also providing the corresponding gtid position 2. notifies the tracker of a schema change # enable_hot_row_protection , enable_hot_row_protection_dry_run # Default value is same as txPool.size. maxQueueSize: 20 # hot_row_protection_max_queue_size maxGlobalQueueSize: 1000 # hot_row_protec hot_row_protection_max_global_queue_size maxConcurrency: 5 # hot_row_protection_concurrent_transactions consolidator: enable|disable|notOnMaster # enable-consolidator , enable-consolidator -replicas heartbeatIntervalMilliseconds:

Say, a DDL is applied 3. The watcher Vstream sees the DDL and 59 1. asks the schema engine to reload the schema, also providing the corresponding gtid position 2. notifies the tracker of a schema change # enable_hot_row_protection , enable_hot_row_protection_dry_run # Default value is same as txPool.size. maxQueueSize: 20 # hot_row_protection_max_queue_size maxGlobalQueueSize: 1000 # hot_row_protec hot_row_protection_max_global_queue_size maxConcurrency: 5 # hot_row_protection_concurrent_transactions consolidator: enable|disable|notOnMaster # enable-consolidator , enable-consolidator -replicas heartbeatIntervalMilliseconds:

2. Say, a DDL is applied 3. The watcher Vstream sees the DDL and 1. asks the schema engine to reload the schema, also providing the corresponding gtid position 2. notifies the tracker of a schema change # enable_hot_row_protection , enable_hot_row_protection_dry_run # Default value is same as txPool.size. maxQueueSize: 20 # hot_row_protection_max_queue_size maxGlobalQueueSize: 1000 # hot_row_protec hot_row_protection_max_global_queue_size maxConcurrency: 5 # hot_row_protection_concurrent_transactions consolidator: enable|disable|notOnMaster # enable-consolidator , enable-consolidator -replicas heartbeatIntervalMilliseconds:

2. Say, a DDL is applied 3. The watcher Vstream sees the DDL and 1. asks the schema engine to reload the schema, also providing the corresponding gtid position 2. notifies the tracker of a schema change # enable_hot_row_protection , enable_hot_row_protection_dry_run # Default value is same as txPool.size. maxQueueSize: 20 # hot_row_protection_max_queue_size maxGlobalQueueSize: 1000 # hot_row_protec hot_row_protection_max_global_queue_size maxConcurrency: 5 # hot_row_protection_concurrent_transactions consolidator: enable|disable|notOnPrimary # enable-consolidator , enable -consolidator -replicas heartbeat

overprovisioned resources Merge shards and/or keyspaces Increase geo-diversity Add new cells and replicas Cool a hot tablet For read access, add replicas or split shards. For write access, split shards. Additional Tools tablets in a keyspace. Example Flags Name Type Definition concurrency Int How many tablets to reload in parallel include_master Boolean Include the master tablet(s) Arguments • – Required tablets in a shard. Example Flags 133 Name Type Definition concurrency Int How many tablets to reload in parallel include_master Boolean Include the master tablet Arguments • – Required

overprovisioned resources Merge shards and/or keyspaces Increase geo-diversity Add new cells and replicas Cool a hot tablet For read access, add replicas or split shards. For write access, split shards. Additional Tools tablets in a keyspace. Example Flags Name Type Definition concurrency Int How many tablets to reload in parallel include_master Boolean Include the master tablet(s) Arguments • – Required tablets in a shard. Example Flags 141 Name Type Definition concurrency Int How many tablets to reload in parallel include_master Boolean Include the master tablet Arguments • – Required

Growing with Vitess Vitess app server app server app server MainDB Connection pooling Deadlines Hot row protection Row count limit Blacklisting Growing with Vitess Vitess app server app server app