A database consists of many tables, and each table corresponds to a different business. Vertical sharding is to classify tables according to business features and distribute them to different databases.
A non-sharded table is used to store tables that do not need sharding. All data of this table is stored in the first physical shard, and all tables of this type are placed in the first physical shard, with exact the same syntax and usage methods as MySQL. You can consider it as a non-distributed table.
A sharded table means that the original table with enormous amount of data needs to be split to multiple database nodes, so that each physical shard carries some of the data and all the physical shards provide the complete data.
TDSQL performs sharding by executing a modulo operation on the shardkey.
TencentDB for TDSQL is a distributed database service deployed in Tencent Cloud that supports automatic sharding (horizontal sharding) and the Shared Nothing architecture. With a distributed database, your business obtains a complete logical database table which is split and distributed evenly across multiple physical shard nodes on the backend. TDSQL deploys the master-slave architecture by default and provides a full set of solutions for disaster recovery, backup, restoration, monitoring, and migration, making it ideal for storing terabytes to petabytes of data.
Broadcast tables are based on small table broadcasting technology. If a table is set as broadcast table, all operations made to this table will be broadcast to all physical shards, and each shard possesses all data of the table.
As the main application of data warehouse systems, On-Line Analytical Processing (OLAP) supports complex analysis operations, focuses on decision support, and provides intuitive query results.
On-Line Transaction Processing (OLTP), as the main application of traditional relational database, is mainly used to process basic and daily transactions, such as bank transactions.
Percona is fully compatible with MySQL protocol and has a significant improvement in feature and performance over MySQL. Now, TDSQL supports Percona 5.7.
With Tproxy, TDSQL achieves automatic database and table sharding, manages the underlying physical database instances, and provides a unique service port compatible with MySQL databases.
Strong sync is a MySQL-based multi-thread asynchronous replication program.
Globally unique digital sequence is "sequence" for short. A sequence contains 8 bytes in the unsigned long type. Now, TDSQL can guarantee the global uniqueness and increment of this field.
According to certain rules, the data of a table is split across multiple physically independent database servers to form a "separate" database "shard". Multiple shards together form a logically complete database instance.
Data Manipulation Language (DML), with the commands of SELECT, UPDATE, INSERT and DELETE.
Data Definition Language (DDL), with the main commands of CREATE, ALTER and DROP.
See TencentDB for TDSQL.