Shouldnt you use SRV records instead of A records ?
When multiple MySQL instances provide the same service for your applications, DNS SRV records can be used to provide failover, load balancing, and replication services. They eliminate the need for clients to identify each possible host in the connection string, or for connections to be handled by an additional software component.
https://docs.oracle.com/cd/E17952_01/connector-j-8.0-en/connector-j-reference-dns-srv.html
See below how: