Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| Channel_name | CHAR | 64 | null |
|
|
The replication channel name that connects source and replica. |
||
| Host | CHAR | 255 | null |
|
|
The source hostname that the replica will attempt to switch over the replication connection to in case of a failure. |
||
| Port | INT UNSIGNED | 10 | null |
|
|
The source port that the replica will attempt to switch over the replication connection to in case of a failure. |
||
| Network_namespace | CHAR | 64 | null |
|
|
The source network namespace that the replica will attempt to switch over the replication connection to in case of a failure. If its value is empty, connections use the default (global) namespace. |
||
| Weight | TINYINT UNSIGNED | 3 | null |
|
|
The order in which the replica shall try to switch the connection over to when there are failures. Weight can be set to a number between 1 and 100, where 100 is the highest weight and 1 the lowest. |
||
| Managed_name | CHAR | 64 |
|
|
The name of the group which this server belongs to. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc/Asc/Asc/Asc | Channel_name + Host + Port + Network_namespace + Managed_name |
| Channel_name | Performance | Asc/Asc | Channel_name + Managed_name |
Relationships
Close relationships within degrees of separation
