Ok Guys... So here's the good news.
We played around with this for a day and Aurora Actually Works straight out of the box! 🙂 🙂
This is definitely going to be our go to for our next big project. I am not a AWS expert at all (We have someone else managing that for us) but I have my own account where I play around sometimes and set up tests servers and so forth, so here is what we did to get an aurora DB working with an Aware Application Also hosted on EC2, just for couple hours to play around etc:
1) In AWS under the Database Section Select RDS
2) Create a Parameter Group and Edit the Following Settings:
Set Max Allowed Packet to 1073741824 (Not sure if this is necessary. We do this by Default)
Set log_bin_trust_function_creators to 1
3) Under instances, Follow the steps to launch an Aurora Instance and Select the parameter Group You've Set Up.
4) In AwareIM Controle Panel Under The Database Section
- Put in the Database Username & Password that you specified when creating the Database instance
- At Machine name put in the - AWS EndPoint (Example: sinov8testdb-cluster.cluster-c412232fsdoxhe.eu-west-2.rds.amazonaws.com)
- Port 3306
Restart AwareIM... Worked for us Just like normal MySQL. After Publishing a test businessSpace I connected to the DB with Workbench and checked that all the tables were created. Seemed Fine. Logged into my app and did couple of things to test. Seems like everything is working!!! This is super awesome! Cannot wait to launch our next big app on this.
Because you pay per hour of use we only started it up for 2 hours to get it working. Thus I didn't have any data to do benchmark testing etc. Just wanted to see if we can get it to work. And it did!
As I Said, I am not a technical platform guy, so please don't ask advise of anything deeper than what I did above as I wouldn't know! LOL Still learning as far as that is concerned. For test purposes I open all the ports etc just to make it easier so It's not a very secure setup. But If anyone else want to fool around feel free to give it a try.
PS:
To Connect With Workbench
Create new connection
By Host put in the AWS EndPoint
Put in Database UserName & Password.
Kind Regards & Hope you all have an awesome day!
