We are currently in the process of moving our dev and production work on AWS. I was assigned to create the necessary VMs and databases, so I am reading here and there about these, since this is my first aws attempt.
Firstly, I noticed that I can not create serverless Aurora instance under some regions. Paris for example does not support it, where Ireland does.
We are based in Greece, so I was thinking to use the closest region (by distance) from us, and this would be the Paris region. So I created a normal Mysql database there, not realising that the serverless option was not around to choose. Then I have read that the serverless instances can not be accessed by an outside host, only from VM inside the same cluster, or an ssh tunnel to be used. Just because we have been using a private server that is behind an ssh tunnel and it was a pain to connect to at the beginning, I am not a great fan of it. Let alone that I have spend some good time to set up the jdbc connection for it on my java applications. Is that correct?
So, the real questions,
- Is the serverless approach worth the trouble? Is it better compared to the rest of the options there?
- In any case, serverless or not, the rest of the VMs should be on the same region/cluster? I am guessing that it would be faster if everything is under the same region, but is there any reason to scatter the processes to different regions?
- By using serverless I am charged by the power I am using. So I can choose the max available ram and if not used, I would be charged by a smaller fee. Does the same apply on the other options?
- On the region where the serverless option is available i am given the choice of
Provisioned with Aurora parallel query enabled, where on the Paris region I got no such option. I am guessing that there are no options because the
Provisionedis selected as default. Am I right?
Thanks in advance, Ilias