AFAICT, what we'll get with FlexClone is a read-write snapshot -- which is fine --, but the real question is about service migration between two copies : let's suppose we have a dev and a production database ; how would we migrate the service (e.g. a MySQL server) between the two?
I think you might have to be a bit more clear about what you're hoping to accomplish and what your current setup is. How are you hosting your mysql data files? NFS, iscsi, fcp?
It sounds like you want to base a dev database off of a snapshot of a prod database (which is pretty normal) but then you want to eventually make the dev database the new prod database? and you're wondering how to make the server see the the new prod database on the flexclone volume? Is that an accurate summation?
We're mostly an oracle shop but I think in principle it's very similar. If you use nfs you'll just export and mount up the new prod volume to the prod server and point mysql at those datafiles and start it up. If you're using iscsi or fcp, you'll unmap the old lun{s} and then map the new prod lun to the server and mount them up, etc...