Hey,
I am currently investigating what the best solution is to using an SQL database in a dedicated server environment on AWS. I understand AWS Gamekit supports DynamoDB but we have decided on using MariaDB currently (this may change based on possible other solutions).
Our dedicated servers will be instanced, so each instance will need to make a connection when it is spun up or at the point of data entry/retrieval. So no persistent connection for instances. One or more servers may need a persistent connection however.
Currently I have taken note of the relevant marketplace ODBC solutions which are similar to using a REST system so that would be familiar.
Some of the C++ solutions I’ve seen are based on the MySQL Connector and require building a tool for the proxying of requests. I’m not sure this would be a suitable option but it is on the table right now.
Could anyone with expertise in this area throw me a bone and give me a heads up on what best practice, caveats and solutions they used.
Thanks