The mysql service connectivity check is similar to haproxy option mysql-check, and is used for local
mysql service check. A simple mysql-check uses a user with minimal USAGE privilege and the user may or may not have a password. In our company production, we use haproxy option mysql-check for synapse side service health check, however it does not work with a new db proxy service that we build, and the nerve tcp port health check on the local server is not sufficient. The simple mysql service check borrows the idea of haproxy option mysql-check but it uses mysql client and therefore works with the new proxy. It had been verified in our production test environment.
The mysql service connectivity check is similar to haproxy option mysql-check, and is used for local mysql service check. A simple mysql-check uses a user with minimal USAGE privilege and the user may or may not have a password. In our company production, we use haproxy option mysql-check for synapse side service health check, however it does not work with a new db proxy service that we build, and the nerve tcp port health check on the local server is not sufficient. The simple mysql service check borrows the idea of haproxy option mysql-check but it uses mysql client and therefore works with the new proxy. It had been verified in our production test environment.
@igor47