mysql RA: tmp files

Hi,

I have patched the version to not use tmpfile on disk. It saves I/O and usage spaces. Here the code:
http://pastebin.com/zactvNXL

And also, log typo error with demote, promote.

Best regards,

The issue names the MySQL resource agent but no file, test, or entry point; begin by locating that agent and the code handling temporary files and demote/promote logging. Done means the proposed temporary-file behavior is addressed and the demote/promote typo is corrected, with relevant tests or checks passing.

Written by the indexing model from the issue text.