Re: Postgresql + containerization possible use case

Поиск
Список
Период
Сортировка
От Achilleas Mantzios
Тема Re: Postgresql + containerization possible use case
Дата
Msg-id 81f3f84b-3633-d4a2-8d0d-e7cb139f0e56@matrix.gatewaynet.com
обсуждение исходный текст
Ответ на Re: Postgresql + containerization possible use case  (Benedict Holland <benedict.m.holland@gmail.com>)
Список pgsql-general
Hi
On 13/12/21 6:11 μ.μ., Benedict Holland wrote:
Check out rolling updates with kubernetis and yes, a containerized postgresql environment is likely the best option. The really nice bit about containers is that you don't actually care about underlying hardware. You need a docker daemon. K8 manages clusters and it sounds like your use case would benefit from that.
Thanks, postgresql's bigger challenges as we all know will be upgrading OIDs, upgrading the JDBC related java code, and maybe many more related challenges. I won't say which, but we are running an unsupported version of pgsql on the ships.
So apps are much more frequently upgraded than the system of pgsql.
I will check out rolling upgrades with kubernetes. (are we talking BDR here?)

On Mon, Dec 13, 2021, 11:03 AM Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
Hi Berto,

On 13/12/21 3:03 μ.μ., Bèrto ëd Sèra wrote:

On Mon, 13 Dec 2021 at 12:41, Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
Hmm, I don't know about that. The hardware is given (existing) and limited.
You are like the 2nd person who warned about comms as being an issue with docker/containers.

Quick question: do those ships ever touch port? If so, it's not a fact that you have to rely on sat com to do updates. Just keep an on-shore table of updates and do the updates every time a ship is in a port and can use a normal port wifi com. IMHO this would be the safest option EVEN if satcom was free of cost, as it will never be half as stable as a land based com line.

Yes they do touch port, otherwise they would be of little commercial value!
I am confused here : Are we talking about traffic due to :
a) normal business traffic (designed by me/us old system based on DBMirror)
b) system updates due to some decision of the system itself and/or our team
c) normal app shipping via new images, or new .ear/.war or whatever
?
And since you are not deploying the same thing everywhere (you quote different HW everywhere, so hardly one image could be optimised for everything), you are going to need to test upgrades for each ship, which is both dangerous and expensive, if done on sat com.

We are deploying the same exact app everywhere (jboss), but of course exim4, etc other services will be specific for every ship.


My 5p
Berto


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


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

В списке pgsql-general по дате отправления:

Предыдущее
От: Benedict Holland
Дата:
Сообщение: Re: Postgresql + containerization possible use case
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Postgresql + containerization possible use case