Create and manage Spanner Omni database split points

This document describes how to create and manage splits in your Spanner Omni database to prepare for increased traffic. This process is mostly identical to creating and managing Spanner split points, with the following distinctions:

• To add manual splits to your Spanner Omni database, use the following command:

  spannerdatabasessplitsaddDATABASE_ID\
  --splits-file=FILE_PATH\
  [--split-expiration-time=DATE]
  

  Replace the following:

  • DATABASE_ID: the database identifier—for example, MY_DATABASE.

  • FILE_PATH: the path to the file containing the split point definitions—for example, /home/user/project/spanner/manual_splits.txt.

  • DATE: optional, the date after which the splits expire. Accepts timestamp values and relative time values—for example, 2072年09月27日T12:30:00.45Z or now+7d.

• To view the manual split points in your Spanner Omni database, use the following command:

  spannersql\
  --databaseDATABASE_ID--execute\
  "SELECT * \
  FROM SPANNER_SYS.USER_SPLIT_POINTS"