Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Channel_name | CHAR | 64 | null |
|
|
The replication channel name that connects source and replica. |
||
| Managed_name | CHAR | 64 |
|
|
The name of the source which needs to be managed. |
|||
| Managed_type | CHAR | 64 |
|
|
Determines the managed type. |
|||
| Configuration | JSON | 1073741824 | √ | null |
|
|
The data to help manage group. For Managed_type = GroupReplication, Configuration value should contain {“Primary_weight”: 80, “Secondary_weight”: 60}, so that it assigns weight=80 to PRIMARY of the group, and weight=60 for rest of the members in mysql.replication_asynchronous_connection_failover table. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc | Channel_name + Managed_name |
Relationships
Close relationships within degrees of separation
