Aurora Mysql Support

[khanali21]

Hi,
I am trying to figure out if myTap supports Aurora Mysql 5.7?
thanks
Ali

[animalcarpet]

Simple answer is I've never tested it so I couldn't say definitively. That said, I can't see anything in their documentation to suggest it wouldn't. Try it and let us know how you get on, if there are any issues I'll have a look myself.

[animalcarpet]

OK, I've had a play with this now and I'm changing my answer to 'mostly'.

When you try using the installer you will get a bunch of error messages

eg
Access denied; you need (at least one of) the SUPER privilege(s) for this operation
and
ERROR 1419 (HY000): You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)

You'll get these because RDS won't give you SUPER privilege. Read this for the work around

https://stackoverflow.com/a/30874794/5870171

You will need to reboot your instance to apply the change.

That still won't give you SUPER privilege so the view test script won't work because we test DEFINER
and you need SUPER to set that to another user. The view functions are there, so they should function properly for your own purposes. There's a similar issue with the privileges tests.
The only other thing that's not working from the test scripts is the table_sha1() function, which works in native mysql 5.7 (but not in 8.0.11).

[animalcarpet]

Should probably add this into the documentation or the next person who asks.

[hepabolu]

Sounds like a good plan.

…

-- Bye, hepabolu

[animalcarpet]

#40 merged

[khanali21]

Hi @animalcarpet & @hepabolu
Thanks for quick response, apologies went on leave after posting the message. I am expecting to use myTAP in my current project and would definitely contribute back if we can.
Thanks once again.
Best Regards,
Ali

[animalcarpet]

I've had another look at this since my last message and I'll be doing another push in the next couple of days which removes the set log_bin_trust_function_creators lines from the mytap.sql file. If you have any issues with the install, comment those lines out.