What is the workflow of MySQL Router?

The workflow of MySQL Router is as follows:

1. Accepting client connections: MySQL Router listens on a specified port and accepts incoming client connection requests.
2. Analyze connection requests: The router analyzes the client’s connection request to determine the target MySQL server the client wants to connect to.
3. Query metadata: The router queries the configured metadata to retrieve information related to the target MySQL server, such as IP address, port number, username, and password.
4. Carrying out load balancing: Based on the load balancing strategy, the router selects a suitable target MySQL server.
5. Establishing a connection with the target server: The router uses the obtained information of the target MySQL server to establish a connection with the target server.
6. Forward request: The router forwards the client’s query request to the target MySQL server.
7. Receive Response: The router receives the response from the target MySQL server.
8. The response is sent back to the client: The router sends the response from the target MySQL server back to the client.
9. Maintain connection: If the client keeps the connection, the router will continue to receive the client’s queries and repeat the above steps.

In summary, the working process of MySQL Router involves receiving client connections, parsing connection requests, querying metadata, balancing loads, establishing connections with target servers, forwarding requests, receiving responses, and returning the responses to clients.