ssougou.blogspot.com Vitess@GoSV What is Vitess ● Sharding middleware for MySQL ● Massively scalable ● HA ● Cloud-native pxhere CC0 Vitess stats Started 2010 7,500+ stars 16,000+ commits Marquee adopters

1 VITESS.IO What is Vitess? Cloud Native Database Massively Scalable HA Based on MySQL 2 3 VITESS.IO Vitess Stats Started 2010 Marquee Adopters 100+ Contributors 17,000 + Commits 1000+

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 45 SQL Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . different modes. In OLTP mode, the result size is typically limited to a preset number (10 000 rows by default). This limit can be adjusted based on your needs. However, OLAP mode has no limit to the number returned. In order to change to this mode, you may issue the following command before executing your query: set workload='olap' You can also set the workload to dba mode, which allows you to override the

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 SQL Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . different modes. In OLTP mode, the result size is typically limited to a preset number (10 000 rows by default). This limit can be adjusted based on your needs. However, OLAP mode has no limit to the number returned. In order to change to this mode, you may issue the following command before executing your query: set workload='olap' 23 You can also set the workload to dba mode, which allows you to override the

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 SQL Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . different modes. In OLTP mode, the result size is typically limited to a preset number (10 000 rows by default). This limit can be adjusted based on your needs. However, OLAP mode has no limit to the number returned. In order to change to this mode, you may issue the following command before executing your query: set workload='olap' You can also set the workload to dba mode, which allows you to override the

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 106 SQL Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 328 vtexplain -shards 8 -vschema-file vschema.json -schema-file schema.sql -replication-mode “ROW” -output-mode text -sql “SELECT * from users” . . . . . . . . . . . . . . . . . . . . . . . . . . . . tx_read_only VitessAware transaction_read_only VitessAware sql_select_limit VitessAware transaction_mode VitessAware workload VitessAware charset VitessAware names VitessAware big_tables NoOp bulk_insert_buffer_size

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90 VTTablet with RBR mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121 SQL Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . -vschema-file vschema.json -schema-file schema.sql -ks-shard-map shardmaps.json -replication-mode “ROW” -output-mode text -sql “SELECT FROM users; SELECT FROM users WHERE id IN (10, 17, 42, 1000);” . . . 511

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 VTTablet with RBR mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 SQL Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 391 vtexplain -shards 8 -vschema-file vschema.json -schema-file schema.sql -replication-mode “ROW” -output-mode text -sql “SELECT * from users” . . . . . . . . . . . . . . . . . . . . . . . . . . . .

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 68 VTTablet with RBR mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 102 SQL Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . tx_read_only VitessAware transaction_read_only VitessAware sql_select_limit VitessAware transaction_mode VitessAware workload VitessAware charset VitessAware names VitessAware big_tables NoOp bulk_insert_buffer_size

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 VTTablet with RBR mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97 SQL Mode . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 428 vtexplain -shards 8 -vschema-file vschema.json -schema-file schema.sql -replication-mode “ROW” -output-mode text -sql “SELECT * from users” . . . . . . . . . . . . . . . . . . . . . . . . . . . .