Transparent encryption is great for protecting your laptop data from theft by stealing your laptop. It is very unlikely someone will attack your server by stealing it.
It doesn't protect you from a malicious SQL injection which drops all your tables or reads all your data.
If you are worried about someone physically stealing your data, physical encryption can help with that, but it is very likely that you only need to encrypt off site backups or other data you ship to third parties.
Also, there is no functional difference between an encrypted cloud block device (eg, truecrypt encrypted EBS volume) and transparently encrypting data and storing it directly as S3 data.
So, don't trust transparent encryption to "secure" your MySQL data. You have to have a full set of security practices in place to ensure your entire stack is as safe as possible from attack. Also, always back up your data. Just because your data is stored in S3, it doesn't mean you won't accidentally delete a wrong row, drop a wrong table or get attacked by a vulnerability.