[Info-ingres] Ingres Image for Cloud Deployment ?

[Chris Clark]

On Wednesday, February 26, 2020 at 3:16:56 AM UTC-8, Roy Hann wrote:
> benjamin.orman at gmail.com wrote:
> 
> > As anyone already tried to Deploy an Ingres Database on a cloud provider
> > using Docker Image for exemple ?
> > 
> > I found an old Topic on Actian forum but every links seems dead
> > 
> > https://communities.actian.com/s/question/0D53300003kmPHSCA2/docker-meets-ingres-101-ingres-in-a-docker-container
> > 
> > 
> > I'm wondering if it's a viable solution or if when migrating to a cloud
> > deployement, It's better to also change the database solution
> 
> The link you quote is working fine for me. Dunno what might be up with
> that.
> 
> This might be of some use (even though it refers to Vector):
> https://github.com/ActianCorp/Vector-Community-Docker
> 
> If you don't actually need Docker but just want to put Ingres into some
> kind of cloud environment I've installed it on AWS instances
> (Windows and Linux) with no issues at all.

We have a few different client Docker images internally at Actian, those are the ones I've been most involved with. We should have a Jupyter one public soon.

I've not spent much time looking at the server side of deployments, we are making use of it internally and its been worth while for us and our use case. There is a public Vector Dockerfile and it could be repurposed for ActianX/Ingres with minimal changes.

As Roy commented in another thread, unless you need to deploy *many* server instances, Docker is likely to be more of a bother as you need to configure persistent storage. If this is for a handful of machines a VM may be easier to manage - either via templates and new VMs or migrating existing VMs. It is going to depend on your use case and what infrastructure is already in place. If you are already heavily invested in Docker then it probably makes more sense. If there are already VMs that are working, migrating to a new host is likely the easier path.