vitess.io/vitess@v0.16.2/examples/region_sharding/201_main_sharded.sh (about)

     1  #!/bin/bash
     2  
     3  # Copyright 2020 The Vitess Authors.
     4  #
     5  # Licensed under the Apache License, Version 2.0 (the "License");
     6  # you may not use this file except in compliance with the License.
     7  # You may obtain a copy of the License at
     8  #
     9  #     http://www.apache.org/licenses/LICENSE-2.0
    10  #
    11  # Unless required by applicable law or agreed to in writing, software
    12  # distributed under the License is distributed on an "AS IS" BASIS,
    13  # WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
    14  # See the License for the specific language governing permissions and
    15  # limitations under the License.
    16  
    17  source ../common/env.sh
    18  
    19  # apply sharding vschema
    20  vtctldclient ApplyVSchema --vschema-file main_vschema_sharded.json main || fail "Failed to apply vschema for the sharded main keyspace"
    21  
    22  # optional: create the schema needed for lookup vindex
    23  #vtctlclient ApplySchema --sql-file create_lookup_schema.sql main
    24  
    25  # create the lookup vindex
    26  vtctlclient CreateLookupVindex -- --tablet_types=PRIMARY main "$(cat lookup_vindex.json)" || fail "Failed to create lookup vindex in main keyspace"
    27  
    28  # we have to wait for replication to catch up
    29  # Can see on vttablet status page Vreplication that copy is complete
    30  sleep 5
    31  
    32  # externalize vindex
    33  vtctlclient ExternalizeVindex main.customer_region_lookup || fail "Failed to externalize customer_region_lookup vindex in the main keyspace"