Documentation ## Contents Concepts ..... 18 Cell ..... 18 Execution Plans ..... 18 Keyspace ID ..... 19 Keyspace ..... 19 MoveTables ..... 19 Identifying Candidate Tables ..... 19 Query Rewriting additional FAQs? ..... 68 Helm Chart (deprecated) ..... 68 Prerequisites ..... 68 Start a single keyspace cluster ..... 69 Setup Port-forward ..... 70 Next Steps ..... 71 Local Install via Docker etcd ..... 73 Disable AppArmor or SELinux ..... 73 Install Vitess ..... 73 Start a Single Keyspace Cluster ..... 74 Setup Aliases ..... 75 Connect to your cluster ..... 75 Summary ..... 76

action ..... 9 Concepts ..... 9 Cell ..... 9 Keyspace Graph ..... 9 Partitions ..... 9 Served From ..... 9 Keyspace ID ..... 10 Keyspace ..... 10 Replication Graph ..... 10 Shard .... Primary Key? ..... 24 Get Started ..... 24 Run Vitess on Kubernetes ..... 24 Start a single keyspace cluster ..... 25 Vertical Split ..... 27 Horizontal sharding ..... 32 Run Vitess Locally .. etcd ..... 38 Disable AppArmor or SELinux ..... 39 Install Vitess ..... 39 Start a Single Keyspace Cluster ..... 39 Connect to Your Cluster ..... 40 Summary ..... 41 Next Steps ..... 42 Overview

Documentation ## Contents Concepts ..... 20 Cell ..... 20 Execution Plans ..... 20 Keyspace ID ..... 21 Keyspace ..... 21 MoveTables ..... 21 Identifying Candidate Tables ..... 21 Query Rewriting a single keyspace cluster ..... 77 Setup Port-forward ..... 78 Next Steps ..... 79 Local Install via Homebrew ..... 79 Install Vitess with Homebrew ..... 79 Start a Single Keyspace Cluster . etcd ..... 85 Disable AppArmor or SELinux ..... 85 Install Vitess ..... 86 Start a Single Keyspace Cluster ..... 86 Setup Aliases ..... 87 Connect to your cluster ..... 87 Summary ..... 88

action ..... 9 Concepts ..... 10 Cell ..... 10 Keyspace Graph ..... 10 Partitions ..... 10 Served From ..... 10 Keyspace ID ..... 11 Keyspace ..... 11 MoveTables ..... 11 Identifying Candidate as its Primary Key? 27 Get Started ..... 27 Run Vitess on Kubernetes ..... 28 Start a single keyspace cluster ..... 28 Setup Aliases ..... 29 Next Steps ..... 30 Install MySQL and etcd ..... 31 31 Disable AppArmor or SELinux ..... 31 Install Vitess ..... 31 Start a Single Keyspace Cluster ..... 32 Setup Aliases ..... 33 Connect to your cluster ..... 33 Summary ..... 34 Next Steps

11 Cell ..... 11 Execution Plans ..... 11 Keyspace Graph ..... 11 Partitions ..... 12 Served From ..... 12 Keyspace ID ..... 12 Keyspace ..... 12 MoveTables ..... 12 Identifying Candidate Get Started ..... 29 Helm Chart (deprecated) ..... 29 Prerequisites ..... 29 Start a single keyspace cluster ..... 30 Setup Port-forward ..... 31 Next Steps ..... 32 Local Install via Docker . etcd ..... 34 Disable AppArmor or SELinux ..... 34 Install Vitess ..... 34 Start a Single Keyspace Cluster ..... 35 Setup Aliases ..... 36 Connect to your cluster ..... 36 Summary ..... 37

## Concepts ## Contents Cell ..... 19 Execution Plans ..... 19 Keyspace ID ..... 20 Keyspace ..... 20 MoveTables ..... 20 Identifying Candidate Tables ..... 20 Query Rewriting ..... 20 a single keyspace cluster ..... 74 Setup Port-forward ..... 75 Next Steps ..... 76 Local Install via Homebrew ..... 76 Install Vitess with Homebrew ..... 77 Start a Single Keyspace Cluster . etcd ..... 82 Disable AppArmor or SELinux ..... 83 Install Vitess ..... 83 Start a Single Keyspace Cluster ..... 83 Setup Aliases ..... 84 Connect to your cluster ..... 84 Summary ..... 85

just inserted ..... 18 Concepts ..... 19 Cell ..... 19 Execution Plans ..... 19 Keyspace ID ..... 20 Keyspace ..... 20 MoveTables ..... 20 Identifying Candidate Tables ..... 20 Query Rewriting Primary Key? .41 Get Started .41 Helm Chart (deprecated) .41 Prerequisites .41 Start a single keyspace cluster .42 Setup Port-forward .43 Next Steps .44 Local Install via Docker .44 Check out Install MySQL and etcd .46 Disable AppArmor or SELinux .46 Install Vitess .46 Start a Single Keyspace Cluster .47 Setup Aliases .48 Connect to your cluster .48 Summary .49 Next Steps .49 Vitess

Documentation ## Contents Concepts ..... 22 Cell ..... 22 Execution Plans ..... 23 Keyspace ID ..... 23 Keyspace ..... 23 MoveTables ..... 23 Identifying Candidate Tables ..... 24 Query Rewriting 98 Local Install via Homebrew ..... 99 Install Vitess with Homebrew ..... 99 Start a Single Keyspace Cluster ..... 99 Setup Aliases ..... 101 Connect to your cluster ..... 101 Summary ..... 102 etcd ..... 104 Disable AppArmor or SELinux ..... 105 Install Vitess ..... 105 Start a Single Keyspace Cluster ..... 105 Setup Aliases ..... 107 Connect to your cluster ..... 107 Summary .....

Software 1 Install the Software 1 Start the Cassandra Server 1 Login to Cassandra 1 Create a Keyspace (database) 1 Create a Column Family 2 Insert, Update, Delete, Read Data 2 Getting Started Partitioner Settings 25 Snitch Settings 26 Configuring the PropertyFileSnitch 26 Choosing Keyspace Replication Options 27 Installing and Initializing a Cassandra Cluster 27 Installing Cassandra Client API 61 PHP: Phpcassa Client API 61 Getting Started Using the Cassandra CLI 61 Creating a Keyspace 62 Creating a Column Family 62 Creating a Counter Column Family 63 Inserting Rows and Columns

HELP PAGING SHOW TRACING ## CQL help topics: |AGGREGATES|CREATE\_KEYSPACE|DROP\_TRIGGER|TEXT| |---|---|---|---| |ALTER\_KEYSPACE|CREATE\_MATERIALIZED\_VIEW|DROP\_TYPE|TIME| |ALTER\_MATERIALIZED\_VI |BOOLEAN|DROP\_FUNCTION|LIST\_ROLES|| |COUNTER|DROP\_INDEX|LIST\_USERS|| |CREATE\_AGGREGATE|DROP\_KEYSPACE|PERMISSIONS|| |CREATE\_COLUMNFAMILY|DROP\_MATERIALIZED\_VIEW|REVOKE|| |CREATE\_FUNCTION|DROP\_ROLE|SELECT|| cqlsh 创建 keyspace Cassandra 里面的 keyspace 和关系型数据库里面的 database 概念类似的，一个 keyspace 可以包含一个或多个 tables 或 column families。当我们启动 cqlsh 时没有指定 keyspace，那么命令提示符为 cqlsh>，我们可以使用 CREATE KEYSPACE 命令来创建 keyspace，具体如下：