Need playbook values from mysql (or other external source)

[Gabriel Forster]

I have a set of servers to migrate to new hosts. We want to keep a specific nfs mounted volume from the old host and apply the same volume with the same IP to the new host. These values are stored in mysql as well as, obviously, the old host.  Currently, this is being done manually.

Is there a straightforward way to do this in Ansible? I suppose I could go to all of the current hosts and store those values in a text file somewhere and use the lookup feature, but that seems counter productive. I'm hoping for a better solution.  Thanks!