Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CHANNEL_NAME | CHAR | 64 | null |
|
|
|||
| DESIRED_DELAY | INT | 10 | null |
|
|
|||
| PRIVILEGE_CHECKS_USER | TEXT | 65535 | √ | null |
|
|
User name for the security context of the applier. |
|
| REQUIRE_ROW_FORMAT | enum('YES', 'NO') | 3 | null |
|
|
Indicates whether the channel shall only accept row based events. |
||
| REQUIRE_TABLE_PRIMARY_KEY_CHECK | enum('STREAM', 'ON', 'OFF') | 6 | null |
|
|
Indicates what is the channel policy regarding tables having primary keys on create and alter table queries |
||
| ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_TYPE | enum('OFF', 'LOCAL', 'UUID') | 5 | null |
|
|
Indicates whether the channel will generate a new GTID for anonymous transactions. OFF means that anonymous transactions will remain anonymous. LOCAL means that anonymous transactions will be assigned a newly generated GTID based on server_uuid. UUID indicates that anonymous transactions will be assigned a newly generated GTID based on Assign_gtids_to_anonymous_transactions_value |
||
| ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_VALUE | TEXT | 65535 | √ | null |
|
|
Indicates the UUID used while generating GTIDs for anonymous transactions |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | CHANNEL_NAME |
Relationships
Close relationships within degrees of separation
