Hi Bryant please use SRV records whenever a failover is required. This your hosting provider should be able to give to you and always try and avoid using direct ip calls.
Potentially you could create two A records:
Then create a SRV record with priority on db1 over db2. This way you can add n-amount of additional failovers.