Re: Postgresql + containerization possible use case

Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx> · Fri, 10 Dec 2021 14:01:43 +0200



    On 10/12/21 1:24 μ.μ., o1bigtenor
      wrote:

    
          On Fri, Dec 10, 2021 at 3:24
            AM Achilleas Mantzios <achill@xxxxxxxxxxxxxxxxxxxxx>
            wrote:

          
          Hi

            we are running some 140 remote servers (in the 7 seas via
            satellite connections), and in each one of them we run:

            - jboss

            - postgresql

            - uucp (not as a daemon)

            - gpsd

            - samba

            - and possibly some other services

            
            Hardware and software upgrades are very hard since there is
            no physical access to those servers by trained personnel,
            and also there is a diversity of software versions.

            
            The idea for future upgrades is to containerize certain
            aspects of the software. The questions are (I am not skilled
            in docker, only minimal contact with lxd) :

            - is this a valid use case for containerization?

            - are there any gotchas around postgersql, the reliability
            of the system ?

            - since we are talking about 4+ basic services (pgsqk,
            jboss, uucp, samba), is docker a good fit or should we be
            looking into lxd as well?

            - are there any success stories of other after following a
            similar path?

            
    Thanks

    
          My experience with LXD is that upon install you are now
            on a regular update plan that is impossible to change. 

          
    Ehhmmm we are running some old versions there already (jboss,
    pgsql), LXD would not differ in this regard.

    What do you mean? that the updates for LXD are huge? short
    spaced/very regular?

    Can you pls elaborate some more on that?

    
          This means that your very expensive data connection will
            be preempted for updates at the whim of the 
          canonical crew. Suggest not using such (most using such
            on wireless connections seem to have found 
          the resultant issues less than wonderful - - cost (on the
            data connection) being #1 and the inability to achieve 
          solid reliability crowding it for #2). 

          
    Crew has their own paid service. Business connection is for business
    not crew.

    What I am interested is, could docker be of any use in the above
    scenario? Containerization in general?

    The guys (admins/mgmt) here seem to be dead set on docker, but I
    have to guarantee some basic data safety requirements.

    
          IMO     HTH  
        
      
    -- 
Achilleas Mantzios
DBA, Analyst, IT Lead
IT DEPT
Dynacom Tankers Mgmt