Vertical and Horizontal sharding support – Multiple sharding schemes, with the ability to plug-in custom ones Comparisons to other storage options The following sections compare Vitess to two common alternatives including master failover and data backups. 45 Vanilla MySQL Vitess A MySQL cluster can have custom database configurations for different workloads, like a master database for writes, fast read-only not usually support transactions. Vitess supports transactions. NoSQL solutions have custom APIs, leading to custom architectures, applications, and tools. Vitess adds very little variance to MySQL, a

Vertical and Horizontal sharding support – Multiple sharding schemes, with the ability to plug-in custom ones Comparisons to other storage options The following sections compare Vitess to two common alternatives including master failover and data backups. 57 Vanilla MySQL Vitess A MySQL cluster can have custom database configurations for different workloads, like a master database for writes, fast read-only not usually support transactions. Vitess supports transactions. NoSQL solutions have custom APIs, leading to custom architectures, applications, and tools. Vitess adds very little variance to MySQL, a

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47 Illustrating custom DROP workaround steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . transparent to the user as much as possible. Breakdown of the suggested solution follows. Illustrating custom DROP workaround steps We can make the DROP management stateful or stateless. Opting for stateless: Vertical and Horizontal sharding support – Multiple sharding schemes, with the ability to plug-in custom ones Comparisons to other storage options The following sections compare Vitess to two common alternatives

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 Illustrating custom DROP workaround steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124 Custom metrics & queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . transparent to the user as much as possible. Breakdown of the suggested solution follows. Illustrating custom DROP workaround steps We can make the DROP management stateful or stateless. Opting for stateless:

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49 Illustrating custom DROP workaround steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113 Custom metrics & queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . transparent to the user as much as possible. Breakdown of the suggested solution follows. Illustrating custom DROP workaround steps We can make the DROP management stateful or stateless. Opting for stateless:

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Illustrating custom DROP workaround steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 148 Custom metrics & queries . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . transparent to the user as much as possible. Breakdown of the suggested solution follows. Illustrating custom DROP workaround steps We can make the DROP management stateful or stateless. Opting for stateless:

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 75 Custom Sharding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Vertical and Horizontal sharding support – Multiple sharding schemes, with the ability to plug-in custom ones Comparisons to other storage options The following sections compare Vitess to two common alternatives handles various scenarios, including master failover and data backups. A MySQL cluster can have custom database configurations for different workloads, like a master database for writes, fast read-only

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80 Custom Sharding . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . Vitess are plugins. If none of the predefined vindexes suit your needs, you can develop your own custom vindex. Now that we have made all the important decisions, it’s time to apply these changes: helm Vertical and Horizontal sharding support – Multiple sharding schemes, with the ability to plug-in custom ones Comparisons to other storage options The following sections compare Vitess to two common alternatives