Shulou(Shulou.com)05/31 Report--

This article will explain in detail what the nine attributes of the Mycat logic table tag are. The content of the article is of high quality. Therefore, Xiaobian shares it with you as a reference. I hope that after reading this article, you will have a certain understanding of relevant knowledge.

Mycat logical table table is the table corresponding to Mysql, and the table tag is the child tag of the schema.

The table tag has nine attributes:

(1).name: table name corresponding to Mysql

(2).dataNode: The fragment where the logical table is located. The attribute value needs to correspond to the name attribute of the dataNode tag. The dateNode tag will be explained below.

(3).rule: The name of the fragmentation rule used by the logical table. The rule is configured in conf/rule.xml. The attribute value must correspond to the name attribute in the tableRule tag.

(4).ruleRequired: Whether to bind fragmentation rules. If true, rule must be configured.

(5).primaryKey: Primary key of logical table corresponding to real table

(6).type: logical table type, divided into global table and ordinary table, later write an example to explain this attribute in detail

(7).autoIncrement: whether to enable self-incrementing PK, corresponding to Mysql self-incrementing PK, disabled by default

(8).subTable: subtable, supported after 1.6

(9).needAddLimit: Whether to allow automatic addition of limit set in schema tag, default is true

About Mycat logic table tag nine attributes are what to share here, I hope the above content can have some help to everyone, you can learn more knowledge. If you think the article is good, you can share it so that more people can see it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.