vitess.io/vitess@v0.16.2/examples/region_sharding/README.md (about)

     1  # Instructions
     2  
     3  Detailed instructions for running this example can be found at https://vitess.io.
     4  This document contains the summary of the commands to be run.
     5  
     6  
     7  ```
     8  # setup environment and aliases
     9  source ../common/env.sh
    10  
    11  # Bring up initial cluster and main keyspace (unsharded)
    12  ./101_initial_cluster.sh
    13  
    14  # Insert and verify data
    15  mysql < insert_customers.sql
    16  mysql --table < show_initial_data.sql
    17  
    18  # create schema and vschema for sharding (+lookup vindex)
    19  ./201_main_sharded.sh
    20  
    21  # bring up shards and tablets
    22  ./202_new_tablets.sh
    23  
    24  # reshard
    25  ./203_reshard.sh
    26  
    27  # SwitchReads
    28  ./204_switch_reads.sh
    29  
    30  # run script to create traffic before switching writes
    31  #./client.sh
    32  
    33  # SwitchWrites
    34  ./205_switch_writes.sh
    35  # show no / minimal write errors during switch
    36  
    37  # verify sharded data
    38  mysql --table < show_data.sql
    39  
    40  # down shard
    41  ./206_down_shard_0.sh
    42  
    43  # delete shard 0
    44  ./207_delete_shard_0.sh
    45  
    46  # Down cluster
    47  ./301_teardown.sh
    48  ```