Database Discovery Algorithm #
MySQL MGR Database Discovery Algorithm #
Type: MySQL.MGR
Configurable Properties:
| Property name | Data type | Description |
|---|---|---|
| group-name | String | MySQL MGR group name |
Notes:
You should query the MGR environment and the primary-replica relationship of the instances to get access to MySQL information_schema and performance_schema system libraries. GRANT REPLICATION SLAVE, REPLICATION CLIENT ON . TO ‘username’@’localhost’;
It is recommended that the report_host and report_port parameters in the my.cnf file be consistent with that of the JDBC URL due to the need to dynamically discover the primary-replica topology relationship and that the primary node in MGR requires matching the IP and PORT in JDBC URL of the storage unit.
report_host = mysql_4
report_port = 3306
MySQL Primary-replica Database Discovery Algorithm #
Type: MySQL.NORMAL_REPLICATION
Configurable Properties:
| Property name | Data type | Description |
|---|---|---|
| delay-milliseconds-threshold | int | The slave database delay threshold, when the slave database is greater than or equal to the threshold, it is automatically disabled |
| min-enabled-replicas | int | The minimum number of disabled, at least n salve database |
Note: Database users with SELECT access can use this algorithm. No special permissions are required.
openGauss Primary-replica Database Discovery Algorithm #
Type: openGauss.NORMAL_REPLICATION
Configurable Properties: None
Note: Database users with SELECT access can use this algorithm. No special permissions are required.
PostgreSQL Primary-replica Database Discovery Algorithm #
Type: SphereEx:PostgreSQL.NORMAL_REPLICATION
Configurable Properties: None
Note: Database users with SELECT access can use this algorithm. No special permissions are required.
GaussDB_for_MySQL Master-slave Database Discovery Algorithm #
Type: SphereEx:GaussDB_for_MySQL.NORMAL_REPLICATION
Configurable Properties: None
Note: Database users with SELECT access can use this algorithm. No special permissions are required.
Aurora_for_MySQL Primary-replica Database Discovery Algorithm #
Type: SphereEx:Aurora_for_MySQL.NORMAL_REPLICATION
Configurable Properties: None
Note: Database users with SELECT access can use this algorithm. No special permissions are required.