Are the three transparent distributed features mutually exclusive? Can I use the features together?
The transparent distribution features are not mutually exclusive and can be used together. For example, the manual partitioning feature can be used together with the non-partitioned table sharding or automatic partitioning feature.
What is the default partitioning scheme for the transparent distributed automatic partitioning feature?
If you use the automatic partitioning feature and do not specify the partition key in the SQL statement for creating a table, PolarDB-X uses the primary key and KEY partitioning to perform the default partitioning scheme. If no primary key is specified, the implicit primary key is used. The default number of partitions = The number of logical nodes when the instance is created × 8. For example, if the number of logical nodes is 2 when a PolarDB-X instance is created, the default number of partitions is 16.
After I use the transparent distributed non-partitioned table sharding feature, will non-partitioned tables be sharded to newly added data nodes?
Yes. After a new data node is added, PolarDB-X automatically migrates some non-partitioned tables to the new data node to balance loads.