MultiSubnetFailover=true for DBMSes besides SQL Server
MultiSubnetFailover can be used only for connecting to SQL Server part of the client connection string.
For MySQL, if you are using .NET, then you can use multiple hosts in connection string or you can even use single DNS that provide DNS Service (SRV) records to provide failover, load balancing, and replication services.