Mysqldump with ansible for database backup
I am really sorry to post this one. AS i later realized, this was more of a ansible solutions i was looking for rather than mysqldump. 

I tried many alternatives and finally this one worked for me. 


What this playbook does is, it on the first part takes the database backup using mysqldump and creates the backup in remote_server.

In the later part, it copies the backup from the remote_server to local server(the one hosting the ansible) with fetch command to local directory.

Once it is in the local directory, this can be copied to which ever server we want.

Hope  this one helps to someone else as well.

Thank you everyone for the help.