convention. When sharded, a keyspace has N shards with non-overlapping data. Resharding Vitess supports dynamic resharding, in which the number of shards is changed on a live cluster. This can be either splitting one or more shards into smaller pieces, or merging neighboring shards into bigger pieces. During dynamic resharding, the data in the source shards is copied into the destination shards, allowed to catch overview of the servers and their current states. VTGate VTGate is a lightweight proxy server that routes traffic to the correct VTTablet servers and returns consolidated results back to the client. It speaks

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63 How VTGate routes a query . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . acts as the server for vtctlclient connections.— VTGate VTGate is a lightweight proxy server that routes traffic to the correct VTTablet servers and returns consolidated results back to the client. It speaks it’s converting from/to. 61 Supported character sets The list of supported character sets is dynamic and may grow. You will find it under CharacterSetEncoding in https://github. com/vitessio/vitess

overview of the servers and their current states. VTGate VTGate is a lightweight proxy server that routes traffic to the correct VTTablet servers and returns consolidated results back to the client. It speaks management GUI – Designed to work in multiple data centers / regions • Sharding – Virtually seamless dynamic re-sharding – Vertical and Horizontal sharding support – Multiple sharding schemes, with the ability view is always up-to-date and consistent for different clients. Vitess also provides a proxy that routes queries efficiently to the most appropriate MySQL instance. Vitess vs. NoSQL If you’re considering

as the server for vtctlclient connections.— ## VTGate VTGate is a lightweight proxy server that routes traffic to the correct VTTablet servers and returns consolidated results back to the client. It speaks management GUI – Designed to work in multiple data centers / regions • Sharding – Virtually seamless dynamic re-sharding – Vertical and Horizontal sharding support – Multiple sharding schemes, with the ability view is always up-to-date and consistent for different clients. Vitess also provides a proxy that routes queries efficiently to the most appropriate MySQL instance. Vitess vs. NoSQL If you’re considering

as the server for vtctlclient connections.— ## VTGate VTGate is a lightweight proxy server that routes traffic to the correct VTTablet servers and returns consolidated results back to the client. It speaks this would make it very hard for monitoring tools because they are not very good at dealing with dynamic variable names. HTTP endpoints A TabletServer exports a variety of http endpoints. In general, management GUI – Designed to work in multiple data centers / regions • Sharding – Virtually seamless dynamic re-sharding – Vertical and Horizontal sharding support – Multiple sharding schemes, with the ability

as the server for vtctlclient connections.— ## VTGate VTGate is a lightweight proxy server that routes traffic to the correct VTTablet servers and returns consolidated results back to the client. It speaks this would make it very hard for monitoring tools because they are not very good at dealing with dynamic variable names. HTTP endpoints A TabletServer exports a variety of http endpoints. In general, management GUI – Designed to work in multiple data centers / regions • Sharding – Virtually seamless dynamic re-sharding – Vertical and Horizontal sharding support – Multiple sharding schemes, with the ability

as the server for vtctlclient connections.— ## VTGate VTGate is a lightweight proxy server that routes traffic to the correct VTTablet servers and returns consolidated results back to the client. It speaks this would make it very hard for monitoring tools because they are not very good at dealing with dynamic variable names. 62 HTTP endpoints A TabletServer exports a variety of http endpoints. In general management GUI – Designed to work in multiple data centers / regions • Sharding – Virtually seamless dynamic re-sharding – Vertical and Horizontal sharding support – Multiple sharding schemes, with the ability

as the server for vtctlclient connections.— ## VTGate VTGate is a lightweight proxy server that routes traffic to the correct VTTablet servers and returns consolidated results back to the client. It speaks management GUI – Designed to work in multiple data centers / regions • Sharding – Virtually seamless dynamic re-sharding – Vertical and Horizontal sharding support – Multiple sharding schemes, with the ability view is always up-to-date and consistent for different clients. Vitess also provides a proxy that routes queries efficiently to the most appropriate MySQL instance. Vitess vs. NoSQL If you’re considering

middleware at the http mux layer. VTAdmin-api does this in vitess/go/vt/vtadmin/api.go, when the routes are initialized: First VTAdmin-api checks if the user has registered an authentication plugin:

defers • generics • GC • map, slices • performace • java < go < c/c++ Vitess Features • dynamic resharding • auto-failover • row-cache • limit inefficiency SQL • more client connection • Structure Vitess Resharding • read scaling up ? —> replica • write scale up ? —> split • dynamic shard • scale • less than 5 seconds read-only downtime Vitess Resharding • shard0, shard1