The perquisites in the GitHub documentation for installing the adapter assumes a Google Cloud Run implementation and does not mention if the adapter is installable and supported on a standalone VPS running a MySQL instance. I consider myself fairly technical as I built my own VPS and MySQL DB but am aloof as to how to connect my Wix site to my standalone MySQL implementation. The readme.md file mentions the Docker Image is supported in AWS and Azure, but I am struggling with attempting to install it on my Ubuntu VPS. Am I going in the right direction and is this the correct adapter to install on a standalone VPS? If so, is there documentation specific to this implementation? Thanks,
While not an ideal solution (as this is an added cost to me): I deployed the Velo MySQL Adapter via AWS app runner after creating an AWS secret associated with my standalone DB and it works. Unfortunately, though (and probably unrelated) now the newly created external collection exhibits many, many duplicate records in one of my target tables.
I see that you figured this out using AWS, for other supported MySQL solutions you can check out this article if you haven’t found it already if you are still considering options. And yes, like you mentioned the duplicates wouldn’t have anything to do with the adapter itself and will require further debugging.