Autofs and mysql

I think you are trying to overthink the whole thing. When you scan to the library it records the path where it found the files. If you are sharing this database with more than one machine then all the machines must be able to access this exact same address, or use path substitution to act a a forwarding address. All the path substitution is doing is saying when you looking for X location then substitute this Y location in its place.