public inbox for [email protected]  

help / color / mirror / Atom feed

From: first last <[email protected]>
To: Alan Hodgson <[email protected]>
Cc: [email protected]
Cc: [email protected]
Subject: Re: Access a Postgres storage with two independent instances
Date: Tue, 7 May 2024 09:56:50 +0530
Message-ID: <CAG3FJTamrfzk4k+KC+bTn0axMrPqj9yaoYOzmoiRX5n90QcTFg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAG3FJTaRdS1asGHcuMk3NFB0Ap+kcjO7mk1gMY2jSZ4T0a_62A@mail.gmail.com>
	<[email protected]>

Actually what I want is multiple Postgres instances to have read and write
access to the same data storage directory. Anyway, that can not be possible
as what you say. But, when I deploy MySQL/MongoDB deployment with multiple
replicas to access the same storage, the all pods except one become
CrashLoopBackOff state. This is happening for MySQL/Mongo. When it comes to
Postgres, I deployed it with multiple pods, all the pods became healthy and
there is no such CrashLoopBackOff state occurred. But those pods access
different storages for every pod. Why this totally different from MySQL and
Mongo?

On Tue, May 7, 2024 at 2:34 AM Alan Hodgson <[email protected]>
wrote:

> On Tue, 2024-05-07 at 00:47 +0530, first last wrote:
>
> I tried to deploy Postgres deployment with Kubernetes, having three
> replicas that are accessing the same storage(PVC). Here is the configuration
> . Anyway, it can not use single storage(
> https://stackoverflow.com/questions/78436945/access-a-mysql-storage-with-two-independent-instances
> ).
>
> Finally, my question is, why the scenario is different for MySQL and
> Postgres?  Could you please help me to figure out the issue? This is for my
> Final year project testing Kubernetes using fuzzing.
>
>
> Not sure what you're trying to accomplish, but PostgreSQL can definitely
> not share storage between active postmasters. Nor can MySQL, afaik.
>

On Tue, May 7, 2024 at 2:34 AM Alan Hodgson <[email protected]>
wrote:

> On Tue, 2024-05-07 at 00:47 +0530, first last wrote:
>
> I tried to deploy Postgres deployment with Kubernetes, having three
> replicas that are accessing the same storage(PVC). Here is the configuration
> . Anyway, it can not use single storage(
> https://stackoverflow.com/questions/78436945/access-a-mysql-storage-with-two-independent-instances
> ).
>
> Finally, my question is, why the scenario is different for MySQL and
> Postgres?  Could you please help me to figure out the issue? This is for my
> Final year project testing Kubernetes using fuzzing.
>
>
> Not sure what you're trying to accomplish, but PostgreSQL can definitely
> not share storage between active postmasters. Nor can MySQL, afaik.
>

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Access a Postgres storage with two independent instances
  In-Reply-To: <CAG3FJTamrfzk4k+KC+bTn0axMrPqj9yaoYOzmoiRX5n90QcTFg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox